How to Send WhatsApp Messages for New Rows in Google Sheets with WOZTELL & Make
This tutorial explains how to automatically trigger WhatsApp template messages every time a new row is added to Google Sheets.
It's ideal for automating notifications, confirmations, or personalized outreach directly from your spreadsheet.
Overview
Your automation flow has two modules:
1. Google Sheets – Watch New Rows: Detects when a new row is added.
2. WOZTELL | Unleash WhatsApp – Send WhatsApp Template Message: Sends a WhatsApp template message to the number specified in the new row.
Visual flow:
Step 1: Watch New Rows in Google Sheets
1. In Make, add the module: Google Sheets – Watch New Rows.
2. Connect your Google account.
3. Select the spreadsheet and worksheet you want to monitor.
4. This module will trigger every time a new row is added.
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 for sending messages.
4. Prepare and approve your WhatsApp message template in WOZTELL.
5. Map the phone number and any template variables (e.g., name, message content) from the new row to the relevant fields in the template.
Best Practices
- Design your Google Sheet so each row contains all necessary info (phone number, name, message content, etc.).
- Prepare your WhatsApp template message in advance, with variables that match your sheet columns.
- Test the scenario by adding a test row and checking message delivery.
- Use Make’s logs for troubleshooting and monitoring.
Result
Once activated, every new row added to your Google Sheet will automatically trigger a WhatsApp template message to the designated recipient—streamlining outreach, notifications, or support.
Next Steps
- Expand your flow with filters, custom formatting, or additional actions (e.g., logging sent messages).
- Use conditional logic to send different templates based on row content.