Store Orders in Airtable & Send Daily Email Summaries
Captures new orders via webhook, stores them in Airtable, and emails a formatted daily summary table at 7 PM. Ideal for e-commerce order tracking and reporting.
This workflow automates order management by receiving new orders through a webhook endpoint, extracting key fields like orderID and orderPrice, and storing them securely in an Airtable base. At the end of each day (configurable to 7 PM), it queries Airtable for that day's orders, formats them into a professional HTML table, and sends a summary email via Gmail.
Benefits include real-time order logging without manual entry, effortless daily overviews for teams, and reduced errors in tracking sales data. It saves hours weekly on reporting, enabling quick insights into daily revenue and order volume.
Use cases span e-commerce stores, online marketplaces, or any system generating orders (e.g., Shopify, WooCommerce via webhook). Customize fields in the Set node for additional data like customer info, integrate with your order platform's API, and scale for high-volume operations. Setup is straightforward with provided credentials for Airtable and Gmail.
New buyers can create an account from the cart to unlock a controlled $10 first-purchase credit on eligible orders of $25+.
Related bundle
HR & Recruitment Pipeline
7 hand-picked workflows for $39.00.
That is $5.57 each, vs $13.99 for this one alone.
View bundleSecure checkout powered by Stripe
Support
How to import this workflow into n8n
- 1Purchase or download the workflow to get the n8n workflow JSON file.
- 2In your n8n instance, open Workflows and choose "Import from File" (or paste the JSON with Ctrl+V on the canvas).
- 3Open each node marked with a credential warning and connect your own accounts and API keys.
- 4Run the workflow once manually to verify the data flow, then toggle it to Active.
Related HR & Operations workflows
- Automate CV Screening with AI-Powered Analysis$14.99
- Automated AI Resume Screening and Evaluation with Google Sheets and Drive$14.99
- Automate Candidate Evaluation with AI and Slack Integration$14.99
- Automate HR Processes via WhatsApp with AI and Google Workspace$19.99
- AI-Automated HR Workflow for CV Analysis and Candidate Evaluation$14.99
- Customer Onboarding Automation with HubSpot, Email Sequences, and Team Alerts$14.99
More from Bruno Lindberg
Need this deployed? We'll set it up for you.
Our automation experts deploy this workflow in your stack, connect your accounts, and verify it works — or build a custom solution from scratch.