Getting data into Google Sheets

Get Google Ads data into Google Sheets

Downloads, emailed reports, scripts, and a report that updates itself.

Last checked 25 Sep 2026

About the Google Ads connector

There are three free ways to get Google Ads data out of Google Ads, and only one of them updates a spreadsheet by itself, as long as you're happy with a bit of code. Fresh Sheets does it without.

1. Download a table

1. Open any statistics table in Google Ads: campaigns, ad groups, keywords and so on.
2. Click the download icon above the table.
3. Choose Google Sheets.

You get exactly what the table shows, once.

Source: Download data, Google Ads Help.

2. Scheduled reports by email

In Insights and reports, then Report editor, you can schedule a report to be emailed daily or weekly as a file, such as a CSV. Handy for an inbox, but it doesn't update a spreadsheet.

Source: Scheduling reports, Google Ads Help.

3. A Google Ads script

If you're comfortable with a bit of code, Google Ads scripts can write report data into a spreadsheet on a schedule.

1. In Google Ads, go to Tools, then Bulk actions, then Scripts, and click +.
2. Paste in a script, such as Google's own Ad Performance Report example, and click Authorize.
3. Preview it, run it, and set how often it runs: daily, weekly or monthly.

Scripts are free and flexible. They're also code, so when something changes, you're the one fixing it. Each run is limited to 30 minutes.

Sources: Google Ads scripts, Google Ads Help, and the Ad Performance Report solution, Google Ads scripts documentation.

4. A report that keeps itself current, with Fresh Sheets

Fresh Sheets writes a Google Ads report into a tab of its own and refreshes it on the schedule you choose.

1. Add Fresh Sheets and connect. Install Fresh Sheets from the Google Workspace Marketplace, open a spreadsheet, and choose Fresh Sheets, then Open sidebar. Click Connect this spreadsheet and sign in with your Google account.
2. Build the report. In the sidebar, choose Google Ads and pick the account. If you work through a manager account, you'll see the client accounts under it; each report reads one account. Choose a level: Account, Campaign, Ad Group, Ad or Keyword. Some columns are required at each level, including Cost, Clicks and Conversions, so those are ticked for you and can't be removed. Add anything else you need, such as Conversion value.
3. Choose the date range, the tab, and how often it refreshes.

If your date range includes any of the last seven days, each refresh re-reads them. Google Ads reports conversions against the date of the search that led to them, so recent days keep climbing for a while; re-reading them means your tab catches up instead of freezing whatever the numbers were first time round.

Cost is written as a plain number in your account's currency. There's no cost per conversion or average CPC field; divide Cost by Conversions or Clicks in Sheets, which the CPA guide covers.

Fresh Sheets replaces that tab's contents on every refresh, so keep your own formulas on another tab. Google doesn't offer a read-only permission for Google Ads, so the access you grant would allow changes. Fresh Sheets' code never makes any.

Source: how conversions are reported, Google Ads Help.

More on what Fresh Sheets reads from Google Ads is on the Google Ads connector page.