Jay Hartley This workflow corresponds to n8n.io template #2407 — we link there as the canonical source.
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": "user@example.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
About this workflow
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 Airtable. At 7PM every day, it sends a summary email with the day's orders in a HTML…
Source: https://n8n.io/workflows/2407/ — 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.
Code. Uses scheduleTrigger, airtable, html, gmail. Scheduled trigger; 13 nodes.
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
Recruiting agency. Uses typeformTrigger, airtable, httpRequest, googleDrive. Event-driven trigger; 36 nodes.
Typeform Trigger, Airtable, HTTP Request +4
The FamilyFlow Assistant is your n8n-powered 🚀 companion designed to streamline daily parenting tasks, reduce mental load, and bring a bit more organization and fun into your family life. This versati
Start, Email Send, Telegram Trigger +2