Connect Google Ads to Google Sheets: Tutorial & Free Templates (2025)

Google Ads is not just about driving traffic; it is a powerful tool for generating revenue. While an average business achieves a 4.4% conversion rate from Google Ads, it's no surprise that marketers rely on it to reach high-intent audiences and maximize their ROI.

It ensures that your message reaches the right audience at the right moment – whether through search, display, YouTube, etc. With its suite of AI-powered advertising tools, you can create advanced campaigns and boost performance to accomplish your goals.

However, launching your campaigns is the first step. The real value lies in tracking, analyzing and optimizing performance. And, if you are still manually pulling reports, you are wasting a lot of time and effort.

The solution is to automate your Google Ads reporting with Google Sheets.

This guide will walk you through two easy steps to connect Google Ads with Google Sheets, enabling you to streamline your ad accounts, automate performance reporting, and gain real-time insights, improving scalability and efficiency.

Let’s get started.

How to extract Google Ads data to Google Sheets?

Here, let me show you two effective ways to extract and visualize data from Google Ads to Google Sheets, no coding required. Before we get started, you can watch this quick video tutorial to get a clear idea of how to track and automate Google Ads reporting with Two Minute Reports.

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 Google Ads report with Google Sheets.

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

Method 2: Connecting Google Ads to Google Sheets via built-in templates.

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

Step 1: Creating a Connection to your source

To create a Connection, you must connect your Google Ads 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 new Connection

Once this is done, the “Adding new connection” dialog appears. Next, follow the steps below to authenticate your Google Ads connection with Two Minute Reports:

1. Select the Google Ads connector.

2. Next, authorize your connection by specifying the login credentials. Once you’ve authenticated, you can visualize the following fields: Account name, ID, Connection name, and Status, 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.

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

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

Step 2: Creating a query and report configuration

To extract your Google Ads campaign data, click Data Queries from the Menu dropdown. You can follow the steps below to create your Google Ads report.

1. Click Add and choose the respective Google Ads accounts to track and measure 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 Google Ads metrics and dimensions you want to analyze. Then, select the date range to measure campaign performance.

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

Pro tip: You can set up automated refresh schedules (daily, weekly or monthly) and keep your clients informed with live, real-time performance updates.

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

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

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

Two Minute Reports offers ready-to-share, customizable Google Ads reporting templates to streamline tracking and create reports faster. You can access the templates via:

Extensions > Two Minute Reports > Templates

• In the template gallery, you can select the Google Ads template that fits your purpose.
• Next, click Use to build your report. Your template will open in Google Sheets.
• Finish importing your template by selecting the required Google 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, your template will be auto-populated with actionable campaign insights.

Why connect Google Ads data to Google Sheets?

The Google Ads integration with Google Sheets emerges as a game-changer for businesses and advertisers. By leveraging this no-code, effortless integration, you significantly enhance your data analysis, automate reporting, and implement effective Google Ads optimization strategies. Let’s delve into the key benefits of connecting Google Ads to Google Sheets:

Enhanced data analysis and reporting

Using the Google Ads integration with Google Sheets unlocks a new realm of data analysis and reporting capabilities. It simplifies the process of extracting data, ensuring you stay current with real-time updates, which helps improve your clients' campaign performance and ROI.

Efficient management of multiple Google Ads accounts

For digital marketers managing multiple client ad accounts, integrating with Google Sheets is incredibly beneficial. This integration allows you to map clients easily and consolidate data from their respective ad accounts in a single dashboard. No need to toggle between platforms or deal with mismatched reports.

Select custom Google Ad metrics 

When you connect Google Ads to Google Sheets, you can select specific data points most relevant to your objectives, including adjusting the date range for your analysis. This customization ensures that you're not just collecting any data, but the right data from Google Ads within the specified date range. 

This flexibility allows you to focus on specific aspects of your campaigns, such as performance within a certain date range, ensuring that your analysis is both targeted and relevant.

Easy accessibility and collaboration

A significant advantage of connecting your Google Ads account with Google Sheets is the ease of access and collaboration it offers. Team members can pull data effortlessly, edit, comment, and view Google Ads reports in Google Sheets, fostering an environment conducive to collaborative, data-driven decision-making.

From comprehensive data analysis to the efficient management of multiple accounts and automated reporting, this connection between Google Ads and Google Sheets is an invaluable asset. Embrace this integration to transform your approach to Google Ads data, leading to more successful and informed advertising campaigns.

How to fix Google Ads data syncing errors in Google Sheets?

Google Ads is a data powerhouse, providing granular insights into campaign performance. However, when exporting that data to Google Sheets, many advertisers face discrepancies, overwhelming data, slow updates, and reporting inconsistencies. Without the right approach, you might make misinformed decisions or spend hours manually fixing reports.

Let’s break down the common roadblocks and, most importantly, how to fix them.

1. The “Real-time data” illusion – Why numbers don’t match?

Concern: Google Ads data in Google Sheets isn’t always as “real-time” as it seems. While some metrics like clicks and impressions update instantly, others (conversions, revenue attribution) take longer to process. If you’re checking reports at the wrong time, you might make decisions based on incomplete datasets. And that’s an issue because adjusting bids or pausing campaigns too soon could disrupt performance rather than optimizing them.

Approach: Instead of manually tracking data every few minutes (we’ve all been there), set up automated refresh schedules using Two Minute Reports in Google Sheets. This ensures you always work with the latest data without second-guessing your reports.

2. Too much data, too little clarity – Why can pulling everything from Google Ads backfire?

Concern: Just because Google Ads provides enormous amounts of data doesn’t mean you must dump it all into Google Sheets. Pulling in everything – campaigns, keywords, demographics, and placements might seem like a good idea, but it slows down your sheets, clutters your insights, and makes trend-spotting harder than it needs to be.

Approach: Focus on the metrics that matter. Use Two Minute Reports’ Google Ads reporting tool to extract only the data that aligns with your campaign goals. Streamlined reports mean faster insights and fewer roadblocks.

3. Budget tracking woes – Are you staying on top of your ad spend?

Concern: Managing ad spending across multiple campaigns is tricky. Spend too fast, and you burn through your budget before the month ends. Spend too slowly, and you miss out on conversions. The worst part? Without proper tracking, you might not even realize where the problem is.

Common budget pitfalls include:

• Spend pacing mismatches – running out of budget too early or not spending enough.
• Manually tracking spending across multiple accounts (and the inevitable human errors).
• Underperforming campaigns gradually deplete your ad budget.

Approach: Instead of relying on manual checks, automate budget tracking in Google Sheets. With Two Minute Reports, you can pull real-time spending data and keep your campaigns cost-efficient with accurate, up-to-date insights.

4. Inefficient ad spend – Are you paying for clicks that don’t convert?

Concern: Not all clicks hold the same value. Without proper oversight, you might be spending your budget on:

• Broad match keywords that bring in the wrong audience.
• Clicks from regions or demographics that don’t convert.
• Bot traffic or accidental clicks inflating your numbers without real value.

Approach: With Two Minute Reports, you can filter out low-performing keywords, high-cost placements, and weak audience segments so you can cut inefficient ad spending and focus on what drives ROI for your clients.

Most important metrics to track in your Google Ads reports

When connecting Google Ads to Google Sheets, it’s essential to import key Google Ad metrics for in-depth analysis. Now, let’s look at the metrics that are vital to optimizing your campaign in the right direction.

Performance metrics

As the name suggests, these metrics are key identifiers of how your ad campaigns and ad groups perform.

Get Google Ads data in Looker Studio

You can integrate Google Ads data with Looker Studio (formerly Google Data Studio), enabling advanced data analysis and visualization. With seamless integration, comprehensive analytical capabilities, and automated workflows, you can customize your Looker Studio dashboards and achieve precision with performance optimization.

Connect your marketing platforms with Google Sheets

In addition to connecting with Google Ads, Two Minute Reports lets you connect across 30+ data sources in Google Sheets. No need to juggle spreadsheets, copy-paste formulas, or create reports from scratch. By connecting your preferred platform with Two Minute Reports, you can centralize, streamline, and automate campaign reporting seamlessly.