Manage WhatsApp vehicle service reminders and bookings with WATI and Google Sheets
UnknownWhat this workflow does
This workflow has 32 nodes and runs on a schedule (cron 0 9 * * *) (plus 2 other triggers). Along the way it connects Google Sheets and Wati (community).
How it runs
Trigger: On a schedule (cron 0 9 * * *) (plus 2 other triggers).
- Sheets – Read All Vehicles (Google Sheets): uses Google Sheets
- Sheets – Read Appointments (Google Sheets): uses Google Sheets
- Command Router (Switch): routes items into 6 branches
- Check Service Due (Code): runs custom JavaScript code
- Check Tomorrow Appointments (Code): runs custom JavaScript code
- Sheets – Find Vehicle for Booking (Google Sheets): uses Google Sheets
- Sheets – Find Vehicle for Mileage (Google Sheets): uses Google Sheets
- Sheets – Read Service History (Google Sheets): uses Google Sheets
- Sheets – Read Vehicle for Status (Google Sheets): uses Google Sheets
- Parse Log Service (Code): runs custom JavaScript code
…plus 19 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 2 community packages, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that n8n-nodes-wati is verified or supports 3.0 (used in WATI – Send Service Reminder1, WATI – Send Appointment Reminder1, WATI – Send Available Slots1).
- Check that n8n-nodes-wati is verified or supports 3.0 (used in Wati Trigger).
Nodes used (6)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - Wati
n8n-nodes-wati.wati - Switch
n8n-nodes-base.switch - Wati Trigger
n8n-nodes-wati.watiTrigger
From the author
Streamline your automotive service center's operations with this comprehensive automation. This workflow manages the entire customer lifecycle—from automated service reminders and instant appointment booking via WhatsApp to mileage tracking and full service…