Add New Row to Google Spreadsheets for Every New Lead from Facebook Lead Ads
Every new lead from your Facebook Lead Ads forms is written to a new row in Google Sheets, giving you a live lead list you can sort, share and work through without downloading files.
Facebook Lead Ads
Google Sheets2 steps 22 downloads Setup ~5 min Used on 2.7k sites Free to import
What this workflow does
Facebook keeps your ad leads in its own tools, and downloading them is easy to forget. A shared spreadsheet is often the simplest place for a small team to call leads back. This workflow writes each lead to Google Sheets as soon as it comes in.
When someone submits your lead form, the Facebook Lead Ads trigger receives their answers. FlowMattic then runs the Google Sheets Add New Row action on the spreadsheet you keep for leads. Each column takes the lead answer you map to it, such as name, email, phone or a custom question.
One lead equals one row, added below the existing ones, so the sheet becomes a running log of every lead from the time you switch the workflow on. You can add your own columns for status or notes and fill them in by hand. Task History lists each run if you need to check whether a lead came through.
Call-back list for a sales team
Reps open the shared sheet each morning, call the newest leads and write the outcome in a Status column next to each row.
Reporting on ad results
A marketer counts rows per week or per form answer in the sheet to compare campaigns, using data that arrives without manual exports.
Sharing leads with a client
An agency running ads for a client shares the spreadsheet with them, so the client sees each lead without needing access to the ad account.
How this workflow runs
What happens at each step once the workflow is on, and what you need before you import it.
Facebook Lead Ads New LeadRuns when a new lead is submitted through your Facebook Lead Ads form. Connect the Facebook account that manages your page, and every answer in the form becomes available to map.
- Google Sheets Add New Row
Adds a row to your Google Sheets spreadsheet. Connect your Google account, map lead answers such as name, email or phone into the row, and send a test lead to check each value lands in the right column.
What you need
- FlowMatticCore
- Facebook Lead Ads AccountAccount
- Google Sheets AccountAccount
After importing, map your own data. To keep the template universal, not every step is pre-filled. Open each step in the builder and connect your accounts and fields (channels, lists, sheets, recipients) before you switch the workflow on.
Make it yours
Changes worth making after you import it.
- Give your sheet a header row before you set up the step, so you can see which lead answer belongs in each column while mapping.
- Add a FluentCRM or email marketing step after Google Sheets if you also want the lead in your mailing list, with the sheet kept as a backup.
- Use a Router to send leads from different form answers to separate sheets, for example one sheet per location your business serves.
Questions about this workflow
Will leads I already have in Facebook be added?
No. Only leads that arrive after you turn the workflow on are written to the sheet. Download older leads from Facebook if you need them in the same spreadsheet.
Can I map custom questions from my lead form?
Yes. Answers to the questions in your form come through the trigger, and you can map each one to its own column.
A lead filled in my form twice. Do I get one row or two?
You get two rows. The step always adds a new row and does not look for an existing one.
What do I need to set this up?
A Facebook account with access to the page running your lead ads, a Google account, and a spreadsheet with a header row for the lead fields.
More Data Sync & Backup workflows
Other ready-to-import templates from the same category.
Import this workflow into your WordPress site
Download the JSON, import it from the Workflows screen and connect your accounts. Every run stays on your server, with no per-task fees.
30-day money-back guarantee Unlimited workflows and runs Self-hosted