I keep contact numbers and message text in a Google Sheets file and need those rows to trigger a WhatsApp text automatically once a specific condition is met (for example, when a “Send?” column is set to YES). No images, links, or attachments—just plain text from my personal WhatsApp account. A lightweight Google Apps Script-based solution is fine, but I’m open to any method that lets me dispatch messages from my own number—whether that’s using WhatsApp Web automation, or any other thing Routine sending has to be hands-off; after I flag a row, the script should fire, send the message, and ideally update the sheet with “Sent” and a timestamp. Deliverables • Fully functioning script or automation bound to the existing Google Sheet • Clear setup guide so I can reconnect it if tokens expire or templates change • Simple way for me to tweak message text and trigger conditions later (inline comments are fine) • Short hand-off session or notes covering deployment and basic troubleshooting Message volume is small, so reliability and ease of maintenance matter most. Once I see a row flip from “Send” to “Sent” automatically, the job is complete. or change of text in trigger column sends the message