Send SMS appointment reminders and track replies with Google Calendar and SMS Vert Pro MCP
Go to Workflow
3 Bees Online
Description
Quick overview
This workflow runs hourly to read upcoming Google Calendar events, extract the client’s name and mobile number from each event, send an appointment reminder via the SMS Vert Pro MCP API, and write a sent/failed status back into the event description to prevent duplicate reminders.
How it works
Runs every hour on a schedule.
Fetches all Google Calendar events starting between now and the next configured hours (default 24) and expands recurring events.
Skips cancelled/all-day/already-tagged events, enforces sending hours, extracts the client name and phone from the event description/location, and generates a personalized SMS message from a template.
If a valid mobile number is found, sends the SMS using the SMS Vert Pro MCP endpoint and records whether the send succeeded or failed.
Updates the Google Calendar event description with an “[SMS reminder sent …]” or “[SMS reminder failed …]” marker so the event is not reminded twice.
If no mobile number is found, updates the event description with “[SMS reminder not sent: no mobile number found]” so it can be fixed and retried.
Setup
Connect your Google account in the two Google Calendar nodes, then set calendar_id in Reminder settings (primary or the calendar's email address).
Create a Bearer Auth credential with your SMS Vert Pro API V2 token (log in at smsvertpro.com, then open https://www.smsvertpro.com/api/doc-v2.php to reveal it) and select it in the MCP Client node.
Update the reminder settings (sender name, business name, message template, timezone/locale, hours ahead, and allowed sending window).
Ensure each appointment event includes lines like “Name: …” and “Phone: …” (or equivalent labels such as Mobile/Tel) in the description so the workflow can extract recipient details.
Requirements
An SMS Vert Pro account with SMS credits
A Google account with Google Calendar
n8n with the MCP Client node (tested on n8n 2.22)
Customization
Set hours_ahead to 48 to remind two days before.
Set locale to fr, de or es to write dates in another language.
Change send_from and send_until to fit your opening hours.
This workflow was created by 3 Bees Online and shared publicly on the n8n community template library. n8nFind indexes it for discovery — the workflow remains the property of its original creator.