META LEAD ADS TO GOOGLE SHEETS
Meta Lead Ads to Google Sheets, then WhatsApp.
How to add a Google Sheets row for each new Meta Lead Ads record, so ConvoHut can start a WhatsApp journey from it. This takes Zapier, Make or a webhook.
7-day free trial · about 15 minutes to connect your number · Meta bills message charges to you directly (you add a card in Meta)
Illustrative example. Names and details are made up.
ADS
The options.
Trigger, then Google Sheets “Create Spreadsheet Row”
Triggers you can use:
- New Lead (Facebook Lead Ads)
Facebook Lead Ads is a premium app on Zapier.
Make, webhooks and more
- Make
- Download leads as CSV from Meta and paste them in (manual)
- Zapier needs Page and ad account access with lead permissions.
- Consider Click-to-WhatsApp ads too: messages are free for up to 7 days when someone starts a chat from the ad and you reply within 24 hours.
THE SHEET
The columns to send.
Send one row per record, with the column names in row 1. Phone is the only required column and must include the country code.
- Name
- Phone
- Campaign
- Consent
- Consent: that the person agreed to WhatsApp messages
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Name | Phone | Campaign | Consent |
| 2 | Sarah | +61 412 000 184 | Spring open day | Yes |
| 3 | Tom | +61 433 000 912 | Spring open day | Yes |
| 4 | Ana | +64 21 000 457 | Winter sale | Yes |
Row 1 holds the column names. The highlighted row is the newest: adding it starts the journey. Example data only.
BUILD
Then, in ConvoHut.
- 01
Open Automations, then Create Automation, and choose New Sheet Row as the trigger.
- 02
Pick the spreadsheet and tab, and map Phone and Name.
- 03
Add your approved template, a wait for reply, and a notify step.
- 04
Pass the compliance review for your markets, then Activate Now. Test with your own number first.
RECIPES
Recipes that work with Meta Lead Ads.
Checked against Meta Lead Ads’s, Zapier’s and Google’s documentation in September 2026. Features, plan requirements and trigger names change; check the current documentation when you set it up. ConvoHut isn’t affiliated with Meta Lead Ads.
LIVE NOW · 7-DAY FREE TRIAL
More sales from every conversation.
WhatsApp marketing, sales and support from your own number. 7-day free trial, free onboarding and Meta verification help.
- Meta Tech Provider
- Hosted on AWS
- Australian company
- Your number stays yours
