This workflow follows the Airtable → Gmail recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"nodes": [
{
"id": "faade37e-908d-494c-af74-93c8f01adcc5",
"name": "Everyday at 7PM",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
440,
520
],
"parameters": {
"rule": {
"interval": [
{
"field": "cronExpression",
"expression": "0 0 19 * * *"
}
]
}
},
"typeVersion": 1.2
},
{
"id": "4abddfea-fee9-419c-92c4-3055faa2dd09",
"name": "Airtable Get Today's Orders",
"type": "n8n-nodes-base.airtable",
"position": [
900,
520
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appdtUVSpfWswMwNC",
"cachedResultUrl": "https://airtable.com/appdtUVSpfWswMwNC",
"cachedResultName": "Untitled Base"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tblu6F5rLbR3Axtgj",
"cachedResultUrl": "https://airtable.com/appdtUVSpfWswMwNC/tblu6F5rLbR3Axtgj",
"cachedResultName": "orders"
},
"options": {},
"operation": "search",
"filterByFormula": "=AND(time < \"{{ $json.now }}\", time > \"{{ $json.yesterday }}\")"
},
"credentials": {
"airtableTokenApi": {
"name": "<your credential>"
}
},
"typeVersion": 2.1
},
{
"id": "ea29159e-3674-4385-a0bd-2a9df7d7117c",
"name": "Yesterday Date",
"type": "n8n-nodes-base.code",
"position": [
660,
520
],
"parameters": {
"jsCode": "// Create a new date object for yesterday, 7pm\nconst yesterday = new Date();\nyesterday.setDate( new Date().getDate() - 1); \nyesterday.setHours(19, 0, 0, 0);\nconst isoString = yesterday.toISOString();\nreturn {yesterday:isoString, now:new Date().toISOString()}"
},
"typeVersion": 2
},
{
"id": "8254aa63-2682-4c48-8843-c93830c724de",
"name": "HTML",
"type": "n8n-nodes-base.html",
"position": [
1120,
520
],
"parameters": {
"html": "<!DOCTYPE html>\n<html>\n<head>\n <meta charset=\"UTF-8\" />\n</head>\n<body>\n <table>\n <tr> \n {{ Object.keys($input.first().json).map(propname=>'<td>'+propname+'</td>').join('') \n }}\n </tr>\n \n {{ $input.all().map(order=>{\n \n return \"<tr>\"+Object.values(order.json).map(prop=>{\n return \"<td>\"+prop+\"</td>\"\n }).join('') +\"</tr>\"\n }).join('') \n }}\n </table>\n</body>\n</html>\n\n<style>\n.container {\n background-color: #ffffff;\n text-align: center;\n padding: 16px;\n border-radius: 8px;\n}\n\nh1 {\n color: #ff6d5a;\n font-size: 24px;\n font-weight: bold;\n padding: 8px;\n}\n\nh2 {\n color: #909399;\n font-size: 18px;\n font-weight: bold;\n padding: 8px;\n}\n</style>\n"
},
"executeOnce": true,
"typeVersion": 1.2
},
{
"id": "5e9f6ad7-e4fc-41e3-991b-cae9210dfb71",
"name": "Set Order Fields",
"type": "n8n-nodes-base.set",
"position": [
660,
220
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "2c2f9e3c-696a-466a-8bfe-5c8aa942c9ab",
"name": "time",
"type": "string",
"value": "={{ new Date().toISOString() }}"
},
{
"id": "5618b2a7-8149-469d-87ee-535f1adac121",
"name": "orderID",
"type": "string",
"value": "={{ $json.body.orderID }}"
},
{
"id": "dc31db55-24e4-468f-a9fd-456298f5e5ab",
"name": "orderPrice",
"type": "number",
"value": "={{ $json.body.orderPrice }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "68eaa8f7-3b67-484e-8bad-87e621adc1df",
"name": "Send to Gmail",
"type": "n8n-nodes-base.gmail",
"position": [
1340,
520
],
"parameters": {
"sendTo": "axelrose20272027@gmail.com",
"message": "={{ $json.html }}",
"options": {},
"subject": "Daily Order Summary"
},
"credentials": {
"gmailOAuth2": {
"name": "<your credential>"
}
},
"typeVersion": 2.1
},
{
"id": "9f22bedc-fbe1-421b-8212-189c7d436cab",
"name": "Store Order",
"type": "n8n-nodes-base.airtable",
"position": [
900,
220
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appdtUVSpfWswMwNC",
"cachedResultUrl": "https://airtable.com/appdtUVSpfWswMwNC",
"cachedResultName": "Untitled Base"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tblu6F5rLbR3Axtgj",
"cachedResultUrl": "https://airtable.com/appdtUVSpfWswMwNC/tblu6F5rLbR3Axtgj",
"cachedResultName": "orders"
},
"columns": {
"value": {
"orderID": 0,
"customerID": 0,
"orderPrice": 0
},
"schema": [
{
"id": "time",
"type": "dateTime",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "time",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "orderID",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "orderID",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "customerID",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "customerID",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "orderPrice",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "orderPrice",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "orderStatus",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "orderStatus",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": []
},
"options": {
"typecast": true
},
"operation": "create"
},
"credentials": {
"airtableTokenApi": {
"name": "<your credential>"
}
},
"typeVersion": 2.1
},
{
"id": "6ace0e8f-85e1-45bc-ae81-331c5722ef46",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
340,
160
],
"parameters": {
"width": 857.9236217062975,
"height": 220.18022408852067,
"content": "### New order is sent to the Webhook via POST with params {orderID, orderPrice}"
},
"typeVersion": 1
},
{
"id": "6907ae8d-90b7-4e07-883d-3ebd4440d811",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
340,
460
],
"parameters": {
"width": 1202.2434730902464,
"height": 235.62797364881823,
"content": "### Daily summary sent to email at 7PM"
},
"typeVersion": 1
},
{
"id": "848c6acb-2f9c-4d85-8349-a4a31204922b",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-620,
-80
],
"parameters": {
"color": 4,
"width": 607.7708924207209,
"height": 893.1187181589532,
"content": "# Aggregate Daily Orders with Airtable\n### This workflow will collect order data as it is produced, then send a summary email of all orders at the end of every day, formatted in a table.\n\n## Setup:\n 1. Create a new table in Airtable and give it a field *time* with type date, *orderID* with type number, and *orderPrice* also with type number. \n 2. Create a new access token if you haven't already at https://airtable.com/create/tokens/new. Make sure to give the token the scopes *data.records:read*, *data.records:write*, *schema.bases:read* and access to whichever table you choose to store the orders. A pop-up window appears with the token. Use this token to make `Create New Credential` > `Access Token` for Airtable in the `Store Order` and `Airtable Get Today's Orders` nodes.\n 3. Create access credentials for your Gmail as described here: https://developers.google.com/workspace/guides/create-credentials. Use the credentials from your *client_secret.json* in the `Send to Gmail` node.\n 4. In the `Store Order` node, change *Base* and *Table* to the database and table in your Airtable account you wish to use to store orders. Make sure to use these same values in the `Airtable Get Today's Orders` node.\n 5. Every time an order is created in your system, send a POST request to Webhook from your order software. Each request must contain a single order containing fields *'orderID'* and *'orderPrice'* (or, edit `Set Order Fields` to select which incoming fields you wish to save)\n 6. Change the schedule time for sending email from `Everyday at 7PM` to whichever time you choose. \n \n\n## Test:\n- Activate the workflow.\n- From the node `Webhook`, copy *Production URL*\n- Send the following CURL request to the URL given to you:\n` curl -X POST -H \"Content-Type: application/json\" -d '{\"orderID\": 12345, \"orderPrice\": 99.99}' YOUR_URL_HERE`\n- It should say *Node executed successfully*. Now check your Airtable and confirm the order was stored in the right place."
},
"typeVersion": 1
},
{
"id": "d9a5ef05-beba-480f-967e-840cf1b71248",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
200,
240
],
"parameters": {
"color": 3,
"width": 170,
"height": 80,
"content": "- New Order!"
},
"typeVersion": 1
},
{
"id": "0f433e34-79cd-42d0-9b56-4a306eb91907",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
200,
540
],
"parameters": {
"color": 3,
"width": 170,
"height": 80,
"content": " - It's 7PM!"
},
"typeVersion": 1
},
{
"id": "fb9c4b49-ee1f-4233-8277-4c35fb423fde",
"name": "Webhook",
"type": "n8n-nodes-base.webhook",
"position": [
440,
220
],
"parameters": {
"path": "e9e62c98-390d-4d16-bc77-a13b043bf1cf",
"options": {},
"httpMethod": "POST"
},
"typeVersion": 2
}
],
"connections": {
"HTML": {
"main": [
[
{
"node": "Send to Gmail",
"type": "main",
"index": 0
}
]
]
},
"Webhook": {
"main": [
[
{
"node": "Set Order Fields",
"type": "main",
"index": 0
}
]
]
},
"Yesterday Date": {
"main": [
[
{
"node": "Airtable Get Today's Orders",
"type": "main",
"index": 0
}
]
]
},
"Everyday at 7PM": {
"main": [
[
{
"node": "Yesterday Date",
"type": "main",
"index": 0
}
]
]
},
"Set Order Fields": {
"main": [
[
{
"node": "Store Order",
"type": "main",
"index": 0
}
]
]
},
"Airtable Get Today's Orders": {
"main": [
[
{
"node": "HTML",
"type": "main",
"index": 0
}
]
]
}
}
}
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
airtableTokenApigmailOAuth2
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
How this works
Receive a daily email summary of your Airtable orders at 7PM, neatly formatted in HTML for easy reading, saving you time on manual checks and ensuring you stay updated without effort. This workflow suits small business owners or e-commerce managers who track daily sales in Airtable and prefer Gmail notifications over dashboards. The key step involves pulling today's orders from Airtable, processing the date and fields, then compiling them into an HTML email before sending via Gmail and optionally storing the summary back in Airtable.
Use this when you need a consistent evening overview of orders to plan next-day actions, especially for low-volume operations where real-time alerts aren't essential. Avoid it for high-frequency transactions requiring instant notifications, or if your data source isn't Airtable. Common variations include adjusting the cron schedule for different times or adding filters in the code node to focus on specific order types like pending payments.
About this workflow
Code. Uses scheduleTrigger, airtable, html, gmail. Scheduled trigger; 13 nodes.
Source: https://github.com/Zie619/n8n-workflows — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
This workflow runs every morning, reads an active watchlist from Airtable, scrapes Google Shopping results via ScraperAPI, and writes offer snapshots back to Airtable for price history. It then compil
Airtable, N8N Nodes Scraperapi Official, Gmail
This workflow will collect order data as it is produced, then send a summary email of all orders at the end of every day, formatted in a table. It receives new orders via webhook and stores in Airtabl
Airtable, Gmail
Codeur.com — RSS Project Alert. Uses rssFeedRead, airtable, gmail. Scheduled trigger; 7 nodes.
RSS Feed Read, Airtable, Gmail
"## Video Introduction [](https://youtu.be/lQh1fuIrBN8)
Airtable, Gmail
YOUR_ID 4. Uses gmail, googleDrive, googleSheets, httpRequest. Scheduled trigger; 53 nodes.
Gmail, Google Drive, Google Sheets +1