With Sheetgo, you can connect your Google Ads account directly to Google Sheets using the Google Ads API and retrieve campaign performance data via GET requests. This allows you to automatically extract metrics such as impressions, clicks, cost, conversions, campaign performance, ad group data, and keyword statistics into a spreadsheet. Instead of manually exporting reports from Google Ads, Sheetgo automates the data retrieval process using secure OAuth 2.0 authentication and scheduled refreshes. This ensures marketing teams always work with up-to-date advertising data inside Google Sheets.
Prerequisites
A Google Ads account with API access enabled
A Google Cloud Project
Google Cloud Console: https://console.cloud.google.com/
Google Ads API documentation: https://developers.google.com/google-ads/api/docs/start
Google Ads Query Language (GAQL) documentation: https://developers.google.com/google-ads/api/docs/query/overview
Google OAuth 2.0 documentation: https://developers.google.com/identity/protocols/oauth2
OAuth 2.0 Client ID and Client Secret
A Refresh Token generated via OAuth consent flow
A Google Ads Developer Token (from Google Ads API Center)
Your Google Ads Customer ID (without dashes)
A Sheetgo account using the same Google account connected to Google Ads
Step 1: Identify the Required API Endpoint
Google Ads reporting is performed using the search endpoint, which supports GET requests with query parameters. The endpoint structure is :
https://googleads.googleapis.com/v16/customers/CUSTOMER_ID/googleAds:search
Replace CUSTOMER_ID with your Google Ads account ID without dashes. For GET requests, the GAQL query must be included as a query parameter in the URL.
For example:
https://googleads.googleapis.com/v16/customers/1234567890/googleAds:search?query=SELECT campaign.name,metrics.impressions,metrics.clicks,metrics.cost_micros FROM campaign WHERE segments.date DURING LAST_30_DAYS
Refer to the Google Ads API and GAQL documentation linked in the Prerequisites to define the correct metrics and reporting structure for your needs.
Step 2: Generate API Credentials
Google Ads uses OAuth 2.0 authentication. Log in to Google Cloud Console and enable the Google Ads API in your project. Navigate to APIs & Services → Credentials and create an OAuth 2.0 Client ID. Configure the OAuth consent screen if required. After generating your Client ID and Client Secret, complete the OAuth authorization flow described in the documentation linked in the Prerequisites to generate an Access Token and Refresh Token. Access tokens expire approximately every hour, so the Refresh Token is required to maintain automation. You must also generate a Developer Token from the Google Ads API Center inside your Google Ads account.
Step 3: Open the Sheetgo API Connector
Log in to Sheetgo and open an existing workflow or create a new one. Click on Connect and choose API Request under Data Source. Then select HTTP Request as the method type. You’ll be prompted to enter the API URL and configure authentication and headers.
Step 4: Configure the API Request in Sheetgo
Log in to Sheetgo and create a new workflow. Select HTTP Request as your source and choose the GET method. Paste your request URL into the Request URL field, Then open the Headers section and insert the following JSON configuration:
{
"Authorization": "Bearer YOUR_ACCESS_TOKEN",
"developer-token": "YOUR_DEVELOPER_TOKEN",
"Content-Type": "application/json",
"@auth": {
"auth_method": "oauth2",
"auth_type": "Bearer",
"refresh_url": "https://oauth2.googleapis.com/token",
"refresh_params": {
"client_id": "YOUR_CLIENT_ID",
"client_secret": "YOUR_CLIENT_SECRET",
"refresh_token": "YOUR_REFRESH_TOKEN",
"grant_type": "refresh_token"
}
},
"@pagination": {
"type": "page",
"page_param": "page",
"per_page_param": "pageSize"
}
}Replace all placeholder values with your actual credentials. If the API response nests data under a results key, you may define a data root using the @flags parameter with data_root set to results.
Step 5: Choose the Destination Spreadsheet
After configuring the API request, click Next in Sheetgo. Choose Google Sheets as your destination. You may select an existing spreadsheet or create a new one. Sheetgo will automatically structure the JSON response into columns. If necessary, add a Filter by Condition processor before selecting the destination to refine your dataset. Confirm the sheet tab where the Google Ads data will be stored.
Step 6: Execute the Sheetgo Connection
Click Finish and Save to activate the workflow. Run the connection to test the integration. Sheetgo will retrieve campaign performance data and populate your Google Sheet. Configure scheduled refreshes to keep your advertising data updated automatically. Since OAuth refresh tokens are included in the header configuration, Sheetgo will automatically request new access tokens when required, ensuring continuous synchronization with Google Sheets.