n8n WhatsApp Daily Task Reminders from Google Sheets (WAHA)

WAHA WhatsApp Daily Task Reminders from Google Sheets (WAHA)

Stop 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 /api/sendText endpoint.

What this workflow does

Built for daily task follow-ups, this workflow runs every afternoon and performs the following:

• Scheduled execution: Triggers on a schedule to run every afternoon.
• Read Google Sheets tasks: Loads your Google Sheets connection, then pulls rows from the “Task” sheet filtered to tasks where Due_Date matches today.
• Filter by status: Keeps only tasks with Status equal to “Not Started” or “Ongoing”.
• Group by assignee: Groups remaining tasks by Assigned_To and generates one WhatsApp message per assignee containing all due-today tasks.
• Send via WAHA API: Sends messages using an HTTP POST to the WAHA /api/sendText endpoint (using your configured WAHA server URL, API key, session name, and country-code prefix).
• Track follow-ups in the sheet: Extracts the Task ID values included in each sent message and increments Count_no._of_FollowUp for each reminded task, pausing briefly between updates.

Use cases

• Daily operational follow-ups for teams where WhatsApp is the primary communication channel.
• Reminder workflows for SaaS operators managing onboarding, support tasks, or internal execution checklists.
• Reducing missed deadlines by notifying only tasks that are still Not Started or Ongoing.

Technical details

• Integrations: Google Sheets + WAHA (WhatsApp) via HTTP POST.
• n8n nodes / tools used: set, code, wait, filter, sticky note, http request.
• Required columns in “Task” sheet: Task ID, Assigned_To, Assignee_WhatsApp, Task_Details, Due_Date, Status, Count_no._of_FollowUp.

For best results, store Due_Date in the exact same format your workflow filters for (example: 05 Apr 2026), and ensure Status values match “Not Started” and “Ongoing”.