Quick overview
This workflow uses Google Sheets, Google Calendar, and Supergreen (WhatsApp) to send interactive appointment reminder polls, capture client poll votes in real time, update booking status in the sheet, and notify staff when clients are running late or request a reschedule.
How it works
- Runs every hour to scan upcoming appointments.
- Reads rows from the Google Sheets “Appointments” tab and filters to scheduled bookings within the reminder window that have not been sent a reminder yet.
- Checks the corresponding Google Calendar event (when an event ID is present) and skips messaging if the event is cancelled while updating the sheet to reflect the cancellation.
- Sends a 3-option WhatsApp poll via Supergreen to let the client confirm, report running late, or request a reschedule.
- Updates Google Sheets to mark the reminder as sent with a timestamp.
- Triggers when Supergreen receives an incoming WhatsApp poll vote, matches the voter to the nearest active booking in Google Sheets, and maps the vote to a new booking status.
- Updates the booking status in Google Sheets, replies to the client on WhatsApp (including a reschedule link when requested), and sends a WhatsApp message to a staff group for “Running Late” or “Reschedule Requested” votes.
Setup
- Install and configure the community node n8n-nodes-supergreen and add a Supergreen API credential for WhatsApp messaging and webhooks.
- Add Google Sheets OAuth2 credentials, create an “Appointments” sheet with the expected columns (including bookingId, phone, appointmentIso, calendarEventId, status, reminderSent, reminderSentAt, lastVoteAt), and set your spreadsheet ID in both configuration steps.
- Add Google Calendar OAuth2 credentials and set the calendar ID used to validate events (and ensure appointment rows contain calendarEventId when you want calendar cross-checking).
- Set your business name, reminder window (hours), client reschedule URL, and the staff WhatsApp group chat ID used for alerts.
Requirements
- n8n-nodes-supergreen (tested v0.1.5 — verified community node available directly on n8n Cloud and self-hosted n8n) + Supergreen API account (https://supergreen.cc)
Customization
- Change reminderWindowHours (e.g., 48h or 2h), customize the 3 WhatsApp poll choices, or route staff alerts to Slack or Telegram instead of a WhatsApp group.