{"product_id":"n8n-whatsapp-daily-task-reminders-from-google-sheets-waha","title":"n8n WhatsApp Daily Task Reminders from Google Sheets (WAHA)","description":"\u003ch3\u003eWAHA WhatsApp Daily Task Reminders from Google Sheets (WAHA)\u003c\/h3\u003e\n\u003cp\u003eStop chasing due dates—this n8n workflow automatically reads tasks due today in your Google Sheets and sends one consolidated WhatsApp reminder to each assignee via the WAHA \u003ccode\u003e\/api\/sendText\u003c\/code\u003e endpoint.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cp\u003eBuilt for daily task follow-ups, this workflow runs every afternoon and performs the following:\u003c\/p\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduled execution:\u003c\/strong\u003e Triggers on a schedule to run every afternoon.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRead Google Sheets tasks:\u003c\/strong\u003e Loads your Google Sheets connection, then pulls rows from the \u003cstrong\u003e“Task”\u003c\/strong\u003e sheet filtered to tasks where \u003cstrong\u003eDue_Date\u003c\/strong\u003e matches today.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilter by status:\u003c\/strong\u003e Keeps only tasks with \u003cstrong\u003eStatus\u003c\/strong\u003e equal to \u003cstrong\u003e“Not Started”\u003c\/strong\u003e or \u003cstrong\u003e“Ongoing”\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGroup by assignee:\u003c\/strong\u003e Groups remaining tasks by \u003cstrong\u003eAssigned_To\u003c\/strong\u003e and generates \u003cstrong\u003eone WhatsApp message per assignee\u003c\/strong\u003e containing all due-today tasks.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSend via WAHA API:\u003c\/strong\u003e Sends messages using an HTTP POST to the WAHA \u003ccode\u003e\/api\/sendText\u003c\/code\u003e endpoint (using your configured WAHA server URL, API key, session name, and country-code prefix).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTrack follow-ups in the sheet:\u003c\/strong\u003e Extracts the \u003cstrong\u003eTask ID\u003c\/strong\u003e values included in each sent message and increments \u003cstrong\u003eCount_no._of_FollowUp\u003c\/strong\u003e for each reminded task, pausing briefly between updates.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eDaily operational follow-ups for teams where WhatsApp is the primary communication channel.\u003c\/li\u003e\n  \u003cli\u003eReminder workflows for SaaS operators managing onboarding, support tasks, or internal execution checklists.\u003c\/li\u003e\n  \u003cli\u003eReducing missed deadlines by notifying only tasks that are still \u003cem\u003eNot Started\u003c\/em\u003e or \u003cem\u003eOngoing\u003c\/em\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Sheets + WAHA (WhatsApp) via HTTP POST.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes \/ tools used:\u003c\/strong\u003e set, code, wait, filter, sticky note, http request.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequired columns in “Task” sheet:\u003c\/strong\u003e \u003cem\u003eTask ID\u003c\/em\u003e, \u003cem\u003eAssigned_To\u003c\/em\u003e, \u003cem\u003eAssignee_WhatsApp\u003c\/em\u003e, \u003cem\u003eTask_Details\u003c\/em\u003e, \u003cem\u003eDue_Date\u003c\/em\u003e, \u003cem\u003eStatus\u003c\/em\u003e, \u003cem\u003eCount_no._of_FollowUp\u003c\/em\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eFor best results, store \u003cstrong\u003eDue_Date\u003c\/strong\u003e in the exact same format your workflow filters for (example: \u003ccode\u003e05 Apr 2026\u003c\/code\u003e), and ensure \u003cstrong\u003eStatus\u003c\/strong\u003e values match \u003cstrong\u003e“Not Started”\u003c\/strong\u003e and \u003cstrong\u003e“Ongoing”\u003c\/strong\u003e.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45945692717235,"sku":"N8N-19104","price":45.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/yyx1GQxXqvh6fxORtoFP6_tYJ6gfda.png?v=1788426277","url":"https:\/\/buyflowscripts.com\/products\/n8n-whatsapp-daily-task-reminders-from-google-sheets-waha","provider":"N8N Commerce","version":"1.0","type":"link"}