Schedule Trigger Automate

This workflow is ideal for:

• E-commerce businesses looking to automate order tracking and reporting.
• Small business owners who need a simple and efficient way to manage daily order summaries.
• Developers and automation enthusiasts wanting to integrate various services like Airtable and Gmail without extensive coding.
• Teams that require real-time updates on orders and daily summaries for better decision-making.

This workflow addresses the challenge of manually tracking and summarizing daily orders. It automates the process of:

• Collecting order data from a webhook in real-time.
• Storing order details in Airtable for easy access and management.
• Sending a formatted summary email every day at 7 PM, ensuring stakeholders are informed without manual effort.

1. Schedule Trigger: The workflow is triggered every day at 7 PM using a cron expression.
2. Yesterday Date Node: It calculates the date and time for yesterday at 7 PM and the current date and time.
3. Airtable Get Today's Orders: It retrieves today's orders from Airtable using a search formula that filters orders based on the calculated dates.
4. HTML Node: The retrieved orders are formatted into an HTML table for a visually appealing email summary.
5. Send to Gmail: The formatted HTML summary is sent to a specified email address, ensuring stakeholders receive a daily report of orders.
6. Store Order: When a new order is received via a webhook, it stores relevant order details (such as orderID and orderPrice) in Airtable for record-keeping.