{"product_id":"whatsapp-task-manager-with-n8n-google-sheets-openai-agents","title":"WhatsApp Task Manager with n8n, Google Sheets \u0026 OpenAI Agents","description":"\u003ch3\u003eTurn WhatsApp messages into live task updates—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow connects to \u003cstrong\u003eWhatsApp (via WAHA webhook)\u003c\/strong\u003e and uses \u003cstrong\u003eOpenAI agents\u003c\/strong\u003e to create, read, and update tasks stored in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e. When assignees reply (optionally with photo proof), the workflow summarizes updates and forwards them to supervisors via WhatsApp—uploading photos to \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e when included.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives WhatsApp messages\u003c\/strong\u003e through an n8n \u003cstrong\u003ewebhook\u003c\/strong\u003e endpoint exposed by n8n.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDetects supervisor messages\u003c\/strong\u003e by checking the incoming chat against configured supervisor chat IDs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSupervisor handling with OpenAI agents:\u003c\/strong\u003e an OpenAI agent reads and writes task data and contacts in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, then replies back to supervisors through the \u003cstrong\u003eWAHA API\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAssignee handling:\u003c\/strong\u003e for non-supervisor messages, the workflow ignores bot\/status broadcasts and checks whether the message \u003cem\u003equotes an original task message\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequests a quoted task if missing:\u003c\/strong\u003e if no quote is present, it prompts the user (via WAHA API) to reply using a quoted message.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates tasks in Google Sheets:\u003c\/strong\u003e if a task is quoted, an OpenAI agent extracts the \u003cstrong\u003eTask ID\u003c\/strong\u003e, interprets updates (status, due date, summary), and updates the matching Google Sheets row.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNotifies supervisors:\u003c\/strong\u003e it forwards the formatted update to one or two supervisors via WhatsApp.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHandles photo proof:\u003c\/strong\u003e if a photo is attached, it downloads it, uploads it to \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e, and forwards the update with the image to both supervisors.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eField teams reporting task progress through WhatsApp without logging into a dashboard.\u003c\/li\u003e\n  \u003cli\u003eSupervisor teams monitoring task status changes in near real-time from WhatsApp.\u003c\/li\u003e\n  \u003cli\u003eProof-based accountability: attaching photos to task replies and archiving them to Google Drive.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eIntegrations: \u003cstrong\u003eWAHA (WhatsApp)\u003c\/strong\u003e, \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e, \u003cstrong\u003eOpenAI\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003eWorkflow logic\/nodes (as provided): \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ewebhook\u003c\/strong\u003e, \u003cstrong\u003esticky note\u003c\/strong\u003e, \u003cstrong\u003egoogle drive\u003c\/strong\u003e, \u003cstrong\u003ehttp request\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003eUses \u003cstrong\u003ePostgres\u003c\/strong\u003e to store chat history for supervisor and assignee conversations.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003ePerfect for n8n users and automation engineers\u003c\/strong\u003e building WhatsApp-to-SaaS task management with OpenAI-driven interpretation.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45945697370291,"sku":"N8N-19100","price":25.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/vPkgqyp0mqQ1VumkvWjE-_K4i1LsJA.png?v=1788426387","url":"https:\/\/buyflowscripts.com\/products\/whatsapp-task-manager-with-n8n-google-sheets-openai-agents","provider":"N8N Commerce","version":"1.0","type":"link"}