AI automation

Facebook Lead Ads to Google Sheets: A Step-by-Step Build With the Checks People Skip

By Sauravjit Singh · Updated 2026-11-03 · 6 min read

Short answer: To send Facebook lead ads to Google Sheets, connect your Facebook Page's lead form to a sheet through an automation tool such as Zapier, Make or Pabbly Connect. Grant the tool lead access in Meta Business Settings, map form fields to sheet columns, test with Meta's Lead Ads Testing Tool, then add an email or WhatsApp alert.

The basic connection takes about 20 minutes. What takes longer is fixing what breaks a week later: leads missing because of a permission, the same person appearing three times, timestamps five and a half hours off, and nobody noticing that a lead waited six hours for a call.

This guide covers the build and those checks, plus a look at when you don't need an automation at all.

Do you even need an automation for Meta leads?

Not always. If you get a handful of leads a day and one person replies to all of them, Meta's own tools may be enough.

Meta Business Suite has a built-in leads area where you can see new leads, change their stage and download them as a file. Meta also sends lead notifications to the Page's admins. For a home baker or a single tutor, that is often fine. Meta has historically kept downloadable lead data for a limited period, so don't treat Ads Manager as your permanent record; check the current Help Centre for the exact retention window.

  • Stay with Meta's tools if: fewer than about 5–10 leads a day, one person handles them, and you download a backup weekly.
  • Automate if: more than one person follows up, you need a WhatsApp or email alert within a minute, you want to track who called whom, or leads come from several forms and Pages.

What you need before you start

  • Admin access to the Facebook Page that runs the lead ads, and to the Business portfolio in Meta Business Settings.
  • An account on your automation tool. Zapier, Make and Pabbly Connect all have a ready Facebook Lead Ads connection. Our comparison of Zapier and Make helps if you haven't picked one.
  • At least one published lead form (an ad can be paused; the form must exist).
  • A Google Sheet with headers in row 1: Lead ID, Created (IST), Name, Phone, Email, City, Form, Ad, Status, First contacted, Lead age (mins).
  • The sheet's time zone set to India: in Google Sheets, go to File, then Settings, and pick (GMT+05:30) India Standard Time. Skip this and every time formula later is wrong.

How to send Facebook lead ads to Google Sheets, step by step

The menu names below are generic because each tool labels them slightly differently, but the order is the same everywhere.

  1. Create a new workflow and choose Facebook Lead Ads as the trigger, with the event 'New lead'.
  2. Connect your Facebook account. When Meta asks which Pages to allow, tick the Page that runs your ads. Leaving it unticked is one of the most common reasons a trigger finds no forms.
  3. Pick the Page and the specific form. If you run several forms, either build one workflow per form or choose the option for all forms on the Page and map the form name into its own column.
  4. Send a test lead with Meta's Lead Ads Testing Tool (found in Meta's developer tools; search 'Lead Ads Testing Tool'). Use a real-looking name such as Test Priya so you can find and delete it later.
  5. Pull the test lead into your tool. You should see the lead ID, created time and every answer from your form.
  6. Add the action: Google Sheets, 'Create spreadsheet row'. Choose the sheet and tab, then map each column. Map the lead ID too; you'll need it for duplicates.
  7. Leave Status blank or set it to 'New'. Your team updates it by hand.
  8. Test the action and check the row in the sheet. Compare the created time with your phone's clock.
  9. Add the notification step (next section), test again, then switch the workflow on.
  10. Submit one more test lead from a phone and time how long it takes to reach the sheet.

The checks people skip (and how to do them)

These four checks are where most lead automations we've reviewed in agency work go wrong.

  • Lead access permission. In Meta Business Settings, look for Integrations and then Leads Access. Make sure your automation app (or the person who connected it) has access to the Page. If someone later changes Page roles, leads can stop flowing without an error in your sheet.
  • Duplicate leads. The same person can submit twice, or a retry can create a second row. Before the 'create row' step, add a 'find row' step that searches the Lead ID column; only create a row if nothing is found. Duplicate phone numbers from genuine resubmissions are worth keeping but flagging.
  • IST timestamps. Meta's created time typically arrives in UTC in a format like 2026-11-14T10:32:05+0000. Either use your tool's date formatter with Asia/Kolkata as the time zone, or convert in the sheet. If the raw text is in column L, this formula gives IST: =DATEVALUE(LEFT(L2,10))+TIMEVALUE(MID(L2,12,8))+TIME(5,30,0). Format the cell as date and time.
  • Lead age. Speed-to-lead often matters as much as the ad itself. In the Lead age column, use =IF(B2="","",ROUND((IF(J2="",NOW(),J2)-B2)*1440,0)) where B is Created (IST) and J is First contacted. It shows minutes waiting until someone fills in the contact time. Add conditional formatting so anything over 30 minutes turns red.

One more habit: delete your test leads from the sheet once you're done, or mark them clearly, so they don't inflate your lead counts in reports.

Can you send Facebook leads to WhatsApp and email automatically?

Yes. The easy part is alerting your own team; messaging the lead on WhatsApp needs the official WhatsApp Business Platform and approved message templates.

For team alerts, add a Gmail 'Send email' step after the sheet row, with the lead's name, phone, form and a link to the sheet. Many teams prefer a WhatsApp alert, which usually means a WhatsApp Business Platform provider sending a template to the sales person's number, or a notification app the team already watches.

An email auto-reply to the lead is simple: a short, plain message from a real address saying who you are and when to expect a call. Keep prices out of it.

Messaging the lead directly on WhatsApp is where people get stuck: you need a verified business number on the WhatsApp Business Platform, a template approved by Meta, and you pay per message. Our guide to automating WhatsApp messages to new leads covers providers, templates and rough costs.

Why speed-to-lead is worth the setup: a quick ₹ example

Say you run a dental clinic in Janakpuri and spend ₹15,000 a month on lead ads. If your cost per lead falls somewhere around ₹150–₹300 (it varies a lot by city, offer and season), that is roughly 50–100 leads.

If a third of those are called the next day instead of within the hour, and many of those people have already booked elsewhere, you may be wasting ₹5,000 of spend a month without seeing it in Ads Manager. A lead-age column makes that leak visible. It's an illustration, not a benchmark; run your own numbers.

Clinics also have extra rules: medical advertising and patient-data handling are regulated in India. Check the current official guidance or ask a professional before you write ad copy or auto-replies for a healthcare business.

Taking it further

Once leads land cleanly, you can add an AI step that tags each lead by product interest from a free-text answer, or writes a one-line summary for the sales person. Add it only after the plain version has run reliably for a week.

If you sell B2B and also get buyer enquiries from IndiaMART, the same sheet can hold both sources; see how to automate IndiaMART leads for the differences. For the bigger picture of what else to automate and what to leave alone, start with our guide to AI automation without coding.

This exact lead-to-sheet-to-alert build is one of the hands-on exercises in our no-code AI course for professionals.

Frequently asked questions

Why are my Facebook leads not showing in Google Sheets?

The usual causes are a Page not ticked when you connected Facebook, missing Leads Access permission in Business Settings, or the workflow being switched off. Send a test lead with the Lead Ads Testing Tool and check your tool's run history to see where it stopped.

Is there a free way to send Meta leads to Google Sheets?

Yes. Most automation tools have free plans that handle a small number of leads a month, and you can also download leads manually from Meta Business Suite. Free plans often check for new data less frequently, so alerts can be slower.

Why is the lead time in my sheet wrong?

Meta usually sends lead times in UTC, which is five and a half hours behind IST. Convert with your tool's date formatter set to Asia/Kolkata, or add 5:30 hours with a sheet formula, and set the spreadsheet's time zone to India.

Can I send an automatic WhatsApp message to every Facebook lead?

You can, but it requires the official WhatsApp Business Platform, a verified number and a Meta-approved template, and each message is charged. A personal WhatsApp number or unofficial tools risk getting the number restricted.

How fast should I contact a Facebook lead?

As fast as you reasonably can, ideally within the hour during business hours. People who fill a lead form are often comparing options, so a lead-age column helps you see how long leads actually wait.

Want to learn this with a trainer?

Leave your details and our counsellor will call you within one working day with batch dates, fees and the right course for you.

  • Free counselling call, no obligation to join
  • Weekday and weekend batches, online or offline
  • Small batches of 15 to 20 students

Or chat on WhatsApp

Enter a 10-digit mobile number.

We use your details only to contact you about Spettro School courses.

Chat on WhatsApp