{ "edges": [ { "to": "fb630893-1e98-4cbe-afdb-4e54daae2004", "from": "de7b7941-e2c4-4d39-bd6c-0477ee0b08fb", "toPort": "0", "fromPort": "0" }, { "to": "f1f12bdd-cfe1-4d81-a3c2-60dfcf41630d", "from": "de7b7941-e2c4-4d39-bd6c-0477ee0b08fb", "toPort": "0", "fromPort": "1" }, { "to": "de7b7941-e2c4-4d39-bd6c-0477ee0b08fb", "from": "2c74a24d-e217-4a71-a9aa-1a096e38c7ce", "toPort": "0", "fromPort": "0" }, { "to": "607a2e0f-f9f7-4056-8c83-45a3dfee211b", "from": "6693ed50-b9f3-47a9-8848-38f56e7a2be4", "toPort": "0", "fromPort": "0" }, { "to": "6693ed50-b9f3-47a9-8848-38f56e7a2be4", "from": "10a49736-3249-4683-ac02-91cdd36f2683", "toPort": "0", "fromPort": "0" }, { "to": "2c74a24d-e217-4a71-a9aa-1a096e38c7ce", "from": "607a2e0f-f9f7-4056-8c83-45a3dfee211b", "toPort": "0", "fromPort": "0" }, { "to": "10a49736-3249-4683-ac02-91cdd36f2683", "from": "d4309fb4-993f-47fe-9d1b-06cade209599", "toPort": "0", "fromPort": "0" }, { "to": "10a49736-3249-4683-ac02-91cdd36f2683", "from": "48d24d3e-064b-4ec5-a905-a90cdf5edf5e", "toPort": "0", "fromPort": "0" }, { "to": "10a49736-3249-4683-ac02-91cdd36f2683", "from": "ab68acee-89bb-46ca-8639-beb8b3040e75", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "ab68acee-89bb-46ca-8639-beb8b3040e75", "name": "Trigger EU_UK 10:00 UTC", "type": "trigger", "params": { "kind": "n8n-nodes-base.scheduleTrigger", "rule": { "interval": [ { "field": "cronExpression", "expression": "0 10 * * 1-5" } ] } }, "position": [ -608, 304 ] }, { "id": "10a49736-3249-4683-ac02-91cdd36f2683", "name": "Determine Group", "type": "code", "params": { "jsCode": "// Maps the current UTC hour to an audience region plus a daily send cap.\n// Ranges are non-overlapping so each trigger hits exactly one group.\nconst hour = new Date().getUTCHours();\nlet group, daily_limit;\n\nif (hour >= 9 && hour < 13) {\n // EU & UK working hours (morning Europe)\n group = 'EU_UK';\n daily_limit = 45;\n} else if (hour >= 14 && hour < 20) {\n // North America working hours (morning/midday NA)\n group = 'NA';\n daily_limit = 90;\n} else {\n // Remaining hours cover Australia / Asia-Pacific\n group = 'AU';\n daily_limit = 15;\n}\n\nreturn [{ json: { group, daily_limit } }];\n" }, "position": [ -416, 512 ] }, { "id": "6693ed50-b9f3-47a9-8848-38f56e7a2be4", "name": "Read Contacts", "type": "integration", "params": { "options": {}, "service": "googleSheets", "operation": "read", "sheetName": { "__rl": true, "mode": "list", "value": "", "cachedResultUrl": "", "cachedResultName": "" }, "documentId": { "__rl": true, "mode": "list", "value": "", "cachedResultUrl": "", "cachedResultName": "" } }, "position": [ -160, 512 ] }, { "id": "607a2e0f-f9f7-4056-8c83-45a3dfee211b", "name": "Filter and Limit", "type": "code", "params": { "jsCode": "const group = $('Determine Group').first().json.group;\nconst daily_limit = $('Determine Group').first().json.daily_limit;\n\nconst countryGroups = {\n 'Austria': 'EU_UK', 'Belgium': 'EU_UK', 'France': 'EU_UK',\n 'Germany': 'EU_UK', 'Italy': 'EU_UK', 'Netherlands': 'EU_UK',\n 'Norway': 'EU_UK', 'Spain': 'EU_UK', 'Sweden': 'EU_UK',\n 'Switzerland': 'EU_UK', 'United Kingdom': 'EU_UK',\n 'Canada': 'NA', 'United States': 'NA',\n 'Australia': 'AU'\n};\n\nconst filtered = items.filter(item => {\n const country = (item.json['Country'] || '').trim();\n const emailSent = (item.json['email_sent'] || '').toString().trim();\n const email = (item.json['Email'] || '').trim();\n return (\n countryGroups[country] === group &&\n emailSent === '' &&\n email.includes('@')\n );\n});\n\nreturn filtered.slice(0, daily_limit);" }, "position": [ 64, 512 ] }, { "id": "2c74a24d-e217-4a71-a9aa-1a096e38c7ce", "name": "Build Email", "type": "set", "params": { "options": {}, "assignments": { "assignments": [ { "id": "field-001", "name": "to", "type": "string", "value": "={{ $json['Email'] }}" }, { "id": "field-002", "name": "contact_email", "type": "string", "value": "={{ $json['Email'] }}" }, { "id": "field-003", "name": "subject", "type": "string", "value": "=Quick question to {{ $('Read Contacts').item.json.Company }} Team" }, { "id": "field-004", "name": "body", "type": "string", "value": "=\n \n \n \n

Hi {{ $json['First Name'] }},

\n\n

\n [Write your opening line here. Mention something specific about the recipient or their company.]\n

\n\n

\n [Explain the problem you help solve, in one short paragraph.]\n

\n\n

\n [Your product or service name] helps [target persona] to [outcome], without [common pain point].\n

\n\n

\n Happy to share more if relevant - feel free to reply with \"yes\" and I will send details.\n

\n\n

\n Best regards,

\n [Your Name] - [Your Company]
\n [Your title]
\n https://example.com\n

" }, { "id": "field-005", "name": "group_sent", "type": "string", "value": "={{ $('Determine Group').first().json.group }}" } ] } }, "position": [ 288, 512 ] }, { "id": "de7b7941-e2c4-4d39-bd6c-0477ee0b08fb", "name": "Send Gmail", "type": "integration", "params": { "sendTo": "={{ $json.to }}", "message": "={{ $json.body }}", "options": { "senderName": "", "appendAttribution": false }, "service": "gmail", "subject": "={{ $json.subject }}", "operation": "read" }, "position": [ 512, 512 ] }, { "id": "fb630893-1e98-4cbe-afdb-4e54daae2004", "name": "Update Row Success", "type": "integration", "params": { "columns": { "value": { "status": "sent", "error_msg": "", "sent_date": "={{ $now.toFormat('yyyy-MM-dd HH:mm:ss') }}", "email_sent": "yes", "group_sent": "={{ $('Determine Group').item.json.group }}", "row_number": "={{ $('Read Contacts').item.json.row_number }}" }, "schema": [ { "id": "row_number", "type": "number", "display": true, "removed": false, "readOnly": true, "required": false, "displayName": "row_number", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "email_sent", "type": "string", "display": true, "removed": false, "required": false, "displayName": "email_sent", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "sent_date", "type": "string", "display": true, "removed": false, "required": false, "displayName": "sent_date", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "status", "type": "string", "display": true, "removed": false, "required": false, "displayName": "status", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "group_sent", "type": "string", "display": true, "removed": false, "required": false, "displayName": "group_sent", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "error_msg", "type": "string", "display": true, "removed": false, "required": false, "displayName": "error_msg", "defaultMatch": false, "canBeUsedToMatch": true } ], "mappingMode": "defineBelow", "matchingColumns": [ "row_number" ], "attemptToConvertTypes": false, "convertFieldsToString": false }, "options": {}, "service": "googleSheets", "operation": "update", "sheetName": { "__rl": true, "mode": "list", "value": "", "cachedResultUrl": "", "cachedResultName": "" }, "documentId": { "__rl": true, "mode": "list", "value": "", "cachedResultUrl": "", "cachedResultName": "" } }, "position": [ 960, 352 ] }, { "id": "f1f12bdd-cfe1-4d81-a3c2-60dfcf41630d", "name": "Update Row Error", "type": "integration", "params": { "columns": { "value": { "status": "failed", "error_msg": "={{ $json.error?.message || $json.error || 'Unknown error' }}", "sent_date": "={{ $now.toFormat('yyyy-MM-dd HH:mm:ss') }}", "email_sent": "no", "group_sent": "={{ $('Determine Group').item.json.group }}", "row_number": "={{ $('Read Contacts').item.json.row_number }}" }, "schema": [ { "id": "row_number", "type": "number", "display": true, "removed": false, "readOnly": true, "required": false, "displayName": "row_number", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "email_sent", "type": "string", "display": true, "removed": false, "required": false, "displayName": "email_sent", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "sent_date", "type": "string", "display": true, "removed": false, "required": false, "displayName": "sent_date", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "status", "type": "string", "display": true, "removed": false, "required": false, "displayName": "status", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "group_sent", "type": "string", "display": true, "removed": false, "required": false, "displayName": "group_sent", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "error_msg", "type": "string", "display": true, "removed": false, "required": false, "displayName": "error_msg", "defaultMatch": false, "canBeUsedToMatch": true } ], "mappingMode": "defineBelow", "matchingColumns": [ "row_number" ], "attemptToConvertTypes": false, "convertFieldsToString": false }, "options": {}, "service": "googleSheets", "operation": "update", "sheetName": { "__rl": true, "mode": "list", "value": "", "cachedResultUrl": "", "cachedResultName": "" }, "documentId": { "__rl": true, "mode": "list", "value": "", "cachedResultUrl": "", "cachedResultName": "" } }, "position": [ 960, 672 ] }, { "id": "48d24d3e-064b-4ec5-a905-a90cdf5edf5e", "name": "Trigger NA 18:00 UTC", "type": "trigger", "params": { "kind": "n8n-nodes-base.scheduleTrigger", "rule": { "interval": [ { "field": "cronExpression", "expression": "0 18 * * 1-5" } ] } }, "position": [ -608, 512 ] }, { "id": "d4309fb4-993f-47fe-9d1b-06cade209599", "name": "Trigger AU 1:00 UTC", "type": "trigger", "params": { "kind": "n8n-nodes-base.scheduleTrigger", "rule": { "interval": [ { "field": "cronExpression", "expression": "0 01 * * 1-5" } ] } }, "position": [ -608, 704 ] } ] }

Send timezone-aware drip emails with Gmail and Google Sheets using daily limits