Skip to main content
Run your queries with GAQL Fetcher

And populate Google Sheets with Google Ads data

Wijnand Meijer avatar
Written by Wijnand Meijer
Updated over a week ago

Introduction

Use the GAQL Fetcher add-on to run GAQL queries and fetch data for Google Ads accounts quickly. Follow these steps to get it done.

Using the Add-On

  1. Open the add-on
    ​

  2. Fill in the template with your GAQL queries and the account(s) you want to run it for
    ​

  3. Open the GAQL Fetcher to access the "Run" buttons
    ​

  4. If multiple columns are enabled, choose between "Run all" (dark blue arrow) or running columns one by one (light blue arrows)

    1. Start with "Run all" for faster execution

    2. If the 45-second timeout limit is exceeded (see troubleshooting), run the columns one by one
      ​

View results

If everything works as expected, new sheets will be created using the name(s) from row 3, containing the data fetched for the account(s) in row 4 (and beyond) and the GAQL query in row 2

Important: Existing sheets with the same name will be overwritten.

The Refresh button

Use the Refresh button to update the list of reports on the right side of the menu.

Press it whenever you add or remove reports in the sheet to make sure an up-to-date view of all available reports.

Did this answer your question?