{"product_id":"n8n-workflow-google-calendar-sms-appointment-reminders","title":"n8n Workflow: Google Calendar SMS Appointment Reminders","description":"\u003ch3\u003eNever miss an appointment—this n8n workflow sends Google Calendar SMS reminders automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow checks your upcoming \u003cstrong\u003eGoogle Calendar\u003c\/strong\u003e events every hour, extracts the client’s name and mobile number from the event details, and sends a personalized \u003cstrong\u003eSMS appointment reminder\u003c\/strong\u003e via the \u003cstrong\u003eSMS Vert Pro MCP API\u003c\/strong\u003e. It also writes a sent\/failed marker back into the event description to prevent duplicate reminders.\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 (hourly)\u003c\/strong\u003e to process upcoming appointments.\u003c\/li\u003e\n  \u003cli\u003eFetches events from \u003cstrong\u003enow through the next configured hours\u003c\/strong\u003e (default: 24) and \u003cstrong\u003eexpands recurring events\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSkips\u003c\/strong\u003e events that are \u003cstrong\u003ecancelled\u003c\/strong\u003e or \u003cstrong\u003eall-day\u003c\/strong\u003e, and ignores events already tagged with an SMS reminder marker.\u003c\/li\u003e\n  \u003cli\u003eEnforces \u003cstrong\u003esending hours\u003c\/strong\u003e, so reminders only go out at appropriate times.\u003c\/li\u003e\n  \u003cli\u003eExtracts \u003cstrong\u003eclient name\u003c\/strong\u003e and a \u003cstrong\u003emobile number\u003c\/strong\u003e from the event \u003cstrong\u003edescription\/location\u003c\/strong\u003e, then generates a personalized SMS message from a \u003cstrong\u003etemplate\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eIf a valid mobile number is found, sends the SMS using the \u003cstrong\u003eSMS Vert Pro MCP endpoint\u003c\/strong\u003e and records whether it \u003cstrong\u003esucceeded or failed\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eUpdates the Google Calendar event description with:\n    \u003cul\u003e\n      \u003cli\u003e\n\u003cstrong\u003e[SMS reminder sent …]\u003c\/strong\u003e when successful\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003e[SMS reminder failed …]\u003c\/strong\u003e when sending fails\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003e[SMS reminder not sent: no mobile number found]\u003c\/strong\u003e when the number is missing (so it can be fixed and retried)\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\u003eReduce no-shows for client appointments by sending reminders based on your existing Google Calendar entries.\u003c\/li\u003e\n  \u003cli\u003eOperational troubleshooting: quickly identify which events failed SMS delivery and why (marker written back to the event).\u003c\/li\u003e\n  \u003cli\u003eMobile number validation workflow: automatically flag events missing a phone number.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes \/ stack:\u003c\/strong\u003e if, set, code, sticky note, \u003cstrong\u003eGoogle Calendar\u003c\/strong\u003e, \u003cstrong\u003eSchedule Trigger\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Calendar + \u003cstrong\u003eSMS Vert Pro MCP API\u003c\/strong\u003e (Bearer Auth using your SMS Vert Pro API V2 token)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCore logic:\u003c\/strong\u003e scheduled event reading, recurring expansion, SMS sending, and event description status updates to prevent duplicates\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46146229534899,"sku":"N8N-20276","price":2.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/z79H4rhBB81BdEizU7FF6_I7By1egn.png?v=1790845289","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-google-calendar-sms-appointment-reminders","provider":"N8N Commerce","version":"1.0","type":"link"}