“How do I automatically send my Facebook lead ad data to Google Sheets?”– Facebook Advertiser
“How do I get my Facebook leads on a Google sheet?”
“Are there any tools that let me auto-export Facebook ad data to a Google spreadsheet on a daily basis?”
Facebook advertising is one of the major marketing channels in the marketing industry. Like other marketing channels, it needs reporting. But Facebook reporting is tough. The Facebook Ads API (application programming interface) is hard to understand to start and the interface is confusing to use.
Google Ads is better with reporting since it’s within the Google ecosystem. So this means that the integration is easier. And you can start analyzing the data quickly. Facebook doesn’t have that luxury.
You CAN import Facebook Ads data to Google Sheets. You do copy and paste until your eyes and fingers can’t take the mundane task anymore. That’s manual reporting and it’s an unbearable nightmare.
Who wants to do that?! There are better ways to automate this task and save time.
A No-Code Guide On How To Import Facebook Ads Data To Google Sheets
To connect Facebook Ad data to Google Sheets, you need a Google Sheets add-on. These add-ons are most likely paid add-ons. As mentioned, you can do it manually (for free) to save money. But in perspective, you might want to spend a little bit to save time. You choose.
Marketers also know that Facebook and Google are at war with each other. So Facebook and Google Sheets doesn’t have a built-in integration method.
You’ll use Two Minute Reports for this example. Two Minute Reports imports data from the Facebook API directly to Google Sheets in minutes. No required coding skills. Note that the data below is for paid advertising and not from organic Facebook pages.
Installing The Google Sheets Add-on
1 – Go to your Google Drive workspace.
2 – Click ‘+ New’ then create a new Google Sheets file.
3 – At the top, click Add-ons. Then click ‘Get add-ons’.
4 – Search for Two Minute Reports. Then install it.
5 – You now have the add-on installed on your Google Sheets workspace.
Import Facebook Ads Data Source
1 – Launch the add-on. A navigation pane on the right side will appear.
2 – Click Add + under Data Sources.
3 – Name your data source. Then select Facebook Ads.
4 – Log-in to your Facebook account.
5 – Link your Facebook account to the tool. Go through the login process until the tool instructs you to close the tab since the sign-in is successful.
Import Facebook Ads Data Query
This point in the process is the importing data from the Facebook Ads API to the spreadsheet.
1 – Click the burger icon. Then click Data Queries. And click ‘Add +’.
2 – Name your data query. Find the Facebook data source you imported earlier.
3 – ‘Save on Sheet’ is the location of the sheet where the data is imported to. Add A1 under Cell.
4- Under ‘Query’, select the Facebook Ad Account you want to get data from. *See further down this blog post to learn how to give permissions on Facebook.
5 – Select the ‘Metrics’ you want to import (Clicks, Reach, Impressions, Conversions, etc).
6 – Select the ‘Dimensions’ you want to import (Campaign name, Ad name, etc).
7 – Select the date range with whatever you need.
8 – You may select additional Filters and Sort options. You may leave them blank for now.
9 – Click ‘Run query’
Viola! You imported your Facebook ads data to Google Sheets hassle-free. You can create reporting templates from here depending on your business needs.
Two Minute Reports can import all the metrics and dimensions from the Facebook API. As a rule of thumb, know what you need to report on and be knowledgeable of Facebook metrics.
Schedule Facebook Ads Reports
Two Minute Reports has a scheduling function. This means the spreadsheet will refresh the acquired data from the API. Reports are automated even more.
1 – Click the burger icon. Then click Schedule Refresh. And click ‘New +’.
2 – Once inside, you can set the terms of the report schedule.
-Repeats -> This is where you set how often the data refresh happen. Two Minute Reports can do hourly refresh.
3 – You can also set the notification terms. Two Minute Reports can email you a PDF or Excel of the data. You can also decide to have the email contain the sheet content in the email body.
4 – Click ‘Save’.
Scheduling will help when you need to report on Facebook Ads overtime. No more copy and paste every day, or every week, or every month.
Bonus: How to Add User Permissions on Facebook
1 – Go to your Facebook Business Settings. Go to Users > People. Click ‘Add’
2 – Enter the email address that needs access to the data. It’s most likely yours. Access should be at least ‘Employee access’.
3 – Choose the ‘Ad Account’ and choose the level of permissions.
4 – The invitation is sent. The recipient should accept the invitation. That email will have access and will have the ability to import Facebook Ads data to Google Sheets.
Conclusion – Connect Facebook Ads To Google Sheets
This is one of the many add-ons to connect Facebook Ads data in Google Sheets. Another add-on to consider is Supermetrics. These are the current methods to do integrations between third-party tools. These add-ons cost money but the benefits outweigh more.
Avoid import and export spreadsheet hell. Maintain everything in Google Sheets with tools if needed. Stop wasting time on repetitive tasks. Start focusing on important stuff that impacts the business.