Importing Facebook Ads Data
Importing Facebook Ads Data into Google Sheets
Getting Started
Install the API solution add-on from Google Marketplace.
Begin by getting your Facebook API personal access token
To request data from Facebook Ads you must first have a developer account with Meta/facebook. After this you can obtain a personal access token.
1. Begin by navigating to https://developers.facebook.com/apps/ and selecting Create App.
2. You will then be prompted to set up your app. (If your business acountwas not setup, you will be prompted to do this first).
For app type choose Business and then select next.
3. Finish the app by entering a name and details (be sure to abide by Facebook terms of service). Click Create App.
4. On the developer dashboard go to heading: “Add Products to Your App.”
Then go to Marketing API and click Set Up.
5. On the sidebar of Marketing API you will click on Tools.
6. Now under Get Access Token you will check the “ads_read” permission and then click Get Token.
7. Your access token is now ready. Copy this to use in Google Sheets with Phlorin.
Note: Facebook’s personal access token may expire after 2 months, be sure to repeat the steps to create a new one when it is time to reup.
Pull Facebook Ads Data into Google Sheets
To get the most out of Facebook Ads, use Phlorin to pull data seamlessly into Google Sheets.
1. In your desired Sheets document, open Phlorin and create a new request: Extensions > Phlorin > Open > Create a request
2. In the Application dropdown select or search for Facebook Ads.
3. From here we will need to select an endpoint, enter Authorization (your personal access token), and your account_ID (found under your Meta account).
4. Make sure your desired sheet is selected and click Run
Need help creating your request?
Reach out to us: Contact support or join our community forum.
Creating Custom Request
Though it is recommended to use Phlorin’s built-in functionality, with Facebook Ads API documentation you can find URLs to run custom requests. Search their documentation for the desired request and adapt the URL to suit your needs.
Example request:
Application: Custom
Method: GET
Request URL: https://graph.facebook.com/v18.0/act_12345/insights?date_preset=this_month&fields=clicks,cpc,ctr,impressions&time_increment=1
Adapting the URL to your needs:
This particular request URL can be formatted to fit your demands.
Example request:
Insights API documentation: https://developers.facebook.com/docs/marketing-api/insights/
Campaign API documentation: https://developers.facebook.com/docs/marketing-api/reference/ad-campaign-group