Send appointment confirmations, reminders and review requests with Google Sheets and Gmail

by Manik Chandra Dhor ✓ · 108 views · created 2026-07-14 · Ticket Management

What this workflow does

This workflow has 11 nodes and runs on a schedule (every day at 08:00) (plus 1 other trigger). Along the way it connects Google Sheets and Gmail.

How it runs

Trigger: On a schedule (every day at 08:00) (plus 1 other trigger).

1. Configuration (Code): runs custom JavaScript code
2. Get Appointments (Google Sheets): read (sheet)
3. Classify Appointments (Code): runs custom JavaScript code
4. Route by Lifecycle Stage (Switch): routes items into 4 branches
5. Send Confirmation (Gmail): send (message)
6. Send Reminder (Gmail): send (message)
7. Send No-Show Win-Back (Gmail): send (message)
8. Send Review Request (Gmail): send (message)
9. Update Appointment Status (Google Sheets): append or update (sheet)

Services it uses

Google SheetsGmail

Before you upgrade to n8n 3.0

Nodes used (6)

• Schedule Triggern8n-nodes-base.scheduleTrigger
• Coden8n-nodes-base.code
• Google Sheetsn8n-nodes-base.googleSheets
• Switchn8n-nodes-base.switch
• Gmailn8n-nodes-base.gmail
• Manual Triggern8n-nodes-base.manualTrigger

From the author

Quick overview This workflow runs daily at 8 AM to read appointment records from Google Sheets, send the right Gmail email (confirmation, reminder, no-show win-back, or post-visit review request) based on each appointment’s status and date, and then update…

View the original on n8n.io → Check your own copy