How to Send WhatsApp Template Messages Based on Filtered Google Sheets Rows with WOZTELL & Make
How to Send WhatsApp Template Messages Based on Filtered Google Sheets Rows with WOZTELL & Make
This tutorial shows how to automatically send WhatsApp template messages for filtered rows in a Google Sheet.
Ideal for targeted campaigns, reminders, or notifications based on specific criteria in your spreadsheet.
Overview
Your scenario uses two modules:
1. Google Sheets – Search Rows: Finds rows matching your filter criteria in the sheet.
2. WOZTELL | Unleash WhatsApp – Send WhatsApp Template Message: Sends WhatsApp template messages to the numbers found in those rows.
Visual flow:
Step 1: Search Filtered Rows in Google Sheets
1. In Make, add the module: Google Sheets – Search Rows.
2. Connect your Google account.
3. Select the spreadsheet and worksheet.
4. Set up filter/query criteria to select only the rows you want (e.g., status = “To Contact”, score > 80, etc.).
5. The module will return only rows matching your filters.
Step 2: Send WhatsApp Template Message (WOZTELL)
1. Add the module: WOZTELL | Unleash WhatsApp – Send WhatsApp Template Message.
2. Connect your WOZTELL account.
3. Select the WhatsApp channel and prepare an approved template message.
4. Map the phone number and relevant fields from each filtered row into the template variables.
5. Each matching row triggers a WhatsApp message to the specified recipient.
Best Practices
- Structure your Google Sheet with clear columns for phone number, criteria, and message variables.
- Test your filter to ensure only desired rows are selected.
- Ensure your WhatsApp template is approved and matches the variables in your sheet.
- Monitor scenario runs and logs for successful sends and troubleshooting.
Result
Once activated, you can run targeted WhatsApp campaigns or notifications based on filtered data in your Google Sheet, with messages sent only to the relevant contacts.
Next Steps
- Add branching logic for different templates based on row content.
- Log sent messages or update row status to prevent duplicates.