{"product_id":"n8n-workflow-tiered-google-sheets-appointment-reminders-via-gmail","title":"n8n Workflow: Tiered Google Sheets Appointment Reminders via Gmail","description":"\u003ch3\u003eSend Tiered Google Sheets Appointment Reminders via Gmail—Automated Every Morning\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically checks upcoming appointments in your Google Sheets and sends tiered appointment reminders through Gmail—then updates the reminder status back in the sheet and emails staff with a daily delivery summary.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns every morning on a schedule\u003c\/strong\u003e and validates required configuration (Google Sheet ID, email addresses, booking URL, and reminder-day offsets).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads the Google Sheets “Bookings” tab\u003c\/strong\u003e (including formatted values) and stops if required column headers are missing or incorrectly typed.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSelects confirmed, future bookings\u003c\/strong\u003e that fall into the next reminder window (default: \u003cstrong\u003e7, 3, and 1 days before\u003c\/strong\u003e the appointment).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrevents duplicates and skips invalid rows\u003c\/strong\u003e by validating booking IDs, dates\/times, and email addresses.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends Gmail reminders\u003c\/strong\u003e for each due booking, routing messages based on mode: staff address in \u003cem\u003etest mode\u003c\/em\u003e, client address in \u003cem\u003elive mode\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUses special confirmation messaging for higher no-show risk clients\u003c\/strong\u003e, asking those clients to reply to confirm.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates Google Sheets before\/after sending\u003c\/strong\u003e: marks reminders as “sending,” sends via Gmail, then writes back success—or reverts on failure so it can retry next run.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmails staff daily summaries\u003c\/strong\u003e whenever reminders go out, including:\n    \u003cul\u003e\n      \u003cli\u003edelivered vs. failed reminder results\u003c\/li\u003e\n      \u003cli\u003ewho was asked to confirm\u003c\/li\u003e\n      \u003cli\u003ea separate list of rows skipped due to invalid identifiers, dates\/times, or email addresses\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eReducing missed appointments by sending automated reminders at 7\/3\/1 days.\u003c\/li\u003e\n  \u003cli\u003eLowering no-show rates by prompting higher-risk clients to reply to confirm.\u003c\/li\u003e\n  \u003cli\u003eOperational visibility: staff receive a daily Gmail delivery and data-quality report.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n scheduling + validation\u003c\/strong\u003e via Set and Code nodes\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets integration\u003c\/strong\u003e using an HTTP Request approach to read formatted booking data\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail delivery\u003c\/strong\u003e with routed recipients for test\/live modes\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eError handling\u003c\/strong\u003e using an Error Trigger node\u003c\/li\u003e\n  \u003cli\u003eIncludes a Sticky Note for workflow guidance\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46248881389747,"sku":"N8N-21219","price":47.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/tda5z4-IIeysDY0k9c1dd_RHBZKaqo.png?v=1792487167","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-tiered-google-sheets-appointment-reminders-via-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}