GOOGLE ADS LEAD FORMS TO GOOGLE SHEETS

Google Ads lead forms to Google Sheets, then WhatsApp.

How to add a Google Sheets row for each new Google Ads lead forms 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)

Real estate agent welcoming buyers at an open home
Meta lead ad · New lead

Illustrative example. Names and details are made up.

ADS

The options.

Recommended · Zapier

Trigger, then Google Sheets “Create Spreadsheet Row”

Triggers you can use:

  • New Lead Form Entry (polling)
Other ways

Make, webhooks and more

  • Lead form webhook (URL and key) to a Google Apps Script web app
  • Manual CSV download from Assets → Lead form assets
Watch out for
  • Google Ads keeps leads for 60 days. Download or send them somewhere before then.

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: that the person agreed to WhatsApp messages
Google Ads lead forms → Sheet1
ABC
1NamePhoneCampaign
2Sarah+61 412 000 184Spring open day
3Tom+61 433 000 912Spring open day
4Ana+64 21 000 457Winter sale

Row 1 holds the column names. The highlighted row is the newest: adding it starts the journey. Example data only.

BUILD

Then, in ConvoHut.

  1. 01

    Open Automations, then Create Automation, and choose New Sheet Row as the trigger.

  2. 02

    Pick the spreadsheet and tab, and map Phone and Name.

  3. 03

    Add your approved template, a wait for reply, and a notify step.

  4. 04

    Pass the compliance review for your markets, then Activate Now. Test with your own number first.

Checked against Google Ads lead forms’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 Google Ads lead forms.

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
Salon owner checking bookings on her phone