{"product_id":"n8n-workflow-auto-fill-cancelled-appts-from-google-sheets-waitlist","title":"n8n Workflow: Auto-Fill Cancelled Appts from Google Sheets Waitlist","description":"\u003ch3\u003eAutomatically re-offer cancelled appointment slots to your waitlist—every 15 minutes\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow finds cancelled appointments in your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e and automatically sends \u003cstrong\u003etime-limited slot-offer emails\u003c\/strong\u003e to the best-matching clients from your \u003cstrong\u003eWaitlist\u003c\/strong\u003e, updating both sheets and notifying staff of delivered, failed, and data-quality issues.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cp\u003eDesigned for reliable waitlist fulfillment, the workflow runs on a \u003cstrong\u003e15-minute schedule\u003c\/strong\u003e and performs these steps:\u003c\/p\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates setup\u003c\/strong\u003e: checks that required settings are present and that the \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e tabs include the expected column headers for both \u003cstrong\u003eBookings\u003c\/strong\u003e and \u003cstrong\u003eWaitlist\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMatches cancelled slots to eligible clients\u003c\/strong\u003e: reads both tabs, identifies cancelled appointments that meet your \u003cstrong\u003enotice \/ ahead-of-time rules\u003c\/strong\u003e, and selects the \u003cstrong\u003elongest-waiting eligible\u003c\/strong\u003e clients based on \u003cstrong\u003eservice\u003c\/strong\u003e and \u003cstrong\u003edate range\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrites offer status to Sheets\u003c\/strong\u003e: updates the chosen waitlist rows with an \u003cstrong\u003eoffered\u003c\/strong\u003e status and offer metadata, and updates the corresponding booking rows.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends slot-offer emails via Gmail\u003c\/strong\u003e: delivers time-limited offers using the \u003cstrong\u003eGmail\u003c\/strong\u003e node, with optional routing of emails to staff in \u003cstrong\u003etest mode\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTracks delivery results\u003c\/strong\u003e: confirms successful Gmail delivery or rolls back waitlist updates as needed; marks recipients as \u003cstrong\u003esend failed\u003c\/strong\u003e for undeliverable emails.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNotifies staff\u003c\/strong\u003e: emails a summary of offers sent and any delivery failures, plus a \u003cstrong\u003eonce-per-day\u003c\/strong\u003e report of malformed or duplicate rows that are skipped.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eFill gaps when a client cancels—without manual outreach.\u003c\/li\u003e\n  \u003cli\u003eOffer cancelled time slots to the longest-waiting eligible clients by service and availability windows.\u003c\/li\u003e\n  \u003cli\u003eImprove data quality by automatically flagging malformed\/duplicate waitlist or booking rows.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedule:\u003c\/strong\u003e runs every 15 minutes\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations \/ nodes:\u003c\/strong\u003e \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (Bookings + Waitlist tabs), \u003cstrong\u003eGmail\u003c\/strong\u003e, plus \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003esticky note\u003c\/strong\u003e, \u003cstrong\u003ehttp request\u003c\/strong\u003e, and \u003cstrong\u003eerror trigger\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eIf you’re an n8n user, automation engineer, or SaaS operator managing appointment capacity, this workflow helps you maximize rebooking while keeping your data and communications consistent.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46254508572851,"sku":"N8N-21340","price":56.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/YtBPSe155AiZigpmHYJ1m_pO3pLyMs.png?v=1792573471","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-auto-fill-cancelled-appts-from-google-sheets-waitlist","provider":"N8N Commerce","version":"1.0","type":"link"}