Facebook leads to Google Sheets without CSV: 90-day limit
4 min read
Ibrohim Bultakovfounder
Start freeDownloading 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.
Why a CSV download isn't enough
Meta's Help Center says it outright: lead data can be downloaded for up to 90 days after the form was submitted. Older leads still count in Ads Manager results, but they no longer make it into the downloadable file.
The second problem with manual export is delay: a lead reaches the sheet only when someone downloads the file. With automatic writing it is in the sheet as soon as the form is submitted.
How it works in Yuboraman
In the Google Sheets integration, your Google account connects through Google's own window, and the spreadsheet is picked in Google's file picker — or a new one is made. Then:
- Each lead is appended as one new row at the end of the sheet — existing data is left alone
- You name each column and pick a form field or a fixed value for it; you set the column order yourself too
- You can add Source, Date and Status columns — they are filled in for every lead automatically
- Values are written as text: Google doesn't turn a phone number into a number, so neither a leading + nor a 0 is lost
- Renaming the tab doesn't stop the writing — the tab is found by its internal ID, not by its name
- If a write fails, the system tries again
- Leads from different forms can go to different spreadsheets or tabs
If you like, a Telegram message also arrives as soon as the lead lands in the sheet.
A new spreadsheet, an empty tab or a tab with data
When a new spreadsheet is made, a "Leads" tab is set up in it: a header row, formatting, a drop-down list for the status column and a summary tab.
When you pick an existing spreadsheet and the tab you named isn't in it, the tab is added. If the tab is empty, it also gets the header row and formatting.
If the tab already has data, it is left untouched: leads are appended in the column order you set. So keep the column order in Yuboraman the same as the header order on the tab — otherwise a phone number can end up in the Name column.
Google Sheets limits
According to Google Drive Help, one spreadsheet can hold up to 20 million cells or up to 100 MB. If many leads come in, move old rows to another spreadsheet from time to time.
Sheets API requests are limited too: per Google's documentation, up to 300 write requests per minute per project and up to 60 per minute per user. Above that, Google returns a 429 error and recommends waiting and retrying. Yuboraman does exactly that: when Google asks it to wait, the lead stays in the queue and is written later.
Access and sharing with your team
Yuboraman writes to the sheet on behalf of the Google account you connected. You can revoke this access at any time in your Google account settings — after that, leads stop reaching the sheet.
To open the sheet to colleagues, Google's usual way is enough: the Share button, your colleague's email and the Editor role. According to Google's help page, one file can be shared with up to 600 individual email addresses, and work or school accounts may restrict sharing outside the organization.
If one person submits the form twice, that is two separate leads — and two rows in the sheet.
