Write Facebook leads to Google Sheets automatically
Every lead lands in your spreadsheet as a new row. No CSV downloads from Facebook, no matching up columns and no copying by hand.
How to send leads to Google Sheets
Connect Facebook under “Connections”
“Connect profile” → Facebook. The browser goes to Facebook, where you choose which Pages to give access to — Yuboraman never sees your password. Back in the dashboard, the account shows up under “Lead sources”.
Click “New integration” and pick the source
In the Integrations section click “New integration”. Under “Where does the lead come from?” tick Facebook / Instagram and pick what you need from the Page and Form lists — with a single Facebook account it is selected for you. If the lead comes from your own site — you pick “Your own site” and the system hands you a webhook address.
Set the form name and the Telegram message
In basic settings give the form a name. If you want a Telegram message as well as the row in the spreadsheet, leave “Send to Telegram” on — switch it off and the lead goes only to the spreadsheet.
Pick Google Sheets as the target site
Pick Google Sheets from the “Where to send leads?” list and connect your Google account. The access covers only the spreadsheet you point to.
Set the spreadsheet, the sheet and the columns, then save
Choose an existing spreadsheet or open a new one, give the sheet a name and set which column takes which lead field. In a new spreadsheet or an empty sheet the system writes the column headers itself; a sheet that already holds data keeps its headers.
Video tutorial
Lesson 4
Sending Facebook form leads to Google Sheets
Connect Google Sheets, map the form fields to the sheet's columns and check that leads land in it, with tips on keeping the leads in the sheet in order.
Duration:
By Bahodirjon Siddiqov, ads specialist
The video is in Uzbek.
What you get
It appends to your existing sheet
Nothing in your spreadsheet is erased — leads are appended as new rows at the end.
Headers are written for you
A new spreadsheet or an empty sheet gets its column headers and the lead status list automatically. The column order is up to you.
Several spreadsheets
Leads from different forms can be routed to different spreadsheets or to different sheets.
Reports land here too
The daily Facebook Ads report can go to Google Sheets as well — spend, lead count, CTR and cost per lead.
Frequently asked questions
Can it write into my existing spreadsheet?
Yes. You pick an existing spreadsheet and sheet, and leads are appended at the end. Your old data is left alone.
Can I set the columns myself?
Yes. You set which column every lead field lands in. A sheet that already holds data keeps its headers, so match your column order to them.
What access is granted to my Google account?
Access is granted through the Google dialog itself and is used only to write to the spreadsheet. You can revoke it at any time in your Google account settings.
Can a lead be written twice?
If a write fails the system retries. Each attempt writes the lead as one whole row — no half-written rows. If the same person fills the form twice — those are two separate leads, and both rows land in the sheet.
Other destinations
Related guides
Facebook leads to Google Sheets without CSV: 90-day limit
Downloading leads as CSV and pasting them into a sheet by hand is a job that repeats every day. Set it up once, and every lead lands in the sheet as a new row on its own.
Daily Facebook Ads report in Telegram
Opening Ads Manager every day and copying out the same five numbers is repeat work. It can be set up once and then forgotten.
Send one Facebook lead to several places at once
Telegram for the salesperson, a sheet for the manager, the CRM for the department — one lead can go to all three, and you decide which lead goes where.
Let your leads land in Google Sheets
No code needed: sign up, connect your Facebook Page and switch on your first integration.
