How to Connect Facebook Ads to Google Sheets

Last Modified: February 20, 2024 - 5 min read

Julian Alvarado
learn how to connect facebook ads to google sheets

Facebook Ads is a powerhouse in the digital advertising realm, enabling businesses to reach targeted audiences based on various demographics, interests, and behaviors.

Marketers worldwide use Facebook Ads to drive brand awareness, generate leads, and boost sales. However, while Facebook’s in-built Ads Manager provides many analytics, many marketers seek the versatility of Google Sheets to dive deeper into their ad data.

But manually copying data, downloading cumbersome CSV files, and then cleaning them for analysis is a tedious, error-prone process.

Fortunately, there are ways to automate the entire process and import Facebook Ads data directly into your spreadsheet.

Read on to learn how!

Two Ways to Connect Facebook Ads to Google Sheets

  1. Coefficient – Simple, out-of-the-box Google Sheets Data Connector
  2. Zapier – Complex setup and maintenance with limited integration

1. Coefficient

Coefficient is a free Google Sheets add-on that allows you to connect your favorite business solutions, like Facebook Ads, to Google Sheets and sync real-time data directly into your spreadsheet.

By pulling Facebook Ads data into Google Sheets, marketers can centralize their reporting, especially if they are using multiple advertising platforms. This allows for a consolidated view of all advertising efforts.

To install Coefficient, open a new spreadsheet and click ‘Extensions’ from the Google Sheets menu.

Choose Add-ons -> Get add-ons.

This will open up the Google Workspace Marketplace.

get the coefficient add-on

Search for “Coefficient” in the search bar and select the first app that appears in the search results.

select the first app that appears in the search results

Accept the prompts to install.

Accept the prompts to install

Once installation is finished, return to Extensions on the Google Sheets menu.

Coefficient will be available as an add-on.

Now launch the app. Coefficient will appear in the sidebar of your spreadsheet.

launch coefficeint from extension tab

Before importing data from Facebook Ads to Google Sheets for the first time, follow these steps to link your account with Coefficient.

Open the Coefficient Sidebar and click the menu icon in the top right corner.

click the menu icon in the top right corner

Select “Connected Sources.”

select connected sources from the menu

Click ‘Add Connection’ at the bottom and then ‘Connect’ to Facebook Ads.

select connect to link coefficient

Click the button to authorize the connection.

grant Coefficient access to your account

Log in to your Facebook account and click ‘Continue as…’ to grant Coefficient access to your account.

Log in to your Facebook account

Now you’re ready to create your first import!

Open Coefficient and click on the ‘Import from…’

select import from on the coefficient menu

Select ‘Facebook Ads’ from the list.

choose facebook ads as your data source

Click ‘Start from scratch.’

click start from scratch

Select your desired fields by searching in the Metrics, Breakdowns, Action Breakdown, and Action Attribution boxes.

Select your desired fields

You can customize your import by adding filters and/or row limits as needed.

Click ‘Refresh Preview’ to update your data based on your additions.

Click ‘Import’ at the top right corner to proceed.

customize your import by adding filters

Your data will automatically populate your spreadsheet.

Your data will automatically populate your spreadsheet

Prefer a visual guide? Watch the full tutorial video below.

2. Zapier

Zapier can send data from Facebook Lead Ads data to Google Sheets. You can configure automated workflows (Zaps) by setting up triggers and actions.

First, create a new spreadsheet. Clearly label your columns and freeze the header row.

 create a new spreadsheet


Next, you must authenticate your Facebook Lead Ads and Google Sheets accounts.

Open the Zap editor and set up Facebook  Lead Ads as your trigger. Click ‘Continue.’

choose facebook lead ads as your trigger


Coefficient Excel Google Sheets Connectors
314,000 Pros Sync Live Data from Their Business Systems into Spreadsheet

Stop exporting data manually. Sync data from your business systems into Google Sheets or Excel with Coefficient and set it on a refresh schedule.

You’ll be prompted to sign into your Facebook account. Click ‘Continue’ to grant permissions.

authenticate your Facebook Lead Ads and Google Sheets accounts


Now you can customize your trigger by selecting a Facebook page and form to use.

 customize your trigger by selecting a Facebook page


Next, you’ll configure the action for your Facebook Lead Ads trigger.

Choose Google Sheets as your app and ‘Create Spreadsheet Row’ as your action.

Select ‘Continue’ to proceed.

A screenshot of the action setup for a Zap showing Google Sheets as the app and Create Spreadsheet Row as the event.


You’ll be prompted to sign in to your Google Sheets account. Sign in and select the spreadsheet you want to use.

Your spreadsheet column names as individual fields.

Setting up the Google Sheets action in the Zap editor. A red arrow points to empty fields created from the column names in a Google Sheet.


Note: Remember to click the Refresh Fields button to update your options in this box if you make any changes to your Sheet.

Click inside your column fields to see the values from your Facebook Lead Ads trigger.  

You can type in text, which will appear the same each time your Zap runs. Or, you can select values from Facebook Lead Ads.

Setting up the action step in Zapier. A dropdown menu shows information from Facebook Lead Ads. An arrow points to the values, instructing the user to click to add to a field.


Select ‘Show all options’ to load all of the values from Facebook Lead Ads.

A fully mapped set of fields showing information from Facebook Lead Ads that will be sent to your spreadsheet. "Created Time" is below "Date," "Email" is below "Lead Email," and "Full Name" below "Lead Name.


Map your spreadsheet fields, and select ‘Continue.’

Now it’s time to test your Zap. This step will create a new spreadsheet row in Google Sheets.

If your test is successful, you should see the data from your Facebook Lead Ad as a new spreadsheet row, according to how you configured it in the previous step.

A screenshot of a Google Sheet showing information from Facebook Lead Ads brought into a spreadsheet.


All new leads from Facebook Lead Ads will populate your spreadsheet as a new row.


  • Setting up a Facebook Ads to Google Sheets integration does not require coding and is easy to set up.
  • Non-technical users can follow the step-by-step process to configure and test your automated workflows, making it useful for anyone.


  • Configuring automated workflows requires setting up the specific data you want to pull and track from Facebook Lead Ads to Google Sheets is time-consuming.
  • Zapier’s Google Sheets trigger can stop working if there are changes made to your spreadsheet while the Zap is turned on, such as deleting existing rows or columns, adding rows anywhere other than to the bottom of your sheet, resorting the sheet, renaming/adding/rearranging columns, renaming the sheet, or filtering the sheet.
  • Errors such as ‘range’ errors, missing fields in the Zap editor, and unexpected Zap triggers can occur, requiring troubleshooting and potentially disrupting your workflow.

Unleash the Power of Live Facebook Ads Data in Google Sheets

Coefficient’s Facebook Ad connector for Google Sheets eliminates these issues by allowing marketers to automatically import Facebook Ad data directly into Google Sheets in a few simple clicks.

Get started with Coefficient for free to connect your Facebook Ad data today!

Connect Facebooks Ads to Google Sheets Instantly

Automatically sync Facebooks Ads with Google Sheets using Coefficient’s one-click connector.

Try the Spreadsheet Automation Tool Over 350,000 Professionals are Raving About

Tired of spending endless hours manually pushing and pulling data into Google Sheets? Say goodbye to repetitive tasks and hello to efficiency with Coefficient, the leading spreadsheet automation tool trusted by over 350,000 professionals worldwide.

Sync data from your CRM, database, ads platforms, and more into Google Sheets in just a few clicks. Set it on a refresh schedule. And, use AI to write formulas and SQL, or build charts and pivots.

Julian Alvarado Content Marketing
Julian is a dynamic B2B marketer with 8+ years of experience creating full-funnel marketing journeys, leveraging an analytical background in biological sciences to examine customer needs.
350,000+ happy users
Wait, there's more!
Connect any system to Google Sheets in just seconds.
Get Started Free

Trusted By Over 20,000 Companies