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": "TableFlow \u2014 24h Reservation Reminder",
"nodes": [
{
"parameters": {
"rule": {
"interval": [
{
"field": "hours",
"hoursInterval": 1
}
]
}
},
"id": "n8n-node-cron",
"name": "Every Hour",
"type": "n8n-nodes-base.scheduleTrigger",
"typeVersion": 1,
"position": [
240,
300
]
},
{
"parameters": {
"url": "={{ $env.POCKETBASE_URL }}/api/collections/reservations/records",
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth",
"sendQuery": true,
"queryParameters": {
"parameters": [
{
"name": "filter",
"value": "status = \"confirmed\" && reserved_at >= \"{{ $now.plus(23, 'hours').toISO() }}\" && reserved_at <= \"{{ $now.plus(25, 'hours').toISO() }}\""
},
{
"name": "perPage",
"value": "100"
}
]
},
"options": {}
},
"id": "n8n-node-fetch",
"name": "Fetch Upcoming Reservations",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4,
"position": [
460,
300
]
},
{
"parameters": {
"fieldToSplitOut": "items",
"options": {}
},
"id": "n8n-node-split",
"name": "Split Into Individual Reservations",
"type": "n8n-nodes-base.splitOut",
"typeVersion": 1,
"position": [
680,
300
]
},
{
"parameters": {
"conditions": {
"string": [
{
"value1": "={{ $json.guest_email }}",
"operation": "isNotEmpty"
}
]
}
},
"id": "n8n-node-has-email",
"name": "Has Email?",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
900,
300
]
},
{
"parameters": {
"fromEmail": "={{ $env.SMTP_USER }}",
"toEmail": "={{ $json.guest_email }}",
"subject": "Reminder: Your reservation tomorrow",
"emailType": "html",
"message": "=<h2>Reminder: Your reservation is tomorrow!</h2><p>Dear <strong>{{ $json.guest_name }}</strong>,</p><p>This is a friendly reminder about your reservation:</p><ul><li><strong>Date/Time:</strong> {{ new Date($json.reserved_at).toLocaleString() }}</li><li><strong>Party size:</strong> {{ $json.party_size }} guests</li>{{ $json.notes ? '<li><strong>Notes:</strong> ' + $json.notes + '</li>' : '' }}</ul><p>If you need to cancel, please contact us as soon as possible.</p><p>We look forward to seeing you!</p>",
"options": {}
},
"id": "n8n-node-email",
"name": "Send Reminder Email",
"type": "n8n-nodes-base.emailSend",
"typeVersion": 2,
"position": [
1120,
220
],
"credentials": {
"smtp": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"url": "={{ $env.POCKETBASE_URL }}/api/collections/reservation_logs/records",
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth",
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "Content-Type",
"value": "application/json"
}
]
},
"sendBody": true,
"bodyParameters": {
"parameters": [
{
"name": "reservation_id",
"value": "={{ $('Split Into Individual Reservations').item.json.id }}"
},
{
"name": "restaurant_id",
"value": "={{ $('Split Into Individual Reservations').item.json.restaurant_id }}"
},
{
"name": "event",
"value": "reminder_sent"
},
{
"name": "details",
"value": "={{ JSON.stringify({ channel: 'email', to: $('Split Into Individual Reservations').item.json.guest_email }) }}"
}
]
},
"options": {}
},
"id": "n8n-node-log",
"name": "Log Reminder Sent",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4,
"position": [
1340,
220
]
}
],
"connections": {
"Every Hour": {
"main": [
[
{
"node": "Fetch Upcoming Reservations",
"type": "main",
"index": 0
}
]
]
},
"Fetch Upcoming Reservations": {
"main": [
[
{
"node": "Split Into Individual Reservations",
"type": "main",
"index": 0
}
]
]
},
"Split Into Individual Reservations": {
"main": [
[
{
"node": "Has Email?",
"type": "main",
"index": 0
}
]
]
},
"Has Email?": {
"main": [
[
{
"node": "Send Reminder Email",
"type": "main",
"index": 0
}
],
[]
]
},
"Send Reminder Email": {
"main": [
[
{
"node": "Log Reminder Sent",
"type": "main",
"index": 0
}
]
]
}
},
"settings": {
"executionOrder": "v1"
},
"meta": {
"notes": "Runs every hour. Queries PocketBase for confirmed reservations in the 23\u201325h window. Sends a reminder email to each guest with an email address. Logs the event in reservation_logs."
}
}
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.
smtp
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
TableFlow — 24h Reservation Reminder. Uses httpRequest, emailSend. Scheduled trigger; 6 nodes.
Source: https://github.com/SanchezAlbaladejoPablo/tableflow/blob/72a4c27d1469a2f43764787cd24332c050448e9d/automations/n8n/24h-reminder.json — 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.
Birthday Automation - Production (Fixed). Uses stopAndError, httpRequest, emailSend, bannerbear. Scheduled trigger; 86 nodes.
This workflow is an improvement of this workflow by Greg Brzezinka.
N8N-Self-Updater. Uses ssh, emailSend, httpRequest. Scheduled trigger; 27 nodes.
> An automated n8n workflow originally built for DigitalOcean-based n8n deployments, but fully compatible with any VPS or cloud hosting (e.g., AWS, Google Cloud, Hetzner, Linode, etc.) where n8n ru
What if you could spot a major sales problem—or a winning campaign—the very next morning, instead of weeks later? Imagine receiving a beautiful, data-rich alert directly in your inbox the moment your