Daily Orders Summary Email Workflow

This n8n workflow automates the collection, storage, and reporting of daily orders for an eCommerce or order management system. Scheduled to run every day at 7 PM, it retrieves today’s orders from Airtable, formats them into an HTML report, and sends the summary via Gmail. Additionally, it captures new order data through a webhook, stores each order in Airtable, and provides visual notes for setup guidance.

Here’s how the workflow functions:

1. The cron trigger at 7 PM activates the workflow.

2. The ‘Yesterday Date’ node generates ISO timestamps for yesterday and now.

3. The ‘Airtable Get Today’s Orders’ node fetches orders from Airtable placed within the specified time frame.

4. The ‘HTML’ node formats these orders into an HTML table with styling.

5. The ‘Send to Gmail’ node emails the daily summary to a specified address.

6. The ‘Store Order’ node records new incoming orders from a webhook into Airtable.

7. The ‘Webhook’ node receives POST requests with order details, which activates the order storage.

8. Several sticky notes provide setup instructions, including Airtable table configuration, Gmail credentials, and testing steps.

This workflow is ideal for businesses needing automated daily sales reporting, order tracking, or eCommerce management, seamlessly integrating order collection and reporting in a low-maintenance process.