{"product_id":"whatsapp-compliance-reminders-for-tds-gst-roc-via-n8n-sheets","title":"WhatsApp Compliance Reminders for TDS GST ROC via n8n + Sheets","description":"\u003ch3\u003eNever miss a TDS, GST, or ROC compliance deadline—send WhatsApp reminders automatically using n8n + Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow reads your client roster from Google Sheets, tracks upcoming TDS\/GST\/ROC tasks, and proactively sends \u003cstrong\u003eWhatsApp Business API\u003c\/strong\u003e compliance reminders for due dates and missing documents. It also handles inbound WhatsApp messages to store documents in Google Drive and update your checklist status.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMonthly planning (1st \u0026amp; 15th at 6 AM):\u003c\/strong\u003e Reads the client list and existing \u003cem\u003eCompliance_Tracker\u003c\/em\u003e from Google Sheets, generates upcoming TDS, GST, and ROC tasks for active clients, skips tasks that already exist, and appends new rows to the \u003cem\u003eCompliance_Tracker\u003c\/em\u003e sheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDaily reminder run (9 AM):\u003c\/strong\u003e Groups open items per client based on due dates and missing documents, then sends \u003cstrong\u003eone WhatsApp message per client\u003c\/strong\u003e with a summary of upcoming\/overdue items and what’s missing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTracker updates:\u003c\/strong\u003e After sending, the workflow records the reminder date and increments the reminder count in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eInbound WhatsApp triggers:\u003c\/strong\u003e Matches the WhatsApp sender to a client in the \u003cem\u003eClients\u003c\/em\u003e sheet and replies with the current checklist when the message is text.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDocument capture + checklist updates:\u003c\/strong\u003e For inbound files (documents\/images), it downloads media via the WhatsApp Business API, uploads to the client’s Google Drive folder, uses \u003cstrong\u003eOpenAI (gpt-4o-mini)\u003c\/strong\u003e to match the file to pending checklist items, updates \u003cem\u003eCompliance_Tracker\u003c\/em\u003e and \u003cem\u003eUpload_Log\u003c\/em\u003e, and sends a confirmation on WhatsApp.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eCA firms and compliance teams want automated WhatsApp compliance reminders for TDS\/GST\/ROC.\u003c\/li\u003e\n  \u003cli\u003eReduce follow-ups by collecting documents over WhatsApp and updating the checklist in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eOperational teams need a single source of truth for reminder status and uploads.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n schedules:\u003c\/strong\u003e Runs on the 1st \u0026amp; 15th at 6 AM; runs daily at 9 AM.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets:\u003c\/strong\u003e Reads\/updates \u003cem\u003eClients\u003c\/em\u003e, \u003cem\u003eCompliance_Tracker\u003c\/em\u003e, and \u003cem\u003eUpload_Log\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWhatsApp Business API:\u003c\/strong\u003e Sends reminders and handles inbound messages\/files.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Drive:\u003c\/strong\u003e Uploads client documents to the correct Drive folder.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI:\u003c\/strong\u003e Uses \u003cem\u003egpt-4o-mini\u003c\/em\u003e to classify uploads and map them to pending checklist items.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow nodes:\u003c\/strong\u003e code, switch, sticky note, google drive, http request, google sheets.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46114598977715,"sku":"N8N-20031","price":36.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/2KHEZN5QaQV0IEk8qmjMy_uyHUgx2i.png?v=1790586222","url":"https:\/\/buyflowscripts.com\/products\/whatsapp-compliance-reminders-for-tds-gst-roc-via-n8n-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}