Search API Connector Documentation


Import Google Ads Data to Google Sheets


In this guide, we’ll walk through how to pull Google Ads / AdWords API data data directly into Google Sheets, using the API Connector add-on for Sheets. Google provides a free add-on for Google Ads here, so you can give that one a try if you’d prefer not to work with the API directly.

If you’re still here, let’s go! We’ll get started digging into the Google Ads API, including campaign performance and keyword ideas.


Before You Begin

Click here to install the API Connector add-on from the Google Marketplace.

Part 1: Connect to the Google Ads API

If you haven’t connected API Connector to Google Ads before, you’ll first need to initiate the connection as follows:

  1. Open up Google Sheets and click Extensions > API Connector > Manage Connections.
  2. In the list of available connections, find “Google Ads” and click Connect.
  3. You will be directed to and asked to allow API Connector to manage your AdWords campaigns:
  4. You’ll then be returned to your Google Sheet, and can verify that your Google Ads connection is active in the Connections screen.

Part 2: Create Your Google Ads API Request

For our first request, we’ll pull in ads performance metrics from your account.

  1. First, get your account ID as we’ll need this for subsequent requests. You can get your account ID from the login menu or the top navigation bar in your Google Ads account.

    (see this note if you’re accessing a client account through a manager account)

  2. Next, create your request URL. The Google Ads API is accessed by sending POST requests to the following API Request URL, substituting in your own account ID where it says 2668258503 (don’t include the dashes from your account ID).
  3. Finally, create your POST body. All the details of the request, e.g. metrics, dimensions, filters, and so on, are specified in the POST body. We’ll start with an example that gets key data about your campaigns.
    {"query": " SELECT, campaign_budget.amount_micros, campaign.status, campaign.optimization_score, campaign.advertising_channel_type, metrics.clicks, metrics.impressions, metrics.ctr, metrics.average_cpc, metrics.cost_micros,metrics.conversions,campaign.bidding_strategy_type FROM campaign WHERE DURING LAST_7_DAYS AND campaign.status != 'REMOVED' " }

Part 3: Pull Google Ads API Data into Sheets

We can now enter our values into API Connector.

  1. In API Connector, click Create, choose POST from the dropdown menu, and paste in the Request URL we created above.
  2. Under OAuth, choose Google Ads from the dropdown menu.
  3. Under headers enter Key = content-type, Value = application/json
  4. In the POST Body section, paste in the POST body we created above.
  5. Create a new tab and click Set current to use that tab as your data destination.
  6. Under Output Options, choose grid or compact report style (this makes the output easier to read).
  7. Click Edit Fields and set your column order.
  8. Name your request and click Run. A moment later you’ll see ad performance data populate your sheet.
The Google Ads API sends cost data as “costMicros”. Divide it by one million using a formula like =J1/1000000 to see costs in the standard xxx.xx currency format. If you’re familiar with array formulas, you can apply that formula to the entire column in one go with a function like =arrayformula(if(J2:J<>"",J2:J/1000000,""))

Part 4: More Example API Requests

The Google Ads API provides a lot of different data points and functionality. The cool thing about working with the API directly is that you can access a very wide range of data points, but it requires some digging. I’ve tried to summarize the most useful request types in these examples, but for more complete information, please check the full documentation linked below.

You can use API Connector’s API Library (just search for “Google Ads” while in the add-on) to easily pull up most of these sample requests.

Account summary by day

{"query": "SELECT,metrics.clicks, metrics.impressions, metrics.ctr, metrics.average_cpc, metrics.cost_micros,metrics.conversions FROM customer WHERE DURING LAST_30_DAYS" }

List of keywords used by your account

"query": "SELECT ad_group_criterion.keyword.text FROM ad_group_criterion WHERE ad_group_criterion.type = 'KEYWORD' AND ad_group_criterion.status ='ENABLED'"

Generate keyword ideas (like Google Ads Keyword Planner)

seeded by keyword

Request method

Choose POST from the dropdown menu

Request URL

Substitute in your own customer ID where it says 2668258503

Request body


Substitute in your own seed keyword where it says “hello”

Field Editor

Since the JSON response returns a lot of extra monthly data by default, click Edit Fields and select just the following metrics: keywordIdeaMetrics.competition, keywordIdeaMetrics.avgMonthlySearches, keywordIdeaMetrics.competitionIndex, keywordIdeaMetrics.lowTopOfPageBidMicros, and keywordIdeaMetrics.highTopOfPageBidMicros.


The output will look like this. In my tests the keywords and bid amounts exactly match the output within the Google Ads keyword planner tool, while the search volumes have more precision, e.g. where Keyword Planner says Avg. Monthly Searches = 1K – 10K, the API gives a number like 2400.

seeded by URL

To seed with a URL instead, change the POST body to your URL, like this:


As above, click Edit Fields and select these metrics: keywordIdeaMetrics.competition, keywordIdeaMetrics.avgMonthlySearches, keywordIdeaMetrics.competitionIndex, keywordIdeaMetrics.lowTopOfPageBidMicros, and keywordIdeaMetrics.highTopOfPageBidMicros

Part 5: Notes

  • If your access to a customer account is through a manager account, you must include an extra header where Key = login-customer-id, Value = the customer ID of the manager account (info).
  • This integration enables the following scope, which gives Google Sheets read/write access to Google Ads/AdWords:

Part 6: API Documentation

Previous Import GitHub Data to Google Sheets
Next Import Google Analytics Data to Google Sheets

20 thoughts on “Import Google Ads Data to Google Sheets”

  1. Good morning, I’m new to API Connector so sorry if it is a simple question. There is a way to retrieve data from google ADS (from keyword planner tool)? I’d like to import into Google sheet the average monthly search for a list of keywords. I’m able to connect into Google ads but i don’t understand how to query this tool. Thanks to anyone want help me 🙂

    • Haha, this definitely isn’t a simple question. It took me a while to figure it out myself, but I’ve now added in an example of how to get data from the Keyword Planner Tool (search this page for “generate keyword ideas” if you don’t see it). Hopefully that will get you what you’re looking for 🙂

  2. Can you give an example of adding location to this –

    {"keywords": ["hello"]}

  3. Hi,

    I have tried to get data from my google ads account to google sheets following your instruction. I did not find a section post body to attach body string into it.

  4. Hi, Can I combine data from 2 resources with your api connector ?

    Ex: I wanna get data from gender resource and campaign resource presenting on the same tab

    • Generally, each API request will send data to a separate tab. If you want to combine them, I suggest first pulling in your data, then creating a summary tab that uses Sheets functions like VLOOKUP and QUERY to pull data into a summary tab.

  5. Hi there, what settings should i make if i’d like to utilise my google sheet as a data warehouse? For example, i’d like pull key historical data and continue adding newer daily data.

    Do i enable timestamp and append settings?

    Thanks in advance

    • Hey Joey, you can first grab your historical data by including Google’s date in your response, like this:
      {"query": "SELECT,metrics.clicks, metrics.impressions, metrics.ctr, metrics.average_cpc, metrics.cost_micros,metrics.conversions FROM customer WHERE > '2020-01-01' AND < '2021-08-10'" }

      Then you can switch to append mode and add in a dynamic date into your sheet, e.g. =today()-1, and use that value in your request URL. Each day your date value will automatically update, and you can schedule your request to run and fetch the updated data, so it automatically appends itself to the end of your sheet. There's an example of what I mean in this article: (check the section called "Example: dynamic dates"). Let me know if that makes sense or you have follow-up questions.

  6. Hello! I’m connecting the api to pull data from my client’s Good ads account (for youtube) but everytime I run the query it gives an error that I need permission and need to update the login-customer-id.

    I took the account ID and set it up as the login-customer-id but it didn’t work.

    I’m a manager in that account.

    Please can you guide me where can I get the correct login-customer-id?

    Is it the client’s personal account ID?


  7. Hi Ana,

    Thanks for your amazing work! Would it be possible to start the keyword planner API from a cell input? I would like to start the keyword planner output based on a keyword you give in a certain cell. In your example you used the fixed example with ‘hello world’ but probably this could change to cell value

  8. Is it possible to instead of creating a single query for the entirety of the accounts associated with my manager account? I am trying to perform an automatic query of all my managed accounts, instead of manually generating a sheet through the google ads GUI

    • Sure, you’d just list your request URLs one after the other, like this:

      Then the request will cycle through and run the same query (as defined in the request body) for each account ID.

      If you don’t know all your account IDs you can first get them with a request URL of


Leave a Comment

Table of Contents