This workflow corresponds to n8n.io template #8077 — we link there as the canonical source.
This workflow follows the Emailsend → HTTP Request 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 →
{
"name": "Graceful Deliveries \u2013 Service Scheduling & Route Planner (Notion/Sheets-Ready)",
"nodes": [
{
"name": "\ud83d\udcdd Description (Read Me First)",
"type": "n8n-nodes-base.stickyNote",
"position": [
20,
-20
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"name": "\ud83e\uddf0 Setup & Credentials",
"type": "n8n-nodes-base.stickyNote",
"position": [
20,
440
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"name": "\ud83d\udce6 Notion / Sheets Schema",
"type": "n8n-nodes-base.stickyNote",
"position": [
820,
-20
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"name": "\ud83e\udded Data Mapper (Sample Payload)",
"type": "n8n-nodes-base.stickyNote",
"position": [
820,
380
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"name": "Webhook (Bookings)",
"type": "n8n-nodes-base.webhook",
"position": [
20,
920
],
"parameters": {},
"typeVersion": 1
},
{
"name": "Parse Booking",
"type": "n8n-nodes-base.function",
"position": [
300,
920
],
"parameters": {},
"typeVersion": 2
},
{
"name": "Geocode (OSM Nominatim)",
"type": "n8n-nodes-base.httpRequest",
"position": [
560,
860
],
"parameters": {},
"typeVersion": 4
},
{
"name": "Format Geocode",
"type": "n8n-nodes-base.function",
"position": [
800,
860
],
"parameters": {},
"typeVersion": 2
},
{
"name": "Merge Data",
"type": "n8n-nodes-base.merge",
"position": [
1040,
920
],
"parameters": {},
"typeVersion": 2
},
{
"name": "Build Summary & Links",
"type": "n8n-nodes-base.function",
"position": [
1260,
920
],
"parameters": {},
"typeVersion": 2
},
{
"name": "Telegram \u2192 Owner Alert",
"type": "n8n-nodes-base.telegram",
"position": [
1500,
800
],
"parameters": {},
"typeVersion": 1
},
{
"name": "Wait until 1h before",
"type": "n8n-nodes-base.wait",
"position": [
1500,
1040
],
"parameters": {},
"typeVersion": 1
},
{
"name": "Email \u2192 Client (Pre-arrival)",
"type": "n8n-nodes-base.emailSend",
"position": [
1740,
1040
],
"parameters": {},
"typeVersion": 2
},
{
"name": "Respond to Webhook",
"type": "n8n-nodes-base.respondToWebhook",
"position": [
1740,
800
],
"parameters": {},
"typeVersion": 1
},
{
"name": "\u2728 Optional Add-Ons",
"type": "n8n-nodes-base.stickyNote",
"position": [
2060,
760
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"settings": {},
"staticData": {},
"connections": {
"Merge Data": {
"main": [
[
{
"node": "Build Summary & Links",
"type": "main",
"index": 0
}
]
]
},
"Parse Booking": {
"main": [
[
{
"node": "Geocode (OSM Nominatim)",
"type": "main",
"index": 0
}
],
[
{
"node": "Merge Data",
"type": "main",
"index": 0
}
]
]
},
"Format Geocode": {
"main": [
[
{
"node": "Merge Data",
"type": "main",
"index": 0
}
]
]
},
"Webhook (Bookings)": {
"main": [
[
{
"node": "Parse Booking",
"type": "main",
"index": 0
}
]
]
},
"Wait until 1h before": {
"main": [
[
{
"node": "Email \u2192 Client (Pre-arrival)",
"type": "main",
"index": 0
}
]
]
},
"Build Summary & Links": {
"main": [
[
{
"node": "Telegram \u2192 Owner Alert",
"type": "main",
"index": 0
},
{
"node": "Wait until 1h before",
"type": "main",
"index": 0
},
{
"node": "Respond to Webhook",
"type": "main",
"index": 0
}
]
]
},
"Geocode (OSM Nominatim)": {
"main": [
[
{
"node": "Format Geocode",
"type": "main",
"index": 0
}
]
]
}
}
}
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
This workflow contains community nodes that are only compatible with the self-hosted version of n8n.
Source: https://n8n.io/workflows/8077/ — 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.
qualiopi. Uses airtable, telegram, emailSend, httpRequest. Webhook trigger; 51 nodes.
Chat with the news. Uses telegram, httpRequest, emailSend, googleSheets. Webhook trigger; 18 nodes.
HotBot — 01 Form Pipeline. Uses googleSheets, telegram, emailSend, httpRequest. Webhook trigger; 8 nodes.
Overview
My workflow 4. Uses httpRequest, emailSend, telegram. Webhook trigger; 6 nodes.