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": "Vitalis - Email Recordatorio 24hs",
"nodes": [
{
"parameters": {
"rule": {
"interval": [
{
"field": "days",
"daysInterval": 1,
"triggerAtHour": 9,
"triggerAtMinute": 0
}
]
}
},
"id": "node-cron",
"name": "Cron 9:00",
"type": "n8n-nodes-base.scheduleTrigger",
"typeVersion": 1.2,
"position": [
240,
300
]
},
{
"parameters": {
"jsCode": "const tomorrow = new Date();\ntomorrow.setDate(tomorrow.getDate() + 1);\nconst yyyy = tomorrow.getFullYear();\nconst mm = String(tomorrow.getMonth() + 1).padStart(2, '0');\nconst dd = String(tomorrow.getDate()).padStart(2, '0');\nreturn [{ json: { fecha_manana: `${yyyy}-${mm}-${dd}` } }];"
},
"id": "node-fecha",
"name": "Calcular Ma\u00f1ana",
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
440,
300
]
},
{
"parameters": {
"method": "GET",
"url": "https://gsmrccofuegcmujycydd.supabase.co/rest/v1/turnos",
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "apikey",
"value": "={{ $env.SUPABASE_ANON_KEY }}"
},
{
"name": "Authorization",
"value": "=Bearer {{ $env.SUPABASE_SERVICE_KEY }}"
}
]
},
"sendQuery": true,
"queryParameters": {
"parameters": [
{
"name": "select",
"value": "id,fecha,hora_inicio,estado,paciente:pacientes(nombre,apellido,email),profesional:profesionales(nombre,apellido),centro:centros(nombre)"
},
{
"name": "fecha",
"value": "=eq.{{ $json.fecha_manana }}"
},
{
"name": "estado",
"value": "=in.(reservado,confirmado)"
}
]
}
},
"id": "node-fetch-turnos",
"name": "Buscar Turnos Ma\u00f1ana",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
640,
300
]
},
{
"parameters": {
"jsCode": "const turnos = $input.all();\nconst resultado = [];\n\nfor (const item of turnos) {\n const t = item.json;\n const email = t.paciente?.email;\n if (!email) continue;\n\n const nombre = `${t.paciente?.nombre ?? ''} ${t.paciente?.apellido ?? ''}`.trim();\n const profesional = `${t.profesional?.nombre ?? ''} ${t.profesional?.apellido ?? ''}`.trim();\n const centro = t.centro?.nombre ?? '';\n const fecha = t.fecha ?? '';\n const hora = t.hora_inicio ? t.hora_inicio.slice(0,5) : '';\n\n let fechaDisplay = fecha;\n try {\n const d = new Date(fecha + 'T12:00:00');\n fechaDisplay = d.toLocaleDateString('es-AR', { weekday: 'long', year: 'numeric', month: 'long', day: 'numeric' });\n fechaDisplay = fechaDisplay.charAt(0).toUpperCase() + fechaDisplay.slice(1);\n } catch(e) {}\n\n const html = `<!DOCTYPE html>\n<html lang=\"es\">\n<head><meta charset=\"UTF-8\"><meta name=\"viewport\" content=\"width=device-width,initial-scale=1\"><title>Recordatorio de turno</title></head>\n<body style=\"margin:0;padding:0;background:#f4f6f9;font-family:Arial,sans-serif;\">\n<table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" style=\"background:#f4f6f9;padding:32px 0;\">\n <tr><td align=\"center\">\n <table width=\"560\" cellpadding=\"0\" cellspacing=\"0\" style=\"background:#ffffff;border-radius:12px;overflow:hidden;box-shadow:0 2px 8px rgba(0,0,0,0.08);\">\n <tr>\n <td style=\"background:#080E1A;padding:28px;text-align:center;\">\n <svg width=\"38\" height=\"38\" viewBox=\"0 0 80 80\" fill=\"none\" xmlns=\"http://www.w3.org/2000/svg\">\n <path d=\"M14 66 Q28 44 40 32 Q53 18 68 16\" stroke=\"#234A73\" stroke-width=\"9\" stroke-linecap=\"round\" fill=\"none\"/>\n <path d=\"M14 50 Q30 32 44 22 Q56 13 70 11\" stroke=\"#21C8C0\" stroke-width=\"6\" stroke-linecap=\"round\" fill=\"none\" opacity=\"0.9\"/>\n </svg>\n <p style=\"color:#ffffff;font-size:18px;font-weight:700;letter-spacing:0.12em;margin:10px 0 0;\">VITALIS</p>\n </td>\n </tr>\n <tr>\n <td style=\"padding:40px 36px;\">\n <div style=\"text-align:center;margin-bottom:24px;\">\n <div style=\"display:inline-block;background:#eff6ff;border-radius:50%;width:64px;height:64px;line-height:64px;font-size:32px;\">\ud83d\udd14</div>\n </div>\n <h1 style=\"color:#080E1A;font-size:22px;text-align:center;margin:0 0 6px;\">Recordatorio de turno</h1>\n <p style=\"color:#666;font-size:15px;text-align:center;margin:0 0 32px;\">Hola <strong>${nombre}</strong>, te recordamos que ma\u00f1ana ten\u00e9s turno en <strong>${centro}</strong>.</p>\n\n <div style=\"background:#f8f9fb;border-radius:10px;padding:24px;margin-bottom:28px;\">\n <table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\">\n <tr><td style=\"padding:8px 0;border-bottom:1px solid #eee;\"><span style=\"color:#999;font-size:13px;\">\ud83d\udcc5 Fecha</span></td><td style=\"text-align:right;color:#080E1A;font-size:14px;font-weight:600;padding:8px 0;border-bottom:1px solid #eee;\">${fechaDisplay}</td></tr>\n ${hora ? `<tr><td style=\"padding:8px 0;border-bottom:1px solid #eee;\"><span style=\"color:#999;font-size:13px;\">\ud83d\udd50 Hora</span></td><td style=\"text-align:right;color:#080E1A;font-size:14px;font-weight:600;padding:8px 0;border-bottom:1px solid #eee;\">${hora} hs</td></tr>` : ''}\n ${profesional ? `<tr><td style=\"padding:8px 0;\"><span style=\"color:#999;font-size:13px;\">\ud83d\udc68\u200d\u2695\ufe0f Profesional</span></td><td style=\"text-align:right;color:#080E1A;font-size:14px;font-weight:600;padding:8px 0;\">${profesional}</td></tr>` : ''}\n </table>\n </div>\n\n <div style=\"background:#e6faf9;border-radius:8px;padding:14px 18px;text-align:center;\">\n <p style=\"color:#0d7377;font-size:13px;margin:0;\">Por favor lleg\u00e1 5 minutos antes de tu turno.</p>\n </div>\n </td>\n </tr>\n <tr>\n <td style=\"background:#f4f6f9;padding:20px 36px;text-align:center;border-top:1px solid #e8ecf0;\">\n <p style=\"color:#999;font-size:12px;margin:0;\">Vitalis \u00b7 agendavitalis.app \u00b7 Este es un email autom\u00e1tico, no respondas a este mensaje.</p>\n </td>\n </tr>\n </table>\n </td></tr>\n</table>\n</body></html>`;\n\n resultado.push({ json: {\n to: email,\n subject: `Recordatorio: turno ma\u00f1ana ${hora ? 'a las ' + hora + ' hs' : ''} en ${centro}`,\n html\n }});\n}\n\nreturn resultado;"
},
"id": "node-armar-emails",
"name": "Armar Emails",
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
840,
300
]
},
{
"parameters": {
"fromEmail": "noreply@agendavitalis.app",
"toEmail": "={{ $json.to }}",
"subject": "={{ $json.subject }}",
"emailFormat": "html",
"html": "={{ $json.html }}"
},
"id": "node-smtp",
"name": "Enviar Email SMTP",
"type": "n8n-nodes-base.emailSend",
"typeVersion": 2.1,
"position": [
1040,
300
],
"credentials": {
"smtp": {
"name": "<your credential>"
}
}
}
],
"connections": {
"Cron 9:00": {
"main": [
[
{
"node": "Calcular Ma\u00f1ana",
"type": "main",
"index": 0
}
]
]
},
"Calcular Ma\u00f1ana": {
"main": [
[
{
"node": "Buscar Turnos Ma\u00f1ana",
"type": "main",
"index": 0
}
]
]
},
"Buscar Turnos Ma\u00f1ana": {
"main": [
[
{
"node": "Armar Emails",
"type": "main",
"index": 0
}
]
]
},
"Armar Emails": {
"main": [
[
{
"node": "Enviar Email SMTP",
"type": "main",
"index": 0
}
]
]
}
},
"active": true,
"settings": {
"executionOrder": "v1"
}
}
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
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Vitalis - Email Recordatorio 24hs. Uses httpRequest, emailSend. Scheduled trigger; 5 nodes.
Source: https://github.com/gkovalek/agendavitalis/blob/main/n8n/workflow-email-recordatorio.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.
Stop And Error, HTTP Request, Email Send +1
This workflow is an improvement of this workflow by Greg Brzezinka.
HTTP Request, Email Send, XML +1
N8N-Self-Updater. Uses ssh, emailSend, httpRequest. Scheduled trigger; 27 nodes.
Ssh, Email Send, HTTP Request
> 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
Ssh, Email Send, HTTP Request
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
QuickBooks, HTTP Request, Email Send