Send TDS, GST and ROC compliance reminders via WhatsApp, Sheets and GPT-4o-mini
Ready for 3.0What this workflow does
This AI workflow has 26 nodes and runs on a schedule (cron 0 6 1,15 * *) (plus 2 other triggers). Along the way it connects Google Sheets, WhatsApp Business Cloud, Google Drive and OpenAI. It also calls graph.facebook.com over HTTP.
How it runs
Trigger: On a schedule (cron 0 6 1,15 * *) (plus 2 other triggers).
- Read Clients (Google Sheets): uses Google Sheets
- Read Tracker (Reminders) (Google Sheets): uses Google Sheets
- Read Clients (Inbound) (Google Sheets): uses Google Sheets
- Read Tracker (Generator) (Google Sheets): uses Google Sheets
- Build Reminder Payloads (Code): runs custom JavaScript code
- Read Tracker (Inbound) (Google Sheets): uses Google Sheets
- Generate Upcoming Deadlines (Code): runs custom JavaScript code
- Send WhatsApp Reminder (HTTP Request): calls graph.facebook.com (POST)
- Route Incoming Message (Code): runs custom JavaScript code
- Append New Tasks (Google Sheets): append
…plus 13 more steps. See the full node list below.
Services it uses
HTTP calls to: graph.facebook.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (8)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - WhatsApp Trigger
n8n-nodes-base.whatsAppTrigger - Switch
n8n-nodes-base.switch - Google Drive
n8n-nodes-base.googleDrive - OpenAI
@n8n/n8n-nodes-langchain.openAi
From the author
Quick overview This workflow uses Google Sheets as a compliance tracker for CA firms, sending scheduled WhatsApp Business API reminders for upcoming TDS/GST/ROC deadlines and handling inbound WhatsApp messages to store client documents in Google Drive and…