{"product_id":"n8n-workflow-google-sheets-to-calendar-appointments-gmail-reminders","title":"n8n Workflow: Google Sheets to Calendar Appointments + Gmail Reminders","description":"\u003ch3\u003eTurn new Google Form appointment requests into confirmed Google Calendar events—with Gmail reminders\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n workflow\u003c\/strong\u003e watches your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e form responses for new patient booking requests, verifies availability in \u003cstrong\u003eGoogle Calendar\u003c\/strong\u003e, creates confirmed appointments, and sends both confirmation and timed reminder emails via \u003cstrong\u003eGmail\u003c\/strong\u003e—while saving the booking record in \u003cstrong\u003eSupabase\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHourly trigger:\u003c\/strong\u003e Runs every hour when a new row is added to your Google Sheets form responses sheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalize and schedule:\u003c\/strong\u003e Processes submitted patient details, combines the preferred date and time into an ISO appointment start datetime.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCheck availability:\u003c\/strong\u003e Looks at the doctor’s Google Calendar for existing events in the requested \u003cstrong\u003e30-minute\u003c\/strong\u003e time window.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHandle unavailable slots:\u003c\/strong\u003e If the slot is taken, sends an \u003cstrong\u003e“Appointment Slot Unavailable”\u003c\/strong\u003e email using Gmail.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eConfirm available appointments:\u003c\/strong\u003e If available, creates the appointment event in Google Calendar and captures the calendar \u003cstrong\u003eevent ID\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePersist booking data:\u003c\/strong\u003e Saves patient, doctor, time, symptoms, event ID, and status to a \u003cstrong\u003eSupabase\u003c\/strong\u003e table.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSend reminders:\u003c\/strong\u003e Uses a wait step to send a reminder email via Gmail \u003cstrong\u003etwo hours before\u003c\/strong\u003e the appointment time, then updates the Supabase record status to \u003cstrong\u003e“Reminder Sent.”\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eClinics that collect appointments via \u003cstrong\u003eGoogle Forms\u003c\/strong\u003e into a Google Sheets response sheet.\u003c\/li\u003e\n  \u003cli\u003eTeams that need real-time-ish scheduling without manual calendar checks or copy\/paste email sending.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators and automation engineers building an n8n-backed booking pipeline with audit-ready storage in Supabase.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTriggers \u0026amp; logic:\u003c\/strong\u003e hour-based trigger, \u003cem\u003eif\u003c\/em\u003e, \u003cem\u003eset\u003c\/em\u003e, and \u003cem\u003ewait\u003c\/em\u003e steps\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, \u003cstrong\u003eGoogle Calendar\u003c\/strong\u003e, \u003cstrong\u003eGmail\u003c\/strong\u003e, \u003cstrong\u003eSupabase\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAdditional node:\u003c\/strong\u003e \u003cem\u003esticky note\u003c\/em\u003e for workflow clarity\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eSetup\u003c\/strong\u003e: Connect Google Sheets (select spreadsheet\/sheet), Google Calendar (choose calendar), Gmail (configure templates for unavailable\/confirmation\/reminder), and Supabase (connect your database).\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45931005837491,"sku":"N8N-18988","price":66.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/px1l5bGuvN4EAfntozqk3_Cl8PyW9O.png?v=1788253416","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-google-sheets-to-calendar-appointments-gmail-reminders","provider":"N8N Commerce","version":"1.0","type":"link"}