We don't use a CRM. Can Meta's built-in Google Sheets connection deliver our lead ad leads and tell Meta which ones qualified?

TofuAnswer by the Tofu team · checked

A small stack of blank white cards lying on a grey and white marble counter

Yes. Meta's built-in Google Sheets connection puts new Instant Form leads in a sheet and adds a lead_status column. When you set a lead to Intake, Qualified, Converted, Lost or Not qualified, Meta pulls the change and turns it into a Conversions API for CRM event, so it learns which leads were good. Set it up in Meta Business Suite under All tools > Instant forms > Connect CRM, where you also pick a dataset. You don't need Zapier or another tool, but someone has to keep the column current.

Ask Tofu next

Pick a question and Tofu Ads Agent answers it in chat.

As of November 2026.

How do I connect Instant Forms to Google Sheets?

Meta gives two routes in its help article.

From Meta Business Suite (the route that sends lead quality back):

  1. Go to All tools, then Instant forms, and click + Connect CRM.
  2. If Google Sheets isn't connected yet, select it under Select a CRM system and sign in with Google.
  3. Click New integration. If Google Sheets was already connected, click + Connect next to the instant form instead.
  4. Choose a spreadsheet: browse, create a new one, use a recent one or paste its link.
  5. If you want, turn on automatic integrations for future forms and sync existing leads to the sheet.
  6. Select the worksheet and the lead form, check the preview and click Connect.
  7. Select your business portfolio ID and dataset ID, then test the connection.
  8. Send a test lead, check that it lands in the sheet, and click Complete.

From Ads Manager, while creating or editing a lead ad: under Automated lead delivery, click Set up next to Google Sheets, sign in with Google, choose or create a spreadsheet (Meta says it has to be empty), select the worksheet and form, then click Connect and Done.

Which route tells Meta which leads qualified?

The Business Suite route, as Meta describes it. Its steps have you pick a dataset and test the connection, and the dataset is where the status events go. The Ads Manager steps in the same article hand you over to Business Suite's lead forms page but only connect a sheet to a form, with no dataset step, and Meta doesn't say whether that route also sends statuses.

If you set it up from Ads Manager, change a test lead's status and check whether your dataset in Events Manager receives an event. If nothing arrives, connect the form again from Business Suite.

How should a B2B team use the lead_status values?

Meta lists five values: Intake, Qualified, Converted, Lost and Not qualified. Each time you change one, Meta creates Conversions API events "based on the updated status." So agree on what each value means for your funnel before anyone starts editing. For example:

lead_statusWhat it could mean for a B2B team
IntakeEvery new lead, before anyone has looked at it
QualifiedMeets your bar for a sales conversation (your MQL or SQL point)
ConvertedBecame an opportunity or a customer (pick one and stick to it)
LostWas a fit but went cold or chose someone else
Not qualifiedWrong company size, student, competitor or spam

Leave the Lead ID column alone. Meta says it fills in automatically for each new lead, and Meta's developer guide recommends sending the Lead ID with each event so it can match statuses to leads. Meta's article doesn't say whether you can rename or move columns, so add your own notes columns but keep lead_status and Lead ID as they are.

Does this let Meta optimize for qualified leads?

It feeds the same Conversions API for CRM integration that HubSpot and Salesforce users set up, so the same rules apply. Meta's article points you to the integration's eligibility requirements, and Meta's developer FAQ asks for data uploads at least once a day.

With a sheet, Meta gets new data when someone changes a status, so if nobody edits the sheet, nothing goes back. Make updating the sheet a daily habit for whoever follows up on leads. The requirements, the funnel setup in Events Manager and how long Meta takes to learn are all in how to send CRM lead stages back to Meta.

Can I mark leads in Leads Center instead of a sheet?

Meta doesn't say clearly. Leads Center has the same default stages (Intake, Qualified, Converted, Lost and Not qualified), and Meta's Conversions API for CRM help page says "If you're using Leads Center, remember that leads generated from instant forms will be automatically sent, so there is no setup required." But neither that page nor Meta's Leads Center article says that moving a lead to another stage there sends an event to a dataset or counts toward optimizing for quality leads. The Google Sheets and Excel articles, by contrast, say each status change creates Conversions API events.

Can I use Excel instead?

Yes. Meta has a matching integration for Microsoft Excel, set up from the same Instant forms area, with the same five lead_status values and an automatic Lead ID column.

Why did my leads stop arriving in Google Sheets?

Meta's article has no troubleshooting section, so work through these:

  1. Check the connection. In Business Suite, open the lead forms page (Instant forms), then the CRM setup tab and its CRM integration tab. Meta's disconnect steps use the three-dot menu there and a Connected toggle, so check that the toggle is still on. If it's off, reconnect and send a test lead. Meta says an error at the test step means you can't select those IDs or the test connection failed.
  2. Check leads access. If someone with full control of your business portfolio has customized leads access, Meta says new people, CRM systems or partners "need to be added manually."
  3. Check the sheet. Make sure it still exists and that the Google account used to connect it can still open it.
  4. Recover what's missing. Download leads as a CSV from Ads Manager, from Instant forms in Business Suite, or from Leads Center. Meta keeps leads available to download "for up to 90 days" after someone submits the form.

If Leads Center itself looks short, see why Meta Leads Center is missing leads. If your ads stopped getting leads at all, see why Meta lead ads suddenly stopped getting leads. If you later move to a webhook or Zapier setup, Meta's Lead Ads Testing Tool guide helps you test delivery, and how to send Meta leads to HubSpot or Salesforce covers moving to a CRM.

Sources (9)

Related resources