How to Add a New Row to Google Sheets from WhatsApp Messages with WOZTELL & Make
How to Add a New Row to Google Sheets from WhatsApp Messages with WOZTELL & Make
This tutorial shows you how to automatically add a row to a Google Sheets spreadsheet every time a new message is received on WhatsApp via WOZTELL.
It’s perfect for logging support requests, collecting feedback, or tracking incoming communications.
Overview
Your automation flow contains two modules:
1. WOZTELL | Unleash WhatsApp – Watch New WhatsApp Message: Detect new WhatsApp messages.
2. Google Sheets – Add a Row: Insert a row into your spreadsheet with message data.
Visual flow:
Step 1: Watch New WhatsApp Message (WOZTELL)
1. In Make, add the module: WOZTELL | Unleash WhatsApp – Watch New WhatsApp Message.
2. Connect your WOZTELL account.
3. Choose the WhatsApp inbox/channel to monitor.
4. This module triggers for every new incoming message.
Step 2: Add a Row in Google Sheets
1. Add the module: Google Sheets – Add a Row.
2. Connect your Google account.
3. Select the Google Sheets file and worksheet where you want to store the data.
4. Map the parameters from the WhatsApp message (such as sender’s phone number, sender’s WhatsApp name, message date/time, and the message content) to the columns in your sheet.
Recommended columns:
- Phone Number
- WhatsApp Name
- Date & Time
- Message Content
Best Practices
- Prepare your Google Sheet in advance with headers matching your mapped fields.
- Test the scenario by sending a WhatsApp message and checking that a new row is created.
- Use Make’s logs to troubleshoot any mapping or connection issues.
Result
Once activated, this workflow will automatically log each WhatsApp message in your Google Sheets, providing you with a centralized, searchable record of all incoming communications.
Next Steps
Looking to automate further?
Consider adding filters, notifications, or follow-up actions in Make to streamline your support and CRM processes!