{"id":5744,"date":"2026-10-04T02:22:41","date_gmt":"2026-10-04T05:22:41","guid":{"rendered":"https:\/\/tucumandevelopers.com\/index.php\/2026\/10\/04\/turn-finished-visits-into-reviews-and-rebookings-an-n8n-follow-up-workflow-json-included\/"},"modified":"2026-10-04T02:22:41","modified_gmt":"2026-10-04T05:22:41","slug":"turn-finished-visits-into-reviews-and-rebookings-an-n8n-follow-up-workflow-json-included","status":"publish","type":"post","link":"https:\/\/tucumandevelopers.com\/index.php\/2026\/10\/04\/turn-finished-visits-into-reviews-and-rebookings-an-n8n-follow-up-workflow-json-included\/","title":{"rendered":"Turn finished visits into reviews and rebookings: an n8n follow-up workflow, JSON included"},"content":{"rendered":"
\n
<\/div>\n

Edit the treatments and weeks to match your own list. Clinics translate
this trivially: check-up intervals and recall periods are exactly this
map. When a treatment is missing, the Default entry catches it, so no
customer silently drops out.<\/p>\n

<\/a> What the workflow does <\/h2>\n

Seven nodes, one schedule trigger:<\/p>\n

    \n
  1. Every 12 hours, a trigger fires.<\/li>\n
  2. Completed visits are read. Demo rows in the JSON below; swap in your Google Sheet of completed visits.<\/li>\n
  3. One code node picks the 20-30 hour window, picks review-ask versus rebook-nudge, computes the date, and builds the message.<\/li>\n
  4. A placeholder send node stands in for WhatsApp Business Cloud, SMS, or email.<\/li>\n
  5. An If node splits the two kinds.<\/li>\n
  6. Two log nodes stamp the outcome: review_sent<\/code> and rebook_sent<\/code>, ready to wire into a sheet.<\/li>\n<\/ol>\n

    The columns the source needs: <\/p>\n

    \n
    appointment<\/span>_<\/span>id<\/span>,<\/span> customer<\/span>_<\/span>name<\/span>,<\/span> phone<\/span>,<\/span> visited<\/span>_<\/span>at<\/span> (<\/span>ISO<\/span>),<\/span> treatment<\/span>,<\/span> practitioner<\/span>,<\/span> first<\/span>_<\/span>visit<\/span> APT<\/span>-<\/span>3001<\/span>,<\/span> Anna<\/span> Voorbeeld<\/span>,<\/span> +<\/span>316<\/span>****<\/span>5678<\/span>,<\/span> 2026-10-01T09:00:00Z<\/span>,<\/span> Hair<\/span> treatment<\/span>,<\/span> Stylist<\/span> A<\/span>,<\/span> false<\/span> APT<\/span>-<\/span>3002<\/span>,<\/span> Tom<\/span> Voorbeeld<\/span>,<\/span> +<\/span>316<\/span>****<\/span>5432<\/span>,<\/span> 2026-10-03T08:00:00Z<\/span>,<\/span> Haircut<\/span>,<\/span> Stylist<\/span> B<\/span>,<\/span> true<\/span> <\/code><\/pre>\n
    \n<\/p><\/div>\n<\/p><\/div>\n
      <\/a> The code node that matters <\/h2>\n
    Window, kind, date, and message in one pass: <\/p>\n
    \n
    const<\/span> items<\/span> =<\/span> $input<\/span>.<\/span>all<\/span>();<\/span> const<\/span> now<\/span> =<\/span> Date<\/span>.<\/span>now<\/span>();<\/span> const<\/span> out<\/span> =<\/span> [];<\/span> const<\/span> INTERVAL_WEEKS<\/span> =<\/span> {<\/span> '<\/span>Hair treatment<\/span>'<\/span>:<\/span> 12<\/span>,<\/span> '<\/span>Color touch-up<\/span>'<\/span>:<\/span> 6<\/span>,<\/span> '<\/span>Haircut<\/span>'<\/span>:<\/span> 5<\/span>,<\/span> '<\/span>Check-up<\/span>'<\/span>:<\/span> 6<\/span>,<\/span> '<\/span>Default<\/span>'<\/span>:<\/span> 8<\/span> };<\/span> for <\/span>(<\/span>const<\/span> item<\/span> of<\/span> items<\/span>)<\/span> {<\/span> const<\/span> r<\/span> =<\/span> item<\/span>.<\/span>json<\/span>;<\/span> const<\/span> hoursAgo<\/span> =<\/span> (<\/span>now<\/span> -<\/span> new<\/span> Date<\/span>(<\/span>r<\/span>.<\/span>visited_at<\/span>).<\/span>getTime<\/span>())<\/span> \/<\/span> 3600000<\/span>;<\/span> if <\/span>(<\/span>hoursAgo<\/span> <<\/span> 20<\/span> ||<\/span> hoursAgo<\/span> ><\/span> 30<\/span>)<\/span> continue<\/span>;<\/span> const<\/span> weeks<\/span> =<\/span> INTERVAL_WEEKS<\/span>[<\/span>r<\/span>.<\/span>treatment<\/span>]<\/span> ||<\/span> INTERVAL_WEEKS<\/span>[<\/span>'<\/span>Default<\/span>'<\/span>];<\/span> const<\/span> rebookDate<\/span> =<\/span> new<\/span> Date<\/span>(<\/span>now<\/span> +<\/span> weeks<\/span> *<\/span> 7<\/span> *<\/span> 24<\/span> *<\/span> 3600<\/span> *<\/span> 1000<\/span>);<\/span> const<\/span> rebookStr<\/span> =<\/span> rebookDate<\/span>.<\/span>toLocaleDateString<\/span>(<\/span>'<\/span>en-GB<\/span>'<\/span>,<\/span> {<\/span> weekday<\/span>:<\/span> '<\/span>long<\/span>'<\/span>,<\/span> day<\/span>:<\/span> '<\/span>numeric<\/span>'<\/span>,<\/span> month<\/span>:<\/span> '<\/span>long<\/span>'<\/span> });<\/span> let<\/span> message<\/span>;<\/span> if <\/span>(<\/span>r<\/span>.<\/span>first_visit<\/span>)<\/span> {<\/span> message<\/span> =<\/span> '<\/span>Hi <\/span>'<\/span> +<\/span> r<\/span>.<\/span>customer_name<\/span> +<\/span> '<\/span>, thanks for your first visit! How was it? A review helps us a lot: REVIEWLINK. It takes 1 minute.<\/span>'<\/span>;<\/span> }<\/span> else<\/span> {<\/span> message<\/span> =<\/span> '<\/span>Hi <\/span>'<\/span> +<\/span> r<\/span>.<\/span>customer_name<\/span> +<\/span> '<\/span>, great to see you again! Your next <\/span>'<\/span> +<\/span> r<\/span>.<\/span>treatment<\/span> +<\/span> '<\/span> is due in about <\/span>'<\/span> +<\/span> weeks<\/span> +<\/span> '<\/span> weeks (<\/span>'<\/span> +<\/span> rebookStr<\/span> +<\/span> '<\/span>). Want to reserve a spot now? Reply BOOK.<\/span>'<\/span>;<\/span> }<\/span> out<\/span>.<\/span>push<\/span>({<\/span> json<\/span>:<\/span> {<\/span> appointment_id<\/span>:<\/span> r<\/span>.<\/span>appointment_id<\/span>,<\/span> customer_name<\/span>:<\/span> r<\/span>.<\/span>customer_name<\/span>,<\/span> to<\/span>:<\/span> r<\/span>.<\/span>phone<\/span>,<\/span> channel<\/span>:<\/span> '<\/span>whatsapp<\/span>'<\/span>,<\/span> kind<\/span>:<\/span> r<\/span>.<\/span>first_visit<\/span> ?<\/span> '<\/span>review_ask<\/span>'<\/span> :<\/span> '<\/span>rebook_nudge<\/span>'<\/span>,<\/span> rebook_weeks<\/span>:<\/span> weeks<\/span>,<\/span> rebook_date<\/span>:<\/span> rebookDate<\/span>.<\/span>toISOString<\/span>(),<\/span> message<\/span>:<\/span> message<\/span> }<\/span> });<\/span> }<\/span> return<\/span> out<\/span>;<\/span> <\/code><\/pre>\n
    \n<\/p><\/div>\n<\/p><\/div>\n
    The continue<\/code> on the window check keeps every run idempotent: rows
     outside the window drop out before a message exists, and rows older
     than 30 hours are gone forever, which is correct. You had one morning
     to catch that customer and the workflow used it.<\/p>\n
      <\/a> Close the loop on BOOK replies <\/h2>\n
    The rebook log node is where the series connects. When a customer
     replies BOOK, that reply should land in a booking intake flow with the
     suggested slot prefilled, not in an inbox. My booking intake build
     (validated webhook, field checks, instant structured responses) is in
     the pack linked below; wiring the BOOK reply into its webhook is two
     nodes.<\/p>\n
      <\/a> Test it without sending anything <\/h2>\n
    The JSON below has demo data wired in. Import it into n8n, open the
     demo visits node, and shift visited_at<\/code> to roughly 26 hours ago (the
     demo rows already sit there relative to now). Execute and watch the If
     node split the first-timer from the regular. No message leaves: the
     send node is a placeholder by design.<\/p>\n
      <\/a> The complete workflow JSON <\/h2>\n
    Import into n8n (Workflows, Import from File), replace the demo source
     with your completed-visits sheet, and put a real send node in the
     middle. Point REVIEWLINK at your review page: <\/p>\n
    \n
    {<\/span> <\/span>\"name\"<\/span>:<\/span> <\/span>\"Send post-visit review asks and rebooking nudges\"<\/span>,<\/span> <\/span>\"nodes\"<\/span>:<\/span> <\/span>[<\/span> <\/span>{<\/span> <\/span>\"parameters\"<\/span>:<\/span> <\/span>{<\/span> <\/span>\"rule\"<\/span>:<\/span> <\/span>{<\/span> <\/span>\"interval\"<\/span>:<\/span> <\/span>[<\/span> <\/span>{<\/span> <\/span>\"field\"<\/span>:<\/span> <\/span>\"hours\"<\/span>,<\/span> <\/span>\"hoursInterval\"<\/span>:<\/span> <\/span>12<\/span> <\/span>}<\/span> <\/span>]<\/span> <\/span>}<\/span> <\/span>},<\/span> <\/span>\"id\"<\/span>:<\/span> <\/span>\"d1000000-0000-4000-8000-000000000001\"<\/span>,<\/span> <\/span>\"name\"<\/span>:<\/span> <\/span>\"Every 12 hours\"<\/span>,<\/span> <\/span>\"type\"<\/span>:<\/span> <\/span>\"n8n-nodes-base.scheduleTrigger\"<\/span>,<\/span> <\/span>\"typeVersion\"<\/span>:<\/span> <\/span>1.2<\/span>,<\/span> <\/span>\"position\"<\/span>:<\/span> <\/span>[<\/span> <\/span>-200<\/span>,<\/span> <\/span>0<\/span> <\/span>]<\/span> <\/span>},<\/span> <\/span>{<\/span> <\/span>\"parameters\"<\/span>:<\/span> <\/span>{<\/span> <\/span>\"jsCode\"<\/span>:<\/span> <\/span>\"\/\/ DEMO SOURCE. Replace with your Google Sheet of completed visits.<\/span>\\n<\/span>\/\/ Columns: appointment_id, customer_name, phone, visited_at (ISO), treatment, practitioner, first_visit<\/span>\\n<\/span>const demoRows = [<\/span>\\n<\/span> {<\/span>\\n<\/span> appointment_id: 'APT-3001',<\/span>\\n<\/span> customer_name: 'Anna Voorbeeld',<\/span>\\n<\/span> phone: '+316****5678',<\/span>\\n<\/span> visited_at: new Date(Date.now() - 26 * 3600 * 1000).toISOString(),<\/span>\\n<\/span> treatment: 'Hair treatment',<\/span>\\n<\/span> practitioner: 'Stylist A',<\/span>\\n<\/span> first_visit: false<\/span>\\n<\/span> },<\/span>\\n<\/span> {<\/span>\\n<\/span> appointment_id: 'APT-3002',<\/span>\\n<\/span> customer_name: 'Tom Voorbeeld',<\/span>\\n<\/span> phone: '+316****5432',<\/span>\\n<\/span> visited_at: new Date(Date.now() - 3 * 3600 * 1000).toISOString(),<\/span>\\n<\/span> treatment: 'Haircut',<\/span>\\n<\/span> practitioner: 'Stylist B',<\/span>\\n<\/span> first_visit: true<\/span>\\n<\/span> }<\/span>\\n<\/span>];<\/span>\\n<\/span>return demoRows.map((row) => ({ json: row }));\"<\/span> <\/span>},<\/span> <\/span>\"id\"<\/span>:<\/span> <\/span>\"d1000000-0000-4000-8000-000000000002\"<\/span>,<\/span> <\/span>\"name\"<\/span>:<\/span> <\/span>\"Completed visits (demo data)\"<\/span>,<\/span> <\/span>\"type\"<\/span>:<\/span> <\/span>\"n8n-nodes-base.code\"<\/span>,<\/span> <\/span>\"typeVersion\"<\/span>:<\/span> <\/span>2<\/span>,<\/span> <\/span>\"position\"<\/span>:<\/span> <\/span>[<\/span> <\/span>20<\/span>,<\/span> <\/span>0<\/span> <\/span>]<\/span> <\/span>},<\/span> <\/span>{<\/span> <\/span>\"parameters\"<\/span>:<\/span> <\/span>{<\/span> <\/span>\"jsCode\"<\/span>:<\/span> <\/span>\"\/\/ Pick visits that ended 20..30 hours ago (the sweet spot: next morning).<\/span>\\n<\/span>\/\/ First-time customers get the review ask; regulars get a rebooking nudge<\/span>\\n<\/span>\/\/ with their usual interval.<\/span>\\n<\/span>const items = $input.all();<\/span>\\n<\/span>const now = Date.now();<\/span>\\n<\/span>const out = [];<\/span>\\n<\/span>const INTERVAL_WEEKS = { 'Hair treatment': 12, 'Color touch-up': 6, 'Haircut': 5, 'Check-up': 6, 'Default': 8 };<\/span>\\n<\/span>for (const item of items) {<\/span>\\n<\/span> const r = item.json;<\/span>\\n<\/span> const hoursAgo = (now - new Date(r.visited_at).getTime()) \/ 3600000;<\/span>\\n<\/span> if (hoursAgo < 20 || hoursAgo > 30) continue;<\/span>\\n<\/span> const weeks = INTERVAL_WEEKS[r.treatment] || INTERVAL_WEEKS['Default'];<\/span>\\n<\/span> const rebookDate = new Date(now + weeks * 7 * 24 * 3600 * 1000);<\/span>\\n<\/span> const rebookStr = rebookDate.toLocaleDateString('en-GB', { weekday: 'long', day: 'numeric', month: 'long' });<\/span>\\n<\/span> let message;<\/span>\\n<\/span> if (r.first_visit) {<\/span>\\n<\/span> message = 'Hi ' + r.customer_name + ', thanks for your first visit! How was it? A review helps us a lot: REVIEWLINK. It takes 1 minute.';<\/span>\\n<\/span> } else {<\/span>\\n<\/span> 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.';<\/span>\\n<\/span> }<\/span>\\n<\/span> out.push({<\/span>\\n<\/span> json: {<\/span>\\n<\/span> appointment_id: r.appointment_id,<\/span>\\n<\/span> customer_name: r.customer_name,<\/span>\\n<\/span> to: r.phone,<\/span>\\n<\/span> channel: 'whatsapp',<\/span>\\n<\/span> kind: r.first_visit ? 'review_ask' : 'rebook_nudge',<\/span>\\n<\/span> rebook_weeks: weeks,<\/span>\\n<\/span> rebook_date: rebookDate.toISOString(),<\/span>\\n<\/span> message: message<\/span>\\n<\/span> }<\/span>\\n<\/span> });<\/span>\\n<\/span>}<\/span>\\n<\/span>return out;\"<\/span> <\/span>},<\/span> <\/span>\"id\"<\/span>:<\/span> <\/span>\"d1000000-0000-4000-8000-000000000003\"<\/span>,<\/span> <\/span>\"name\"<\/span>:<\/span> <\/span>\"Pick window + build message\"<\/span>,<\/span> <\/span>\"type\"<\/span>:<\/span> <\/span>\"n8n-nodes-base.code\"<\/span>,<\/span> <\/span>\"typeVersion\"<\/span>:<\/span> <\/span>2<\/span>,<\/span> <\/span>\"position\"<\/span>:<\/span> <\/span>[<\/span> <\/span>240<\/span>,<\/span> <\/span>0<\/span> <\/span>]<\/span> <\/span>},<\/span> <\/span>{<\/span> <\/span>\"parameters\"<\/span>:<\/span> <\/span>{<\/span> <\/span>\"jsCode\"<\/span>:<\/span> <\/span>\"\/\/ Placeholder for the send node (WhatsApp Business Cloud \/ SMS \/ email).<\/span>\\n<\/span>const items = $input.all();<\/span>\\n<\/span>return items.map((item) => ({<\/span>\\n<\/span> json: { ...item.json, sent_at: new Date().toISOString(), transport: 'demo' }<\/span>\\n<\/span>}));\"<\/span> <\/span>},<\/span> <\/span>\"id\"<\/span>:<\/span> <\/span>\"d1000000-0000-4000-8000-000000000004\"<\/span>,<\/span> <\/span>\"name\"<\/span>:<\/span> <\/span>\"Send follow-up (replace me)\"<\/span>,<\/span> <\/span>\"type\"<\/span>:<\/span> <\/span>\"n8n-nodes-base.code\"<\/span>,<\/span> <\/span>\"typeVersion\"<\/span>:<\/span> <\/span>2<\/span>,<\/span> <\/span>\"position\"<\/span>:<\/span> <\/span>[<\/span> <\/span>460<\/span>,<\/span> <\/span>0<\/span> <\/span>]<\/span> <\/span>},<\/span> <\/span>{<\/span> <\/span>\"parameters\"<\/span>:<\/span> <\/span>{<\/span> <\/span>\"conditions\"<\/span>:<\/span> <\/span>{<\/span> <\/span>\"options\"<\/span>:<\/span> <\/span>{<\/span> <\/span>\"caseSensitive\"<\/span>:<\/span> <\/span>true<\/span>,<\/span> <\/span>\"leftValue\"<\/span>:<\/span> <\/span>\"\"<\/span>,<\/span> <\/span>\"typeValidation\"<\/span>:<\/span> <\/span>\"strict\"<\/span>,<\/span> <\/span>\"version\"<\/span>:<\/span> <\/span>2<\/span> <\/span>},<\/span> <\/span>\"conditions\"<\/span>:<\/span> <\/span>[<\/span> <\/span>{<\/span> <\/span>\"id\"<\/span>:<\/span> <\/span>\"c1\"<\/span>,<\/span> <\/span>\"leftValue\"<\/span>:<\/span> <\/span>\"={{ $json.kind }}\"<\/span>,<\/span> <\/span>\"rightValue\"<\/span>:<\/span> <\/span>\"review_ask\"<\/span>,<\/span> <\/span>\"operator\"<\/span>:<\/span> <\/span>{<\/span> <\/span>\"type\"<\/span>:<\/span> <\/span>\"string\"<\/span>,<\/span> <\/span>\"operation\"<\/span>:<\/span> <\/span>\"equals\"<\/span> <\/span>}<\/span> <\/span>}<\/span> <\/span>],<\/span> <\/span>\"combinator\"<\/span>:<\/span> <\/span>\"and\"<\/span> <\/span>},<\/span> <\/span>\"options\"<\/span>:<\/span> <\/span>{}<\/span> <\/span>},<\/span> <\/span>\"id\"<\/span>:<\/span> <\/span>\"d1000000-0000-4000-8000-000000000005\"<\/span>,<\/span> <\/span>\"name\"<\/span>:<\/span> <\/span>\"Review ask?\"<\/span>,<\/span> <\/span>\"type\"<\/span>:<\/span> <\/span>\"n8n-nodes-base.if\"<\/span>,<\/span> <\/span>\"typeVersion\"<\/span>:<\/span> <\/span>2.2<\/span>,<\/span> <\/span>\"position\"<\/span>:<\/span> <\/span>[<\/span> <\/span>680<\/span>,<\/span> <\/span>0<\/span> <\/span>]<\/span> <\/span>},<\/span> <\/span>{<\/span> <\/span>\"parameters\"<\/span>:<\/span> <\/span>{<\/span> <\/span>\"jsCode\"<\/span>:<\/span> <\/span>\"\/\/ Review-ask outcomes: log which channel converted (wire a Sheet write here).<\/span>\\n<\/span>const items = $input.all();<\/span>\\n<\/span>return items.map((item) => ({ json: { ...item.json, logged_as: 'review_sent' } }));\"<\/span> <\/span>},<\/span> <\/span>\"id\"<\/span>:<\/span> <\/span>\"d1000000-0000-4000-8000-000000000006\"<\/span>,<\/span> <\/span>\"name\"<\/span>:<\/span> <\/span>\"Log review ask\"<\/span>,<\/span> <\/span>\"type\"<\/span>:<\/span> <\/span>\"n8n-nodes-base.code\"<\/span>,<\/span> <\/span>\"typeVersion\"<\/span>:<\/span> <\/span>2<\/span>,<\/span> <\/span>\"position\"<\/span>:<\/span> <\/span>[<\/span> <\/span>900<\/span>,<\/span> <\/span>-100<\/span> <\/span>]<\/span> <\/span>},<\/span> <\/span>{<\/span> <\/span>\"parameters\"<\/span>:<\/span> <\/span>{<\/span> <\/span>\"jsCode\"<\/span>:<\/span> <\/span>\"\/\/ Rebook-nudge outcomes: a BOOK reply should trigger your booking intake<\/span>\\n<\/span>\/\/ workflow with the suggested slot prefilled.<\/span>\\n<\/span>const items = $input.all();<\/span>\\n<\/span>return items.map((item) => ({ json: { ...item.json, logged_as: 'rebook_sent' } }));\"<\/span> <\/span>},<\/span> <\/span>\"id\"<\/span>:<\/span> <\/span>\"d1000000-0000-4000-8000-000000000007\"<\/span>,<\/span> <\/span>\"name\"<\/span>:<\/span> <\/span>\"Log rebook nudge\"<\/span>,<\/span> <\/span>\"type\"<\/span>:<\/span> <\/span>\"n8n-nodes-base.code\"<\/span>,<\/span> <\/span>\"typeVersion\"<\/span>:<\/span> <\/span>2<\/span>,<\/span> <\/span>\"position\"<\/span>:<\/span> <\/span>[<\/span> <\/span>900<\/span>,<\/span> <\/span>100<\/span> <\/span>]<\/span> <\/span>},<\/span> <\/span>{<\/span> <\/span>\"parameters\"<\/span>:<\/span> <\/span>{<\/span> <\/span>\"content\"<\/span>:<\/span> <\/span>\"## Send post-visit review asks and rebooking nudges<\/span>\\n\\n<\/span>### How it works<\/span>\\n\\n<\/span>Every 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.<\/span>\\n\\n<\/span>### Setup steps<\/span>\\n\\n<\/span>- Replace the demo visits node with your Google Sheets source of completed visits.<\/span>\\n<\/span>- Replace the send placeholder with a WhatsApp Business Cloud, SMS, or email node.<\/span>\\n<\/span>- Point REVIEWLINK in the review message at your review page.<\/span>\\n\\n<\/span>### Customization<\/span>\\n\\n<\/span>Treatment 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.<\/span>\\n\\n<\/span>### Requirements<\/span>\\n\\n<\/span>n8n 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.\"<\/span>,<\/span> <\/span>\"width\"<\/span>:<\/span> <\/span>600<\/span>,<\/span> <\/span>\"height\"<\/span>:<\/span> <\/span>820<\/span> <\/span>},<\/span> <\/span>\"id\"<\/span>:<\/span> <\/span>\"cccc0000-0000-4000-8000-0000000000f1\"<\/span>,<\/span> <\/span>\"name\"<\/span>:<\/span> <\/span>\"Sticky Note 00f1\"<\/span>,<\/span> <\/span>\"type\"<\/span>:<\/span> <\/span>\"n8n-nodes-base.stickyNote\"<\/span>,<\/span> <\/span>\"typeVersion\"<\/span>:<\/span> <\/span>1<\/span>,<\/span> <\/span>\"position\"<\/span>:<\/span> <\/span>[<\/span> <\/span>-960<\/span>,<\/span> <\/span>-300<\/span> <\/span>]<\/span> <\/span>},<\/span> <\/span>{<\/span> <\/span>\"parameters\"<\/span>:<\/span> <\/span>{<\/span> <\/span>\"content\"<\/span>:<\/span> <\/span>\"## 1. Read visits<\/span>\\n<\/span>Demo rows stand in for your Sheet of completed visits. Swap the node, keep the columns.\"<\/span>,<\/span> <\/span>\"color\"<\/span>:<\/span> <\/span>7<\/span>,<\/span> <\/span>\"width\"<\/span>:<\/span> <\/span>455<\/span>,<\/span> <\/span>\"height\"<\/span>:<\/span> <\/span>420<\/span> <\/span>},<\/span> <\/span>\"id\"<\/span>:<\/span> <\/span>\"cccc0000-0000-4000-8000-0000000000f2\"<\/span>,<\/span> <\/span>\"name\"<\/span>:<\/span> <\/span>\"Sticky Note 00f2\"<\/span>,<\/span> <\/span>\"type\"<\/span>:<\/span> <\/span>\"n8n-nodes-base.stickyNote\"<\/span>,<\/span> <\/span>\"typeVersion\"<\/span>:<\/span> <\/span>1<\/span>,<\/span> <\/span>\"position\"<\/span>:<\/span> <\/span>[<\/span> <\/span>-320<\/span>,<\/span> <\/span>-200<\/span> <\/span>]<\/span> <\/span>},<\/span> <\/span>{<\/span> <\/span>\"parameters\"<\/span>:<\/span> <\/span>{<\/span> <\/span>\"content\"<\/span>:<\/span> <\/span>\"## 2. Pick window + build message<\/span>\\n<\/span>20-30 hours after the visit. First visit: review ask. Regular: rebooking nudge with treatment interval.\"<\/span>,<\/span> <\/span>\"color\"<\/span>:<\/span> <\/span>7<\/span>,<\/span> <\/span>\"width\"<\/span>:<\/span> <\/span>400<\/span>,<\/span> <\/span>\"height\"<\/span>:<\/span> <\/span>420<\/span> <\/span>},<\/span> <\/span>\"id\"<\/span>:<\/span> <\/span>\"cccc0000-0000-4000-8000-0000000000f3\"<\/span>,<\/span> <\/span>\"name\"<\/span>:<\/span> <\/span>\"Sticky Note 00f3\"<\/span>,<\/span> <\/span>\"type\"<\/span>:<\/span> <\/span>\"n8n-nodes-base.stickyNote\"<\/span>,<\/span> <\/span>\"typeVersion\"<\/span>:<\/span> <\/span>1<\/span>,<\/span> <\/span>\"position\"<\/span>:<\/span> <\/span>[<\/span> <\/span>175<\/span>,<\/span> <\/span>-200<\/span> <\/span>]<\/span> <\/span>},<\/span> <\/span>{<\/span> <\/span>\"parameters\"<\/span>:<\/span> <\/span>{<\/span> <\/span>\"content\"<\/span>:<\/span> <\/span>\"## 3. Send + log<\/span>\\n<\/span>Replace the placeholder with your real send node. Both branches log what went out.\"<\/span>,<\/span> <\/span>\"color\"<\/span>:<\/span> <\/span>7<\/span>,<\/span> <\/span>\"width\"<\/span>:<\/span> <\/span>515<\/span>,<\/span> <\/span>\"height\"<\/span>:<\/span> <\/span>580<\/span> <\/span>},<\/span> <\/span>\"id\"<\/span>:<\/span> <\/span>\"cccc0000-0000-4000-8000-0000000000f4\"<\/span>,<\/span> <\/span>\"name\"<\/span>:<\/span> <\/span>\"Sticky Note 00f4\"<\/span>,<\/span> <\/span>\"type\"<\/span>:<\/span> <\/span>\"n8n-nodes-base.stickyNote\"<\/span>,<\/span> <\/span>\"typeVersion\"<\/span>:<\/span> <\/span>1<\/span>,<\/span> <\/span>\"position\"<\/span>:<\/span> <\/span>[<\/span> <\/span>615<\/span>,<\/span> <\/span>-200<\/span> <\/span>]<\/span> <\/span>}<\/span> <\/span>],<\/span> <\/span>\"connections\"<\/span>:<\/span> <\/span>{<\/span> <\/span>\"Every 12 hours\"<\/span>:<\/span> <\/span>{<\/span> <\/span>\"main\"<\/span>:<\/span> <\/span>[<\/span> <\/span>[<\/span> <\/span>{<\/span> <\/span>\"node\"<\/span>:<\/span> <\/span>\"Completed visits (demo data)\"<\/span>,<\/span> <\/span>\"type\"<\/span>:<\/span> <\/span>\"main\"<\/span>,<\/span> <\/span>\"index\"<\/span>:<\/span> <\/span>0<\/span> <\/span>}<\/span> <\/span>]<\/span> <\/span>]<\/span> <\/span>},<\/span> <\/span>\"Completed visits (demo data)\"<\/span>:<\/span> <\/span>{<\/span> <\/span>\"main\"<\/span>:<\/span> <\/span>[<\/span> <\/span>[<\/span> <\/span>{<\/span> <\/span>\"node\"<\/span>:<\/span> <\/span>\"Pick window + build message\"<\/span>,<\/span> <\/span>\"type\"<\/span>:<\/span> <\/span>\"main\"<\/span>,<\/span> <\/span>\"index\"<\/span>:<\/span> <\/span>0<\/span> <\/span>}<\/span> <\/span>]<\/span> <\/span>]<\/span> <\/span>},<\/span> <\/span>\"Pick window + build message\"<\/span>:<\/span> <\/span>{<\/span> <\/span>\"main\"<\/span>:<\/span> <\/span>[<\/span> <\/span>[<\/span> <\/span>{<\/span> <\/span>\"node\"<\/span>:<\/span> <\/span>\"Send follow-up (replace me)\"<\/span>,<\/span> <\/span>\"type\"<\/span>:<\/span> <\/span>\"main\"<\/span>,<\/span> <\/span>\"index\"<\/span>:<\/span> <\/span>0<\/span> <\/span>}<\/span> <\/span>]<\/span> <\/span>]<\/span> <\/span>},<\/span> <\/span>\"Send follow-up (replace me)\"<\/span>:<\/span> <\/span>{<\/span> <\/span>\"main\"<\/span>:<\/span> <\/span>[<\/span> <\/span>[<\/span> <\/span>{<\/span> <\/span>\"node\"<\/span>:<\/span> <\/span>\"Review ask?\"<\/span>,<\/span> <\/span>\"type\"<\/span>:<\/span> <\/span>\"main\"<\/span>,<\/span> <\/span>\"index\"<\/span>:<\/span> <\/span>0<\/span> <\/span>}<\/span> <\/span>]<\/span> <\/span>]<\/span> <\/span>},<\/span> <\/span>\"Review ask?\"<\/span>:<\/span> <\/span>{<\/span> <\/span>\"main\"<\/span>:<\/span> <\/span>[<\/span> <\/span>[<\/span> <\/span>{<\/span> <\/span>\"node\"<\/span>:<\/span> <\/span>\"Log review ask\"<\/span>,<\/span> <\/span>\"type\"<\/span>:<\/span> <\/span>\"main\"<\/span>,<\/span> <\/span>\"index\"<\/span>:<\/span> <\/span>0<\/span> <\/span>}<\/span> <\/span>],<\/span> <\/span>[<\/span> <\/span>{<\/span> <\/span>\"node\"<\/span>:<\/span> <\/span>\"Log rebook nudge\"<\/span>,<\/span> <\/span>\"type\"<\/span>:<\/span> <\/span>\"main\"<\/span>,<\/span> <\/span>\"index\"<\/span>:<\/span> <\/span>0<\/span> <\/span>}<\/span> <\/span>]<\/span> <\/span>]<\/span> <\/span>}<\/span> <\/span>}<\/span> <\/span>}<\/span> <\/span><\/code><\/pre>\n
    \n<\/p><\/div>\n<\/p><\/div>\n
      <\/a> Where this fits <\/h2>\n
    This is the fourth full build in the series. Appointment reminders
     with a no-double-send
     guard<\/a>,
         waitlist backfill that fills cancelled slots
     automatically<\/a>,
     and     fee recovery with a polite escalation
     ladder<\/a>
     came before. This one grows the good side of the ledger: reviews and
     rebookings instead of losses. If you want the Dutch-language versions
     plus the surrounding pack (booking intake, KPI digest) in one download,
     it is here:     https:\/\/vlotstream.gumroad.com\/l\/rhmxw<\/a><\/p>\n
      <\/a> Free companion tool <\/h2>\n
    Want the number before the workflow? I put the no-show math in a small
     free calculator (EN\/NL, no signup, runs in your browser):     no-show cost
     calculator<\/a><\/p>\n<\/p><\/div>\n<\/div>\n<\/div>\n<\/div>\n
    Fuente: Art\u00edculo original<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
    Edit the treatments and weeks to match your own list. Clinics translate this trivially: check-up intervals and recall periods are exactly this map. When a treatment is missing, the Default entry catches it, so no customer silently drops out. What the workflow does Seven nodes, one schedule trigger: Every 12 hours, a trigger fires. Completed […]<\/p>\n","protected":false},"author":1,"featured_media":5743,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"webixso_pending_account_ids":""},"categories":[41],"tags":[],"class_list":["post-5744","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-devto"],"jetpack_publicize_connections":[],"_links":{"self":[{"href":"https:\/\/tucumandevelopers.com\/index.php\/wp-json\/wp\/v2\/posts\/5744","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tucumandevelopers.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tucumandevelopers.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tucumandevelopers.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tucumandevelopers.com\/index.php\/wp-json\/wp\/v2\/comments?post=5744"}],"version-history":[{"count":0,"href":"https:\/\/tucumandevelopers.com\/index.php\/wp-json\/wp\/v2\/posts\/5744\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tucumandevelopers.com\/index.php\/wp-json\/wp\/v2\/media\/5743"}],"wp:attachment":[{"href":"https:\/\/tucumandevelopers.com\/index.php\/wp-json\/wp\/v2\/media?parent=5744"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tucumandevelopers.com\/index.php\/wp-json\/wp\/v2\/categories?post=5744"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tucumandevelopers.com\/index.php\/wp-json\/wp\/v2\/tags?post=5744"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}