{"product_id":"n8n-dental-recovery-workflow-google-sheets-gmail","title":"n8n Dental Recovery Workflow: Google Sheets + Gmail","description":"\u003ch3\u003eAutomate Dental Follow-Ups in n8n—From Google Sheets to Gmail (Daily + Weekly)\u003c\/h3\u003e\n\u003cp\u003eThe \u003cstrong\u003en8n Dental Recovery Workflow: Google Sheets + Gmail\u003c\/strong\u003e automatically finds unscheduled, not-yet-recovered dental treatment plans in your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, sends the right reminder emails via \u003cstrong\u003eGmail\u003c\/strong\u003e, escalates long-unresponsive cases to the front desk, and delivers a weekly recovery summary to the practice owner.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDaily scheduled run (every morning)\u003c\/strong\u003e: Loads patient and procedure data from your Google Sheet tabs: \u003cstrong\u003ePatients\u003c\/strong\u003e and \u003cstrong\u003eProcedureLog\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRecovery status + scheduling logic\u003c\/strong\u003e: Identifies treatment plans that are \u003cem\u003estill unscheduled\u003c\/em\u003e and \u003cem\u003enot marked as recovered\u003c\/em\u003e, then determines the next action based on the existing follow-up stage.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReminder sequence\u003c\/strong\u003e: Sends \u003cstrong\u003e1st\/2nd\/3rd reminder\u003c\/strong\u003e emails after \u003cstrong\u003e3\/14\/30 days\u003c\/strong\u003e as applicable.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFront desk escalation\u003c\/strong\u003e: If a case remains unresponsive for \u003cstrong\u003e45 days\u003c\/strong\u003e, it sends a \u003cstrong\u003edetailed internal escalation email\u003c\/strong\u003e to the front desk via Gmail for a personal call.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrevents repeated outreach\u003c\/strong\u003e: Updates the matching \u003cstrong\u003eProcedureLog\u003c\/strong\u003e row in Google Sheets to record that the plan is escalated and should not be contacted automatically again.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGeneric patient reminders\u003c\/strong\u003e: For cases due for the next step, it sends the corresponding patient email and updates \u003cstrong\u003eProcedureLog\u003c\/strong\u003e with the new follow-up stage and last contact date.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWeekly run (every Monday)\u003c\/strong\u003e: Recomputes recovery and pipeline totals from \u003cstrong\u003eProcedureLog\u003c\/strong\u003e and emails a \u003cstrong\u003eweekly summary\u003c\/strong\u003e to the practice owner via Gmail.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eDental practices managing \u003cstrong\u003eunscheduled treatment plans\u003c\/strong\u003e that need consistent follow-up reminders.\u003c\/li\u003e\n  \u003cli\u003eFront desk workflows that require \u003cstrong\u003eescalation after prolonged inactivity\u003c\/strong\u003e to trigger human outreach.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators and n8n users who want a repeatable \u003cstrong\u003eGoogle Sheets + Gmail\u003c\/strong\u003e automation for healthcare-adjacent recovery reporting.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\u003c\/strong\u003e: \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (OAuth2) and \u003cstrong\u003eGmail\u003c\/strong\u003e (OAuth2)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/logic\u003c\/strong\u003e: \u003cstrong\u003eSchedule Trigger\u003c\/strong\u003e, \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, \u003cstrong\u003eGmail\u003c\/strong\u003e, \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003esticky note\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup\u003c\/strong\u003e: Connect OAuth2 credentials; configure your \u003cstrong\u003espreadsheet ID\u003c\/strong\u003e and ensure tab names match \u003cstrong\u003ePatients\u003c\/strong\u003e and \u003cstrong\u003eProcedureLog\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45974312911027,"sku":"N8N-19295","price":10.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/jRxJV9sMOzrRcBYBJ6RZd_V3q9KFBA.png?v=1788772171","url":"https:\/\/buyflowscripts.com\/products\/n8n-dental-recovery-workflow-google-sheets-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}