How to Send WhatsApp Messages for New Leads from Facebook Lead Ads and Log Them in Google Sheets with WOZTELL & Make
How to Send WhatsApp Messages for New Leads from Facebook Lead Ads and Log Them in Google Sheets with WOZTELL & Make
This tutorial explains how to automate follow-up for new Facebook leads by sending personalized WhatsApp template messages and logging the lead information in Google Sheets.
Perfect for sales and marketing teams wanting to boost responsiveness and keep track of new leads.
Overview
Your scenario consists of three modules:
1. Facebook Lead Ads – New Lead: Detects new leads submitted via Facebook ads.
2. Google Sheets – Add a Row: Logs each lead’s information into a spreadsheet.
3. WOZTELL | Unleash WhatsApp – Send WhatsApp Template Message: Sends a WhatsApp template message to the new lead.
Visual flow:
Step 1: Detect New Leads (Facebook Lead Ads)
1. In Make, add the module: Facebook Lead Ads – New Lead.
2. Connect and authorize your Facebook account.
3. Select the Facebook page and lead form to monitor.
4. This module triggers every time a new lead is submitted.
Step 2: Log Lead Info in Google Sheets
1. Add the module: Google Sheets – Add a Row.
2. Connect your Google account.
3. Select the spreadsheet and worksheet for lead logging.
4. Map fields from the Facebook lead (name, phone number, email, timestamp, etc.) into sheet columns.
Step 3: 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 pre-approved message template.
4. Map the lead’s phone number and personalize the template variables (e.g., first name, offer) using Facebook lead data.
5. Each new lead receives an instant WhatsApp message.
Best Practices
- Design your Google Sheet with columns matching your lead fields and message variables.
- Prepare your WhatsApp template in WOZTELL, and ensure it’s approved before going live.
- Test the flow with a test Facebook lead to ensure data is mapped and messages are delivered.
- Use Make’s logs for troubleshooting and monitoring.
Result
Once activated, every new lead from Facebook Lead Ads will be:
- Logged automatically in Google Sheets
- Sent a personalized WhatsApp message via WOZTELL
This ensures fast follow-up and a complete record of your leads in one place.
Next Steps
- Add conditional logic for different message templates based on lead source or data.
- Sync your sheet with a CRM for deeper automation.