AI Bot: Google Sheet to WhatsApp

I manage multiple projects inside a single Google Sheet and I need an automated agent that can: • Read the sheet at regular intervals, pull rows matching our key columns—Dates and deadlines, Task statuses, and Assigned personnel—and then apply simple filters (e.g. due-today, overdue, status “pending”). • Map each row to the correct WhatsApp group solely by project type, then post a concise reminder containing the task title, responsible person, and due date. • Ideally, when someone replies with a structured prompt such as “done 1254” or “move 1254 to in-progress,” the bot should update the corresponding status cell back in the mother sheet. Time is tight; I’d like this running ASAP. Use whatever stack you’re comfortable with—Google Apps Script, Python, Node, or a WhatsApp Business API wrapper—so long as the flow remains reliable and easy for me to tweak later. Acceptance criteria 1. A working scheduler that scans the sheet without human intervention. 2. Correct routing to WhatsApp groups according to the project-type column. 3. Message formatting that is readable on both mobile and desktop. 4. Two-way sync: status updates triggered from WhatsApp reflect in the sheet within a minute. 5. Clear deployment instructions so I can extend or clone the bot for future projects.

Project ID: 40406249