Connect Facebook Ads to Google Sheets: Tutorial and Templates (2025)

Did you know that 40% of marketers consider Facebook as one of their top three drivers for ROI? This highlights the significance of leveraging the platform’s built-in advertising capabilities to target the right audiences and drive conversions effectively. 

However, to unlock this potential, you need to streamline campaign tracking. While the native Facebook Ads Manager offers meaningful insights, it lacks scalability. You’ll find it cumbersome when dealing with multiple campaigns for different clients with varying objectives. 

So how can you overcome this challenge? You need an intuitive PPC reporting software, such as Two Minute Reports, which allows you to connect your ad account to Google Sheets and automate performance reporting with ease.

In this guide, you’ll discover effective ways to connect your Facebook Ads with Google Sheets. By the end, you’ll master how to generate data-driven Facebook Ads reports that win clients’ trust and boost ROI.

Let’s get started.

How to extract Facebook Ads to Google Sheets?

Want to leverage most of your Facebook Ads campaigns? Here, let me show you how to easily import your Facebook Ads data into Google Sheets, no coding required. With this Google Sheets integration, you can analyze and track your campaign’s performance in real time.

Before we dive into the steps, you can watch this quick tutorial to visualize the whole process in action. This will help you to understand exactly how to set it up.

To get started, install the Two Minute Reports add-on from the Google Workspace Marketplace. Once installed, you can proceed with any of the following methods to create a Facebook Ads report with Google Sheets.

Now, let’s get started with the first method.

Method 1: Connecting Facebook Ads to Google Sheets using the sidebar

Step 1: Creating a Connection to your source

You need to connect your Facebook ad accounts with Two Minute Reports. 

To do this, launch the Two Minute Reports add-on from the extensions menu in your spreadsheet. Next, open the sidebar and perform the following steps:

Go to Menu > Click Connections > Click Add to start creating your connection

Once you’ve done this, the “Adding new connection” dialog appears. Follow the steps below to authenticate your Facebook Ads connection with Two Minute Reports, which takes less than two minutes to complete.

1. Select the Facebook Ads connector.

2. Next, authorize your connection by specifying the login credentials. Once you’ve successfully authenticated, you can view the following: Account name, ID, Connection name, Status, Speedboost, as shown below:

3. Enable the toggle for the accounts you want to run queries. Please note that you cannot extract data from disabled accounts. 

With Speedboost, you can access data 10x faster and experience uninterrupted performance, ensuring seamless report delivery across multiple clients.

Note: Once you’ve enabled the associated accounts, you can hit “Refresh Connections” to ensure the connected Facebook Ads accounts are reflected in the sidebar.

With the Connection established, the next step is to create a query. Let’s explore how to do that.

Step 2: Creating a query and report configuration

To pull your Facebook Ads performance data, click Data Queries from the Menu dropdown. Follow the steps below to instantly create your Facebook Ads report:

1. Click Add and choose the respective Facebook Ads account to analyze your campaign performance.

2. Alternatively, navigate to the Clients section. Click on “Manage Clients” and map the necessary account details. Once done, click Save & Close to save your client’s details.

3. Next, add the required Facebook Ads metrics and dimensions you want to analyze. Once done, select the date range to analyze and measure campaign performance.

4. Once you finish the above steps, click Run query to visualize the final output. This query fetches the data from your chosen Facebook Ads account onto the sheet and cell of your choice.

Pro Tip: You can set up custom refresh schedules – daily, weekly, or monthly to automatically deliver consistent, real-time updates to your clients.

Pro TMR Tip: Run all your queries directly from the Extensions menu on your Google Sheets. Go to Extensions > Two Minute Reports > Choose your desired quick action. 

While creating your Facebook Ads report through the sidebar is straightforward, there’s also another effective way to streamline your campaign analysis. Let’s look at leveraging Facebook Ads reporting via built-in templates.

Method 2: Create Facebook Ads reports using pre-built templates

Two Minute Reports offers ready-to-share templates that allow you to create Facebook Ads reports faster. You can access Facebook Ads Google Sheets templates via:

Extensions > Two Minute Reports > Templates

• In the template gallery, you can select the Facebook Ads template that fits your purpose. 
• Next, click Use to build your report. Your chosen template will open in Google Sheets.
• Finish importing your template by selecting the required Facebook Ads accounts from the dropdown. Once done, click Submit to create your report.

• Next click, Extensions > Two Minute Reports > Run all queries to update your template with the campaign performance data. 
• Once the queries are complete, the template will be updated with your data.

Why import Facebook Ads data to Google Sheets?

Incorporating Facebook Ads into the Google Sheets account can significantly boost your ad management and analytics prowess. You can unlock abundant opportunities to implement data-driven marketing strategies by enabling a seamless integration between these two platforms. Here’s how you can leverage this integration:

Streamlined reporting

Streamline campaign performance, monitor real-time updates, and create custom Google Sheets dashboards with a reliable Facebook Ads reporting tool. When integrated with data visualization tools like Google Sheets, you can highlight important KPIs and translate its impact into actionable reports, providing an organized and efficient approach to data analysis and reporting.

Marketing strategy enhancement

Compare your Facebook Ads campaign performance with various PPC channels and visualize true cross-channel ROI. A marketing reporting software can help you gather the analysis and significant outcomes, enabling you to make data-driven decisions that enhance the effectiveness of your Facebook advertising strategy.

Optimized data management 

Bid adieu to manually downloading CSV files, as now you can effortlessly import Facebook Ads data to Google Sheets. Additionally, leverage Two Minute Reports’ automated reporting capabilities to consistently report up-to-minute campaign insights, ensuring you’re working with the most current information.

Comprehensive data analysis 

Using Google Sheets, you can extract built-in and custom Facebook ad metrics that resonate with your campaign goals. This functionality paves the way for easy accessibility, enabling your team to work together on analyzing campaign data and fostering a highly collaborative environment.

Workflow efficiency

Set up automated workflows to channel data from Facebook ads to Google Sheets, effectively streamlining the data extraction process. This process ensures seamless synchronization when connecting Facebook ads data to Google Sheets, enabling consistent workflow management by aligning your datasets.

Overcoming challenges with Facebook Ads and Google Sheets integration

While integrating Facebook Ads with Google Sheets, syncing data between two platforms can sometimes be challenging. Let me explain the potential issues and actionable steps to successfully extract campaign data and gain actionable insights.

1. Technical issues with integration

Problem: Sometimes, you might encounter technical roadblocks such as sync failures, incorrect data being pulled, or a lack of real-time data updation. These issues affect your reporting workflow, making it difficult to access performance data.

Solution: Ensure you use a reliable reporting tool such as Two Minute Reports to quickly connect your Facebook Ads account to Google Sheets and extract KPIs hassle-free.

2. Data formatting and structure issues

Problem: When importing Facebook ads data to Google Sheets, data might not align or be formatted properly. This doubles down on your manual efforts, consuming countless hours to get things done. 

Solution: Leverage Google Sheets' built-in features like pivot tables, filters and conditional formatting to structure and organize your data, streamlining the process and saving time.

3. Inconsistency in reporting 

Problem: When exported to Google Sheets, Facebook Ads Manager displays certain metrics in slightly different ways. This happens due to incorrect time zones, rounding differences, and varied formats for tracking custom metrics.

Solution: Ensure you set the same time zones, dates, and precise formats for custom metrics to be consistent in Facebook Ads Manager and Google Sheets. This will help maintain data integrity, enabling accurate campaign analysis and insights.

4. Lack of customization

Problem: Facebook Ads manager has limited reporting capabilities, making extracting and customizing specific campaign insights into Google Sheets difficult. 

Solution: You can use Two Minute Reports’ Facebook Ads templates for Google Sheets to centralize KPIs, create personalized dashboards, and gain actionable performance insights to make informed decisions.

5. Handling large volumes of data

Problem: When managing multiple Facebook Ad campaigns across different ad sets, handling the sheer volume of data within a single Google Sheet can be challenging.

Solution: With Two Minute Reports’ Facebook Ads reporting tool, you can consolidate data from different ad accounts in a single dashboard, enhancing data management and analysis.

Important metrics used in the Facebook Ads Google Sheets reports

The Facebook ads integration into Google Sheets enables you to extract key Facebook Ads KPIs to optimize your ad strategy and budget. Here are the top metrics you can extract from Facebook Ads:

Get Facebook Ads data in Looker Studio

Two Minute Reports offers an intuitive solution for integrating Facebook Ads with Looker Studio, enabling streamlined data analysis and visualization. By extracting key KPIs into Looker Studio, you can easily create and share engaging Facebook Ads reports within minutes.

Connect your preferred marketing platforms with Google Sheets 

With the Two Minute Reports Google Sheets add-on, extract meaningful insights, build real-time dashboards, and deliver professional white-label reports for faster decision making and growth.

Whether you want to blend PPC campaign insights across platforms, measure product sales, track organic conversions, or optimize social media ROI, you can connect across 30+ data sources in Google Sheets. Create unlimited reports, load dashboards 10x faster and streamline multi-client reporting without switching tabs.