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

Learn how to integrate Facebook Ad Campaign insights into Google Sheets using Pabbly Connect for seamless automation. Follow our step-by-step guide! Build sophisticated automated workflows in less time than you think. This guide translates complex integrations into straightforward steps for immediate implementation.

Watch Step By Step Video Tutorial Below

Setting Up Pabbly Connect for Facebook Ad Insights

To begin the integration process, you will need to access Pabbly Connect. This platform is crucial for connecting your Facebook Ads account and Google Sheets. Start by visiting the Pabbly Connect website and logging in or signing up for a free account.

Once logged in, navigate to the dashboard and click on the ‘Create Workflow’ button. You can name your workflow something like ‘Facebook Ad Insights to Google Sheets’. This will help you keep your automations organized. After naming, select the folder where you want to save this workflow.

Configuring the Trigger in Pabbly Connect

In this step, we will configure the trigger to fetch Facebook Ad insights at regular intervals. Select the ‘Schedule by Pabbly’ app as your trigger. This allows you to set how often you want the workflow to run, such as every 30 minutes. using Pabbly Connect

Choose the option for running the workflow at a regular interval and set it to 30 minutes. Click on ‘Save’ to configure the trigger. This ensures that your automation will fetch the latest ad insights from Facebook Ads every half an hour.

• Select ‘Schedule by Pabbly’ as the trigger app.
• Set the interval to 30 minutes.
• Click on ‘Save’ to finalize this step.

Now that the trigger is set, the next step will involve fetching the specific ad insights from your Facebook Ads account.

Fetching Facebook Ad Insights Using Pabbly Connect

Next, we will fetch the ad insights from Facebook using Pabbly Connect. Select the ‘Facebook Ads Insights’ app as the action step. Choose the action event as ‘Get Ad Object Insights with Date Preset’.

Connect your Facebook account by entering the Ad Object ID, which you can find in your Facebook Ads Manager URL. Specify the date preset as ‘today’ to get insights for the current day. Enter your Facebook access token, which you can generate from the Facebook developer portal.

• Select ‘Facebook Ads Insights’ as the action app.
• Use the ‘Get Ad Object Insights with Date Preset’ action event.
• Enter your Facebook Ad Object ID and access token.

After entering these details, click on ‘Save and Send Test Request’ to fetch the ad insights. This will provide you with the data needed for your Google Sheets.

Adding Insights to Google Sheets Using Pabbly Connect

Now that we have fetched the ad insights, the next step is to add this data to Google Sheets using Pabbly Connect. Choose Google Sheets as your action app and select the action event as ‘Add New Row’.

Connect your Google Sheets account by signing in and allowing permissions. Once connected, choose the specific spreadsheet where you want to add the insights. Map the fields from the Facebook Ad insights to the corresponding columns in Google Sheets.

Select ‘Add New Row’ as the action event. Map the Facebook insights to the appropriate columns in Google Sheets. Click on ‘Save and Send Test Request’ to verify the integration.

Once you click on ‘Save and Send Test Request’, check your Google Sheets to confirm that the insights have been added successfully. This completes the integration process.

Conclusion

In summary, using Pabbly Connect allows you to automate the process of fetching Facebook Ad insights and adding them to Google Sheets seamlessly. This integration helps you keep track of your ad performance in real-time, enhancing your marketing efforts.