{"product_id":"n8n-google-sheets-workflow-post-visit-reviews-rebooking","title":"n8n Google Sheets Workflow: Post-Visit Reviews \u0026 Rebooking","description":"\u003ch3\u003eTurn completed visits into timely WhatsApp follow-ups—without duplicates\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically checks completed visits every \u003cstrong\u003e12 hours\u003c\/strong\u003e, validates the data, then sends either a \u003cstrong\u003eWhatsApp review request\u003c\/strong\u003e for first-time customers or a \u003cstrong\u003erebooking nudge\u003c\/strong\u003e for returning customers—while skipping invalid, out-of-window, or already-messaged appointments.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a schedule:\u003c\/strong\u003e uses a schedule trigger to process visits every \u003cstrong\u003e12 hours\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads and validates visit rows:\u003c\/strong\u003e confirms each record includes \u003cem\u003eappointment ID\u003c\/em\u003e, \u003cem\u003ecustomer name\u003c\/em\u003e, \u003cem\u003ephone number\u003c\/em\u003e, and a \u003cem\u003eparseable visit time\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHandles invalid data safely:\u003c\/strong\u003e routes invalid rows to an \u003cstrong\u003eerror log\u003c\/strong\u003e and continues processing valid records.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApplies a post-visit timing window:\u003c\/strong\u003e filters eligible visits to a \u003cstrong\u003e20–34 hour\u003c\/strong\u003e window after the visit time, skipping visits that are not yet due or already outside the range.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrevents duplicate messages:\u003c\/strong\u003e tracks which \u003cstrong\u003eappointment IDs\u003c\/strong\u003e have already received a follow-up, so customers aren’t contacted multiple times.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates the outbound message:\u003c\/strong\u003e builds a WhatsApp message that asks first-time customers for a review and nudges returning customers to rebook based on \u003cstrong\u003etreatment type\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends and logs:\u003c\/strong\u003e uses a placeholder send step (to replace with your messaging provider) and logs whether a \u003cstrong\u003ereview ask\u003c\/strong\u003e or \u003cstrong\u003erebooking nudge\u003c\/strong\u003e was sent.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eDay-to-day SaaS or service operations that want \u003cstrong\u003econsistent post-visit communication\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eRebooking funnels for clinics\/salons\/spa teams using \u003cstrong\u003eappointment-based follow-ups\u003c\/strong\u003e tied to treatment type.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers who need a reliable pattern for \u003cstrong\u003evalidation, time-window filtering, and deduplication\u003c\/strong\u003e in n8n.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTech stack \/ nodes used:\u003c\/strong\u003e \u003ccode\u003eschedule trigger\u003c\/code\u003e, \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003ccode\u003esticky note\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eInput setup:\u003c\/strong\u003e replace the demo visit source with your production data source (e.g., a \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e spreadsheet) with fields like \u003ccode\u003eappointment_id\u003c\/code\u003e, \u003ccode\u003ecustomer_name\u003c\/code\u003e, \u003ccode\u003ephone\u003c\/code\u003e, \u003ccode\u003evisited_at\u003c\/code\u003e, \u003ccode\u003etreatment\u003c\/code\u003e, and \u003ccode\u003efirst_visit\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMessaging:\u003c\/strong\u003e replace the placeholder send step with your chosen integration (e.g., \u003cstrong\u003eWhatsApp Business Cloud\u003c\/strong\u003e, \u003cstrong\u003eSMS\u003c\/strong\u003e, or \u003cstrong\u003eemail\u003c\/strong\u003e).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46196309033139,"sku":"N8N-20721","price":38.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/I2ggUB5WgGlI3b-AKQCku_TtHkXghV.png?v=1791623200","url":"https:\/\/buyflowscripts.com\/products\/n8n-google-sheets-workflow-post-visit-reviews-rebooking","provider":"N8N Commerce","version":"1.0","type":"link"}