How to Add Facebook Ad Campaign Insights in Google Sheets Using Pabbly Connect

Learn to integrate Facebook Ad Campaign Insights into Google Sheets using Pabbly Connect for efficient automation and data management. Master proven automation processes with practical implementation examples and strategic recommendations you can apply immediately in your workflow.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Automation

To start adding Facebook Ad Campaign insights into Google Sheets, we first need to access Pabbly Connect. Open your browser and visit the Pabbly Connect website to sign in or create a new account.

If you’re new to Pabbly Connect, click on the ‘Sign Up Free’ button. This allows you to set up a free account, which includes 100 free tasks every month. Existing users can simply log in to their accounts.

2. Creating a Workflow in Pabbly Connect

Once logged in, navigate to the dashboard and click on ‘Create Workflow’. Name your workflow something like ‘Facebook Ad Insights to Google Sheets’. This naming helps you identify the workflow later on. using Pabbly Connect

• Click on ‘Create’ to open the workflow.
• You will see two windows: the Trigger window and the Action window.
• Select ‘Schedule by Pabbly’ in the Trigger window to set the automation interval.

In the schedule settings, choose to run your workflow at a regular interval, like every 30 minutes. This ensures that your Google Sheets are updated in real-time with the latest Facebook Ad insights.

3. Setting Up Facebook Ad Insights in Pabbly Connect

Next, we will configure the action step to fetch insights from Facebook Ads. In the Action window, select ‘Facebook Ads Insights’ from the app list. Choose the action event as ‘Get Ad Object Insights with Date Preset’. using Pabbly Connect

Now, you need to enter the Ad Object ID, which can be found in your Facebook Ads Manager. Copy the specific campaign or ad set ID from the URL and paste it into Pabbly Connect. You will also need to specify the date preset, like ‘Today’, to fetch current insights.

• Enter your Facebook Ad Account ID with the prefix ‘act_‘ if fetching account insights.
• Make sure to generate and enter your Facebook access token for authentication.
• After configuration, click on ‘Save and Send Test Request’ to fetch insights.

Once the test request is successful, you will see the ad insights received from Facebook, including metrics like impressions and clicks.

4. Adding Insights to Google Sheets Using Pabbly Connect

After successfully fetching insights, the next step is to send this data to Google Sheets. In the Action window, select ‘Google Sheets’ and choose the action event ‘Add New Row’.

Connect your Google Sheets account with Pabbly Connect by clicking on ‘Sign in with Google’. Choose the spreadsheet where you want to add the insights, and select the specific sheet.

Map the fields from Facebook Ad insights to the corresponding columns in Google Sheets. Include fields like Date and Time, Campaign ID, CTR, Impressions, and more. After mapping, click on ‘Save and Send Test Request’ to ensure data is correctly added.

Upon successful execution, you will see a new row in your Google Sheets populated with the latest Facebook Ad insights.

5. Conclusion

In this tutorial, we learned how to effectively use Pabbly Connect to automate the process of fetching Facebook Ad Campaign insights and adding them to Google Sheets. This integration ensures your ad performance data is up-to-date and easily accessible.

By following these steps, you can set up similar automations for various applications using Pabbly Connect, enhancing your workflow efficiency and data management capabilities.