Receives a WhatsApp message, looks up the sender's address in Google Sheets, and alerts the on-duty staff for that specific zone.
Verified 2026-07-07
Personal-Consumer
What it does
Receive instant WhatsApp alerts when someone contacts you, automatically matched to your zone using a lookup in Google Sheets so you know exactly who needs help immediately. This ensures the right staff member gets notified for every emergency without manual checking.
How it works
When it runs
Triggered by an event · Event · on WhatsApp message
How hands-off
Assists you, you do the final step
Setup
Quick setup · under an hour
Works with
WhatsApp, Google Sheets
Tools that fit
WhatsApp : Trigger and notification delivery
Google Sheets : User lookup and address retrieval
Watch out for
⚠ WhatsApp API phone number verification can take time so ensure you have a sandbox environment ready for initial testing before going live.
⚠ Google Sheets API quotas are strict so add caching or batch processing to avoid hitting rate limits during high-volume emergency events.
⚠ Phone number formatting must be consistent with E.164 standards otherwise the WhatsApp Business API will reject the notification request.
⚠ Sensitive user data is transmitted in this flow so encrypt all payloads in transit and restrict Google Sheets access via OAuth2 service accounts.
This is what I do. I design and build AI agents like this one, and keep them running. If you want it set up for your team instead of doing it yourself, get in touch.