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

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?

You can import your Google Ads data to Google Sheets via two methods:

Method 1: Connecting Google Ads to Google Sheets using the Two Minute Reports Hub.

Method 2: Connecting Google Ads to Google Sheets using the pre-built templates.

Let’s get started with the first method.

Method 1: Connect Google Ads to Google Sheets using the Two Minute Reports Hub

The Two Minute Reports Hub is your centralized workspace for managing all your Google Ads accounts. Here’s how to get started.

Step 1: Creating a Connection

1. Go to hub.twominutereports.com and click Connections → Create Connection.

2. Inside the dialog box, complete these three steps:

• Select the Google Ads connector from the list of options.

• Enter the name for your Connection and authorize it by logging in with your credentials.

• Enable the Google Ads accounts you want to measure performance for. Please note that you can’t query the disabled accounts.

3. Once done, navigate back to the Hub Homepage and click Google Sheets → New Google Sheets Report.

4. Click Use Template and follow the on-screen instructions to launch the Two Minute Reports add-on in your spreadsheet.

Step 2: Configure and Run Your Query

1. Once you’ve installed the add-on, navigate to Menu → Data Queries and click Add.

2. Select the Google Ads accounts that you want to include from the sidebar.

3. If you're managing multiple clients, go to Clients → Manage Clients, map your Google Ads accounts to the relevant clients and click Save & Close.

4. Choose relevant Google Ads metrics and dimensions and select your date range.

5. Click Run Query to pull the data into your chosen sheet and cell.

6. The next step is to Save & Automate your query. 

Pro Tip: You can set up custom refresh schedules to automate daily, weekly, and monthly Google Ads performance reporting to your clients. Choose your preferred format – PDF, Excel, or Spreadsheet and keep reports updated automatically without manually exporting data every time.

Prefer to work directly inside Google Sheets? You can also connect Google Ads to Google Sheets by installing the Two Minute Reports add-on from the Google Workspace Marketplace, following the steps below:

• Open a spreadsheet. Launch the add-on from Extensions → Two Minute Reports → Launch.
• Click Menu → Connections → Add and select the Google Ads connector.
• Authorize your account and enable the accounts you want to query.
• Click Refresh Connections to confirm your accounts appear in the sidebar.

Once connected, follow the same query steps above to start pulling your Google Ads data directly into Google Sheets.

Set up your data pipeline

Take my data from

Google Ads

Save my data to

Google Sheets

PROCEED

Method 2: Using Google Ads Google Sheets Template

With Two Minute Reports’ pre-built Google Ads templates for Google Sheets, you can create custom reports within minutes. Here’s how you can:

1. In the template gallery, select the Google Ads template; let us choose the Google Ads - Monthly Performance Analysis.

2. Next, click ‘Get Template for Free’ to open the Google Sheets template.

3. Then, click Use Template. You’ll land on the Google Sheets dashboard.

4. Click Use to launch the Two Minute Report sidebar in your Google Sheets.

5. Finish importing your template by selecting the required Google Ads accounts from the dropdown. Once done, click Submit to create your report.

6. Click Run Query to fill this template with the necessary data.

7. And that’s it. Your Google Ads data is populated across relevant sections, helping you give a detailed overview of what’s happening and what needs to be improved.

Once your Google Ads data is in Google Sheets, you can monitor metrics such as CPC, CTR, CPA, and conversion rate over time. Google Ads benchmarks show significant variation across industries, with CPC ranging from $0.23 to $4.57 and conversion rates from 2.61% to 13.90%. To see how your performance compares with other industries, explore our Google Ads Benchmarks.

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.

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.