How to Connect Google Ads to Google Sheets - Dokin

Google Sheets
Productivity tips
October 23, 2023


As modern business teams increasingly rely on data-driven decision-making, integrating data from various sources becomes a critical aspect of their workflow. For businesses that leverage Google Ads as a primary advertising channel, connecting Google Ads data to Google Sheets is a game-changer. This integration allows for in-depth analysis, tracking performance metrics, and refining advertising strategies. In this comprehensive guide, we'll show you how to connect Google Ads to Google Sheets seamlessly and introduce you to Dokin, a powerful no-code solution that simplifies the process.

Did you know?

Dokin is a no-code solution that allows marketers to sync real-time data from platforms like Facebook and LinkedIn Ads in the Google Sheets, Slides and Docs.

Feed your dashboards with live data and automate reportings for clients and stakeholders.

Try for free

Why Connect Google Ads to Google Sheets?

Google Ads, Google's online advertising platform, plays a pivotal role in many businesses' advertising strategies. In 2022, Google's ad revenue surpassed a staggering $224 billion. However, while Google Ads offers some reporting tools, they often fall short in measuring the full return on investment (ROI) of ad campaigns. This is where Google Sheets comes into play. Many advertisers turn to Google Sheets to analyze their Google Ads data, but importing this data can be a cumbersome, manual process. This is where Dokin comes to the rescue.

How to Import Google Ads Data into Google Sheets

Manually importing data from Google Ads into Google Sheets involves copying and pasting data, which can be time-consuming and error-prone. Dokin provides an elegant solution to this problem by automating the data import process. With Dokin's Google Ads connector for Google Sheets, you can now import real-time Google Ads data into your spreadsheet effortlessly. This eliminates the need for manual work and empowers you to focus on building analysis and insights in your spreadsheet with your Google Ads data.

The Role of Google Ads Reporting

Google Ads reporting is an essential component of successful advertising campaigns. It allows you to track key performance metrics and make data-driven decisions. With Dokin's Google Ads connector for Google Sheets, you can monitor performance metrics such as impressions, clicks, click-through rates (CTR), conversion rates, cost per click (CPC), cost per acquisition (CPA), and return on ad spend (ROAS) directly in your spreadsheet. This integration significantly enhances your ability to track and optimize your ad campaigns.

Key Use Cases for Google Ads Data in Google Sheets

Connecting Google Ads to Google Sheets opens up a world of possibilities. Here are some key use cases:

1. Track Performance Metrics

Google Sheets is an ideal platform for tracking the performance of your advertisements. With Dokin's Google Ads connector, you can import real-time data into your spreadsheets and conveniently monitor key metrics like impressions, clicks, CTR, conversion rates, CPC, CPA, and ROAS.

2. Refine Keyword Targeting Strategy

Many advertisers use Google Sheets to refine their keyword targeting strategies. The flexibility of Google Sheets allows for effective analysis of keyword data. With Dokin, you can analyze metrics like keywords, average position, conversions, CPC, CPA, and quality score to optimize your keyword targeting strategy and improve ad performance.

3. Monitor Conversion Tracking

Google Sheets is an ideal interface for monitoring ad conversions. With Dokin's Google Ads connector, you can utilize real-time conversion data for tracking and analysis. Key conversion metrics include ad spend, deals closed, time period, and conversions, which can be sliced by campaign, ad group, or channel for more granular analysis.

Dokin's Solution: Automating Google Ads to Google Sheets Integration

Dokin is the go-to solution for automating the integration of Google Ads data into Google Sheets. It streamlines data reporting automation, saving you time and reducing errors. Dokin offers customizable templates and built-in data integrations with various platforms, including Hubspot, Google Analytics, Facebook Ads, Search Console, LinkedIn Ads, Notion, Airtable, Search Console, LinkedIn Ads, Jira, Trello, and more. This makes it a powerful tool for simplifying the process of connecting your data across Google Sheets, Slides, and Docs.

Step-by-Step Guide for Connecting Google Ads to Google Sheets with Dokin

Now, let's walk you through how to connect Google Ads to Google Sheets using Dokin:

Step 1: Install Dokin

Install the Dokin add-on in Google Sheets by clicking Extensions on the top menu. Then navigate to the Add-ons menu from the dropdown and click Get add-ons. 

Enter Dokin in the Google Workspace Marketplace search bar. Click the Dokin app and follow the installation steps. 

Select your Google account. Click Allow to authorize Dokin’s access to the required permissions to complete installation. 

After installation, launch the Dokin app from the Google Sheets menu. Click Extensions>Dokin | Sync data - HubSpot, Airtable, GA4 & more>Start. 

You’ll see Dokin running as a sidebar on your Google Sheets. You can now start syncing live data from Google Ads into your Google spreadsheet.

Step 2: Create a data connection

Select “Connect New Data” from the Dokin sidebar. 

Choose Google Ads from the list of data sources.  

Choose whether to import from scratch or an existing template. 

Step 3: Connect your Google Ads account

Connect to your Google Ads account. To do that click on log in and select your GA4 account, grant permissions and you are good to go!

Step 4: Select the data and tables you want to import.

Add filters or sorting options. Choose a specific period for your report for your report. Dokin provides a data inline preview for Google Ads. 

The data inline previewer allows you to import tables to have a quick overview of what your table import is going to look like, make edits or adjustments in the metrics and pivot display.

Step 5: Click Connect.

Your data should auto-populate inside your spreadsheet instantly. 

Sync options:

Assign a Name to your Import

Choose a meaningful name for your import process. This name will help you easily identify and manage your imported data within Dokin.

Enter a Name for your Import

Set Up Scheduled Refresh

This option will automatically refresh your data at specific intervals. You can choose the frequency, including the day and time, and configure notifications to receive alerts when data is refreshed.

Google Sheets

An automatic refresh means that at your specified intervals, the information imported into your Google Sheets will be automatically updated. This ensures that your data remains accurate and reflects the latest changes.

Google Slides and Google Docs

An automatic refresh means that at your specified intervals, the information inserted into your Google Slides or Google Docs will be refreshed. This dynamic updating ensures that your presentations and documents always reflect the most current data, saving you the hassle of manual updates.


Specify how often you want Dokin to automatically refresh your imported data. This ensures that your data remains current without requiring manual updates.

The frequencies that are available:

  • No Automatic Refresh (default, you’ll need to manually click on the refresh button)
  • Weekly: Data refreshes every week. Select a specific day of the week and time for data refresh.
  • Daily: Data refreshes every day. Choose the time for daily data updates.
  • Hourly: Data refreshes every hour.
  • 15 mins: Data refreshes every 15 minutes.


You can opt to receive notifications each time your data is refreshed. The available notification options include:

  • None: No notifications will be sent.
  • Slack: You will receive a Slack message whenever your data is refreshed. If it's your first time selecting this option, you'll be prompted to connect to your Slack workspace.
  • Email: You will receive an email notification each time your data is refreshed.

You can define an auto refresh for your data, with notifications

Expanding Data Integration with Dokin

Dokin goes beyond Google Sheets. You can extend your data integration to Google Docs and Google Slides, allowing you to create comprehensive reports and presentations seamlessly.

Use Cases for Google Docs and Google Slides Integration

Consider the possibilities:

  • Automated Reports: Automatically populate Google Docs with real-time data from your Ads performance, keeping your reports up to date, on the go.
  • Dynamic Presentations: Create dynamic presentations in Google Slides that pull data directly from your synced Google Ads account.

Dokin vs. Other Solutions

When it comes to connecting Google Ads to Google Sheets, there are various methods available. However, Dokin stands out as the most efficient and user-friendly option, as well as the most economical.

Google connector for Google Ads:

Google has build its own connector to sync Google Ads to Google Sheets. However, funnily enough, its features are really limited, and reviews on Google Workspace Marketplace are very low as it’s rated 3.2/5.0!

Other solutions

Using Google Apps Scripts

Alternatively you can connect Google Ads to Google Sheets using AppScript.

However this choice is not ideal and comes with few limitations. The main reasons are:

Aimed at technical users – You’ll need to have a firm coding background and Google Apps Script knowledge as well as a good understanding of the Google Ads API. 

Debugging – Even technical users spend quite a lot of time debugging and maintaining the App Script function used for the import.

Other alternatives

Other interesting solutions exists, like Supermetrics, Coefficient or Coupler. However, Dokin offers a more complete and convenient solution when compared to such alternatives.

  • A more complete offer for Reporting: Unlike other solutions, Dokin is not only limited to syncing data in spreadsheets, but also in Slides and Docs. It allows you to automate all steps of your reporting.
  • 2-way sync: When it comes to syncing data with bases like HubSpot CRM, Trello or Retable, Dokin also allows you to make edits and add records in your spreadsheet and push back data from your spreadsheet to your original sources.

See how we compare:


In the world of digital advertising, harnessing the power of your data is paramount. Connecting Google Ads to Google Sheets is a strategic move that can significantly impact your advertising campaigns. With Dokin, you have the ultimate solution to simplify the data integration process and gain a competitive edge.

To stay ahead of the competition, you need real-time insights, and Dokin ensures your data is always up-to-date. As you optimize your ad campaigns, refine your keyword strategies, and track conversions, Dokin's Google Ads connector for Google Sheets will be your trusted companion.

Enjoyed this article?

Check out our blog or our help center for more.
Dokin, the data platform of modern business teams
Try for free

Jacopo Proietti

Co-founder @Dokin
Jacopo, a co-founder of Dokin, boasts 8 years in finance, having worked as a finance manager at Ogury and head of Financial Planning and Control at BlaBlaCar.
His passion for data integration led to the creation of Dokin, a game-changer for modern business teams. With customizable templates and built-in data connections, Dokin allows modern CMOs and CFOs to streamlines data reporting across Google Workspace applications.

More Stories

Marketing Data
Productivity tips
Google Sheets
Growth Loops vs. AARRR Funnels: What’s the difference and How To Choose (2024)
Marketing Data
Marketing Mix Modeling - What is it and How To Use it
Marketing Data
Google Sheets
Search Ads vs. Display Ads: Which one is right for you?