How to Connect Facebook Ads to Google Sheets

Companies usually integrate Facebook Ads and Google Sheets for Reporting and Analysis.Facebook Ads generate a lot of valuable data that can help marketers make improvements to their marketing techniques. 

1. Such data can give you insights that can help you know how the ads are converting into actual sales. However, it is a bit difficult for you to analyze such data on Facebook. 
2. It will be good for you to move the data from Facebook Ads to Google Sheets for analysis. Google Sheets has a number of mathematical formulas that you can use to extract insights from the data. 
3. It is also easy for you to connect Google Sheets data to a tool like Google Analytics for advanced analytics. 

Pre-requisites:

• A Facebook Account. 
• A Google Sheets account. 
• Google Sheets API connector

How to Integrate Facebook Ads and Google Sheets Data

Method 1 – Generate your Facebook API User Access Token

• Step 1: Open the URL given below on your web browser and click the “My Apps” button from the top right corner of the screen. 
• Step 2: Click the “Create App” button. 
• Step 3: On the window that pops up, choose “For Everything Else”. 
• Step 4: Enter the app details and click the “Create App ID” button. 
• Step 5: You will then be taken to the Developer dashboard. You don’t have to do anything on this page. Instead, open the Facebook Graph API Explorer using the following URL: Tools Explorer
• Step 6: Select the ad that you have created, and then choose “Get User Access Token” from the dropdown. 

Step 7: On the window that pops up, login to your Facebook account and click the “Continue as …” button. 

Step 8: You should now be able to see public_profile under Permissions. Click the “Add a Permission” dropdown, choose “Events Groups Pages” then select the “ads_read” permission. 

Step 9: Click the “Generate Access Token” button. 

Step 10: On the modals that pop up, keep on clicking the “Continue as …” button until the process of linking is complete. 

Step 11: The access token will be shown on the Graph API Explorer. However, it lasts for only 1 hour but you can extend this by clicking the blue icon located next to it and then choosing “Open in Access Token Tool”. 

Step 12: On the new window that is opened, click the “Extend Access Token” button located at the bottom. 

Step 13: Enter your Facebook account password if prompted to do so and click the “Submit” button. 

Step 14: Click the “Debug” button to get a window where you can copy the token to your clipboard. 

Create your Facebook API Request URL

Let us follow the Facebook documentation to access the key summary data for your account. 

• API root: https://graph.facebook.com
• Endpoint: /vAPI_VERSION/act_YOUR_ACCOUNT_ID/insights (You can get your account ID from Facebook Ads Manager). 
• Endpoint Example: /v8.0/act_123456789012345/insights
• Query Strings: ?access_token=USER_ACCESS_TOKEN
  Query Strings Example: ?access_token=EAAEZCmli4ij4BAPTOzshTCirwrKU6tTUP3CE0…

Ensure that you substitute in your own account ID and access token. 

How to Import Facebook Ad Data to Google Sheets

Step 1: Open Google Sheets and click “Add-ons”, choose “API Connector” and then select “Create New API Request”. 

Step 2: In the Configure API Request window, enter the Request URL that you just created. Note that this is the token from another sheet plus the +++ syntax. This will make it easier for you when you need to update the token later. 

Leave the Headers section empty. 

Step 3: Create a new tab and give it the name “FB_insights”. Click the “Set Current” button to use the tab as your data destination. 

Step 4: Give a name to your request and click the “Run” button. 

Now the summary stats data will populate from Facebook Ads to Google Sheets. 

Congratulations! You have successfully integrated Facebook ads and Google Sheets data. Now you can easily send data from Facebook Ads to Google Sheets to analyze your marketing efforts.

You will be taken to the following page:

To create a new spreadsheet, click the “+ Blank” button. 

An untitled spreadsheet window will be opened. 

You can give a title to the spreadsheet by typing it in the “untitled spreadsheet” space. 

You can then begin to type your data into the cells of the spreadsheet. 

How to Download CSV files from the Facebook Ads manager

• Go to the Ads Manager – Export data table. 
• Export as CSV to avoid any errors arising from formatting.
• Head on to Google Sheets – export.
• Get the Sheets with the Facebook Ads data. Whenever you have to update it, you’ll need to download it manually.

The limitation of this method is that you will need to do it again and again when there is a new query. 

Ways to Analyze Facebook Ads Data

Summarize, aggregate, and filter your Sheets data

• Pivot tables: you can create queries, aggregate, and sort data. 
• Charts: you can visualize the data using dashboards.
• Formulas: you can blend data across channels and calculate custom metrics.
• Filters: you can clean and exclude data depending on conditions. 

Set alerts and notifications

• Notify your team via email or Slack when data updates for periodic summaries.
• With the refresh scheduling option, it helps you automatically update the Google Sheets with the latest Facebook Ads data. 

Visualize Google Sheets data on other tools

• Once the data is on Google Sheets, you can easily connect it to other tools for analysis and easier reporting and presentations.

Track Facebook Ads goals 

• Ad pacing monitoring
• Agency client overview
• CPA monitoring + markups or commissions
• Campaign performance
• Cross-channel paid media analysis 

Additional Resources on Facebook Ads And Google Sheets

• Dynamic Dashboard in Google Sheets

Conclusion

In this article, you have learnt why you need to transfer data from Facebook Ads to Google Sheets data.

You’ve also learned how to integrate Facebook Ads and Google Sheets data. However, this method is long and requires manual intervention.

FAQ on Facebook Ads to Google Sheets