Project Description
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.