Get a clear daily view of orders without manual work. New orders are captured as they happen and stored in Airtable. At 7 PM, a summary email lands in your inbox so you can close the day with confidence.

Here is how it runs end to end. A webhook receives each order with orderID and orderPrice. The data is stamped with the current time and saved to your Airtable table. At 7 PM, a scheduled trigger computes the window from yesterday at 7 PM to now, then searches Airtable for orders in that range. The results are turned into a simple HTML table and sent through Gmail. You get both real time capture and a daily digest in one flow.

Setup is simple. Create an Airtable base with fields time, orderID, and orderPrice, connect your Airtable token, and authorize Gmail. Point your order system to the n8n webhook or test with curl. Expect a reliable daily report, less manual copying, and cleaner data. Great for small shops, delivery teams, or any service that needs a daily sales snapshot.

• Webhook capture of each new order with orderID and orderPrice
• Automatic timestamp added to every order before storage
• Airtable create action to store orders with typecasting enabled
• Daily schedule at 7 PM to start the summary routine
• Code step calculates yesterday at 7 PM and current time for filtering
• Airtable search with a filter formula to get only the last day’s orders
• HTML builder turns the records into a clean table for email
• Gmail send action delivers the summary with subject and body set

• Reduce manual reporting from 60 minutes to 2 minutes per day
• Automate 100% of daily order summary creation at a fixed cutoff time
• Improve data accuracy by up to 90% by removing copy and paste steps
• Connect Airtable and Gmail seamlessly for capture and reporting
• Handle growing order volume without adding extra admin work

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Airtable, Gmail and Webhook.site. See the Tools Required section above for links to create accounts with these services.
3. In Airtable, create a table named orders with fields: time (date time), orderID (number), and orderPrice (number).
4. In the Airtable dashboard, create a Personal Access Token with data.records:read, data.records:write, and schema.bases:read scopes. Copy the token.
5. In n8n, open the Store Order node. Under the credential dropdown, click Create new credential and choose Access Token for Airtable. Paste your token and save. Repeat for the Airtable Get Today's Orders node.
6. Set the Base and Table in both Airtable nodes to your Airtable base and the orders table.
7. Open the Gmail node. In the credential dropdown, click Create new credential and choose OAuth2 for Gmail. Follow the on screen steps to authorize your Google account.
8. Update the Gmail sendTo field to your inbox. Keep the subject and message mapping as provided.
9. Open the Schedule Trigger node and adjust the time if needed. The cron expression 0 0 19 * * * sends at 7 PM server time.
10. Copy the Production URL from the Webhook node. From your order system, send a POST request with JSON {"orderID": 12345, "orderPrice": 99.99}. You can test with curl or first inspect payloads using Webhook.site before pointing to n8n.
11. Confirm a new record appears in Airtable after a test POST. To test the summary, temporarily change the schedule to run in the next minute, then verify the Gmail email with the HTML table arrives.
12. Troubleshoot tips: if no records appear in the summary, check the time zone of your server and Airtable date field, ensure the filter formula uses ISO dates, and verify Gmail credentials are connected.