What This Article Covers
- Sync your Facebook and Instagram ads data to Airtable with no code
- Sync Facebook page and post insights to Airtable
- Sync that daily or hourly
- We’ll use the Syncwith Extension for Airtable (used by 100,000s of people across Google Sheets, Excel, Data Studio and more)
- Contact our support for fast help if you run into any issues
Follow along to get your Facebook ads data into Google Sheets:
Connecting to the Facebook API to Airtable
In this reference we’ll look at how to setup a Facebook Airtable integration for
- Facebook ads and Instagram ads to Airtable
- Facebook pages and post insights to Airtable
Don’t Have SyncWith?
- SyncWith is a Google Sheets Add On
- SyncWith allows you to move data from any API into Google Sheets
- Learn more about why Marketers love SyncWith
- ⭐️⭐️⭐️⭐️⭐️ Reviewed by hundreds of businesses
- Check out our Airtable API Extension in the Airtable marketplace to install today, and see why 100,000s of users are using us to setup their data connections easily.
How Does SyncWith Work on Airtable?

Connecting Facebook Ads to Airtable
Connecting to a specific Facebook API to import to Airtable
Facebook has many APIs, and there are many marketing APIs available in SyncWith, so we must pick a specific API to connect to
- Open the
SyncWith extension
- Click
New report
or one of the default services, egFacebook Ads

- A new tab will open in your browser to configure your connector
- If you choose
Facebook Ads
you’ll come immediately to the configuration screen
- If you clicked
New report
you’ll come to a screen listing many api services as well as the ability to search

Connecting the Facebook Ads API to Airtable
You’ll see a configuration screen like the following:

Choose a Reporting Time Frame
You can choose from a wide range of default reporting time frames as well as dynamic ones. Some marketers and agencies might report on the last 21 weeks of data. You may or may not want to see the current day in the reporting period.
All are possible with the date range picker. Popular options include:
Last 30 days
Last 90 days
Last Month
,Last 3 Months
Month to Date
You may create multiple connections with different date ranges, for instance if you’re building a dashboard you might want to know your total ad spend in the last month, 3 months and year. You can create 3 queries to pull each of these numbers.

Choosing Your Dimensions
Dimensions are important if you want to pivot your data to see how different groups of users perform, for example:
- I want to see how my ad sets perform across gender, age and country so I can prune poorly performing ones
- I want to differentiate between the performance of different ad types in my campaigns
- I want to understand which countries have the best engagement in my videos
- I want to group my daily ad spend by

Choosing Your Metrics
Now that you’ve selected the dimensions you want to report along - eg the things you’re interested in. Now you need to choose what you want to know about them. Eg you want to break things down by country, and now you need to know what you want to know about each Country. It’s important to note that some metrics are computed like CTR, CPM and Frequency are computed which means you won’t be able to roll them up directly - but you can if you compute them in a roll up. Eg if you have a data table with CTR by country you can’t just average all the CTRs to get your average CTR you need to sum all the link clicks and sum all the impressions and then calculate the average CTR.

Creating a Table
- Click the
Save
button

- SyncWith will begin creating the connection, creating a new table in the base and importing the requested data, you see the
Save
button grey out and change toSaving

- Once complete the configuration tab will close and your Airtable will be updated

- The extension will also add the new report to a list of existing reports, each report has a context menu allowing you to
Edit
orDelete
the report

Refreshing the Facebook Airtable Connection
In order to refresh your facebook data and sync it to airtable click the
Refresh
button
Connecting the Facebook Page Insights API to Airtable
- Click
New report
- Search for
Facebook
- Select
Facebook Page Insights

- Configure the Page Insights connector
- Click
Save
Connecting the Facebook Post Insights API to Airtable
- Click
New report
- Search for
Facebook
- Select
Facebook Post Insights

- Configure the Post Insights connector
- Click
Save