Turn finished visits into reviews and rebookings: an n8n follow-up workflow, JSON included

appointment_id, customer_name, phone, visited_at (ISO), treatment, practitioner, first_visit APT-3001, Anna Voorbeeld, +316****5678, 2026-10-01T09:00:00Z, Hair treatment, Stylist A, false APT-3002, Tom Voorbeeld, +316****5432, 2026-10-03T08:00:00Z, Haircut, Stylist B, true 

const items = $input.all(); const now = Date.now(); const out = []; const INTERVAL_WEEKS = { 'Hair treatment': 12, 'Color touch-up': 6, 'Haircut': 5, 'Check-up': 6, 'Default': 8 }; for (const item of items) { const r = item.json; const hoursAgo = (now - new Date(r.visited_at).getTime()) / 3600000; if (hoursAgo < 20 || hoursAgo > 30) continue; const weeks = INTERVAL_WEEKS[r.treatment] || INTERVAL_WEEKS['Default']; const rebookDate = new Date(now + weeks * 7 * 24 * 3600 * 1000); const rebookStr = rebookDate.toLocaleDateString('en-GB', { weekday: 'long', day: 'numeric', month: 'long' }); let message; if (r.first_visit) { message = 'Hi ' + r.customer_name + ', thanks for your first visit! How was it? A review helps us a lot: REVIEWLINK. It takes 1 minute.'; } else { message = 'Hi ' + r.customer_name + ', great to see you again! Your next ' + r.treatment + ' is due in about ' + weeks + ' weeks (' + rebookStr + '). Want to reserve a spot now? Reply BOOK.'; } out.push({ json: { appointment_id: r.appointment_id, customer_name: r.customer_name, to: r.phone, channel: 'whatsapp', kind: r.first_visit ? 'review_ask' : 'rebook_nudge', rebook_weeks: weeks, rebook_date: rebookDate.toISOString(), message: message } }); } return out; 

{ "name": "Send post-visit review asks and rebooking nudges", "nodes": [ { "parameters": { "rule": { "interval": [ { "field": "hours", "hoursInterval": 12 } ] } }, "id": "d1000000-0000-4000-8000-000000000001", "name": "Every 12 hours", "type": "n8n-nodes-base.scheduleTrigger", "typeVersion": 1.2, "position": [ -200, 0 ] }, { "parameters": { "jsCode": "// DEMO SOURCE. Replace with your Google Sheet of completed visits.\n// Columns: appointment_id, customer_name, phone, visited_at (ISO), treatment, practitioner, first_visit\nconst demoRows = [\n {\n appointment_id: 'APT-3001',\n customer_name: 'Anna Voorbeeld',\n phone: '+316****5678',\n visited_at: new Date(Date.now() - 26 * 3600 * 1000).toISOString(),\n treatment: 'Hair treatment',\n practitioner: 'Stylist A',\n first_visit: false\n },\n {\n appointment_id: 'APT-3002',\n customer_name: 'Tom Voorbeeld',\n phone: '+316****5432',\n visited_at: new Date(Date.now() - 3 * 3600 * 1000).toISOString(),\n treatment: 'Haircut',\n practitioner: 'Stylist B',\n first_visit: true\n }\n];\nreturn demoRows.map((row) => ({ json: row }));" }, "id": "d1000000-0000-4000-8000-000000000002", "name": "Completed visits (demo data)", "type": "n8n-nodes-base.code", "typeVersion": 2, "position": [ 20, 0 ] }, { "parameters": { "jsCode": "// Pick visits that ended 20..30 hours ago (the sweet spot: next morning).\n// First-time customers get the review ask; regulars get a rebooking nudge\n// with their usual interval.\nconst items = $input.all();\nconst now = Date.now();\nconst out = [];\nconst INTERVAL_WEEKS = { 'Hair treatment': 12, 'Color touch-up': 6, 'Haircut': 5, 'Check-up': 6, 'Default': 8 };\nfor (const item of items) {\n const r = item.json;\n const hoursAgo = (now - new Date(r.visited_at).getTime()) / 3600000;\n if (hoursAgo < 20 || hoursAgo > 30) continue;\n const weeks = INTERVAL_WEEKS[r.treatment] || INTERVAL_WEEKS['Default'];\n const rebookDate = new Date(now + weeks * 7 * 24 * 3600 * 1000);\n const rebookStr = rebookDate.toLocaleDateString('en-GB', { weekday: 'long', day: 'numeric', month: 'long' });\n let message;\n if (r.first_visit) {\n message = 'Hi ' + r.customer_name + ', thanks for your first visit! How was it? A review helps us a lot: REVIEWLINK. It takes 1 minute.';\n } else {\n message = 'Hi ' + r.customer_name + ', great to see you again! Your next ' + r.treatment + ' is due in about ' + weeks + ' weeks (' + rebookStr + '). Want to reserve a spot now? Reply BOOK.';\n }\n out.push({\n json: {\n appointment_id: r.appointment_id,\n customer_name: r.customer_name,\n to: r.phone,\n channel: 'whatsapp',\n kind: r.first_visit ? 'review_ask' : 'rebook_nudge',\n rebook_weeks: weeks,\n rebook_date: rebookDate.toISOString(),\n message: message\n }\n });\n}\nreturn out;" }, "id": "d1000000-0000-4000-8000-000000000003", "name": "Pick window + build message", "type": "n8n-nodes-base.code", "typeVersion": 2, "position": [ 240, 0 ] }, { "parameters": { "jsCode": "// Placeholder for the send node (WhatsApp Business Cloud / SMS / email).\nconst items = $input.all();\nreturn items.map((item) => ({\n json: { ...item.json, sent_at: new Date().toISOString(), transport: 'demo' }\n}));" }, "id": "d1000000-0000-4000-8000-000000000004", "name": "Send follow-up (replace me)", "type": "n8n-nodes-base.code", "typeVersion": 2, "position": [ 460, 0 ] }, { "parameters": { "conditions": { "options": { "caseSensitive": true, "leftValue": "", "typeValidation": "strict", "version": 2 }, "conditions": [ { "id": "c1", "leftValue": "={{ $json.kind }}", "rightValue": "review_ask", "operator": { "type": "string", "operation": "equals" } } ], "combinator": "and" }, "options": {} }, "id": "d1000000-0000-4000-8000-000000000005", "name": "Review ask?", "type": "n8n-nodes-base.if", "typeVersion": 2.2, "position": [ 680, 0 ] }, { "parameters": { "jsCode": "// Review-ask outcomes: log which channel converted (wire a Sheet write here).\nconst items = $input.all();\nreturn items.map((item) => ({ json: { ...item.json, logged_as: 'review_sent' } }));" }, "id": "d1000000-0000-4000-8000-000000000006", "name": "Log review ask", "type": "n8n-nodes-base.code", "typeVersion": 2, "position": [ 900, -100 ] }, { "parameters": { "jsCode": "// Rebook-nudge outcomes: a BOOK reply should trigger your booking intake\n// workflow with the suggested slot prefilled.\nconst items = $input.all();\nreturn items.map((item) => ({ json: { ...item.json, logged_as: 'rebook_sent' } }));" }, "id": "d1000000-0000-4000-8000-000000000007", "name": "Log rebook nudge", "type": "n8n-nodes-base.code", "typeVersion": 2, "position": [ 900, 100 ] }, { "parameters": { "content": "## Send post-visit review asks and rebooking nudges\n\n### How it works\n\nEvery 12 hours the workflow reads completed visits and picks the ones that ended 20 to 30 hours ago: next-morning timing, high response rates. First-time customers get a review ask. Regulars get a rebooking nudge with the interval their treatment usually needs. Each message is built with the customer name, the treatment, and the suggested rebooking date, then handed to your WhatsApp, SMS, or email send node.\n\n### Setup steps\n\n- Replace the demo visits node with your Google Sheets source of completed visits.\n- Replace the send placeholder with a WhatsApp Business Cloud, SMS, or email node.\n- Point REVIEWLINK in the review message at your review page.\n\n### Customization\n\nTreatment intervals live in the INTERVAL_WEEKS map in the window-picker node. The 20-30 hour window and the 12-hour schedule fit most salons and clinics; shift them for your own rhythm.\n\n### Requirements\n\nn8n on any plan. The demo data runs without credentials. For production you need a Google Sheets credential and a WhatsApp Business Cloud, SMS, or email send credential.", "width": 600, "height": 820 }, "id": "cccc0000-0000-4000-8000-0000000000f1", "name": "Sticky Note 00f1", "type": "n8n-nodes-base.stickyNote", "typeVersion": 1, "position": [ -960, -300 ] }, { "parameters": { "content": "## 1. Read visits\nDemo rows stand in for your Sheet of completed visits. Swap the node, keep the columns.", "color": 7, "width": 455, "height": 420 }, "id": "cccc0000-0000-4000-8000-0000000000f2", "name": "Sticky Note 00f2", "type": "n8n-nodes-base.stickyNote", "typeVersion": 1, "position": [ -320, -200 ] }, { "parameters": { "content": "## 2. Pick window + build message\n20-30 hours after the visit. First visit: review ask. Regular: rebooking nudge with treatment interval.", "color": 7, "width": 400, "height": 420 }, "id": "cccc0000-0000-4000-8000-0000000000f3", "name": "Sticky Note 00f3", "type": "n8n-nodes-base.stickyNote", "typeVersion": 1, "position": [ 175, -200 ] }, { "parameters": { "content": "## 3. Send + log\nReplace the placeholder with your real send node. Both branches log what went out.", "color": 7, "width": 515, "height": 580 }, "id": "cccc0000-0000-4000-8000-0000000000f4", "name": "Sticky Note 00f4", "type": "n8n-nodes-base.stickyNote", "typeVersion": 1, "position": [ 615, -200 ] } ], "connections": { "Every 12 hours": { "main": [ [ { "node": "Completed visits (demo data)", "type": "main", "index": 0 } ] ] }, "Completed visits (demo data)": { "main": [ [ { "node": "Pick window + build message", "type": "main", "index": 0 } ] ] }, "Pick window + build message": { "main": [ [ { "node": "Send follow-up (replace me)", "type": "main", "index": 0 } ] ] }, "Send follow-up (replace me)": { "main": [ [ { "node": "Review ask?", "type": "main", "index": 0 } ] ] }, "Review ask?": { "main": [ [ { "node": "Log review ask", "type": "main", "index": 0 } ], [ { "node": "Log rebook nudge", "type": "main", "index": 0 } ] ] } } }