Skip to content

How to obtain the access token for the Facebook Ads source

To connect to the Facebook Ads API and begin importing data into Google Sheets or BigQuery, follow the steps below.

Step 1: Sign In to the Meta for Developers Portal

Section titled “Step 1: Sign In to the Meta for Developers Portal”

Visit the Meta for Developers site and log in with your Facebook account.

Facebook login portal

Facebook login page

Navigate to My Apps and click the Create App button.

Facebook My apps

Facebook creating app

Enter the App Name in the provided field.

Facebook app name

Select Other as the use case.

Facebook Other use case

Select Business as the app type and click Next.

Facebook Business app type

Choose the appropriate Business Portfolio, then click the Create App button.

Facebook Business portfolio option

Navigate to App Settings → Basic, and initiate the Business Verification process.

Facebook Business Verification

If prompted, connect your app to a business portfolio.

Facebook Connect

Click Start Business Verification.

Facebook Start Verification

On the next page, locate the Business Verification section and click the button to proceed with the verification process.

Facebook Portfolio Verification

Fill in the form with accurate contact and organizational information about your business.

📌 Make sure your submission meets Meta’s verification requirements.

After submitting the form, the review process may take up to 2 business days.

Facebook Submitted

Once your business is successfully verified, return to the Developers Portal.
In your app dashboard, locate Marketing API and click Set Up.

Facebook Marketing API set up

Grant the required token permissions:

  • ads_read

  • read_insights

    These permissions authorize your app to access advertising data from your Facebook account.

Facebook permissions granting

Step 6: Generate and Save the Access Token

Section titled “Step 6: Generate and Save the Access Token”

Click the Get Token button.

Facebook getting token

Copy and securely save the generated access token.
If needed, you can regenerate it later by navigating to Marketing API > Tools.

Facebook saving token

Once you have the access token, you can use it as described in the Getting Started guide.

If you encounter any issues:

  1. Check the “Logs” sheet for specific error messages
  2. Please visit Q&A first
  3. If you want to report a bug, please open an issue
  4. Join the discussion forum to ask questions or propose improvements