With Sheetgo, you can connect Google Search Console directly to Google Sheets using the Search Console API and retrieve search performance data through GET requests. This allows you to automatically extract metrics such as clicks, impressions, CTR, average position, queries, pages, and country-level performance into a spreadsheet. Instead of manually exporting reports from Search Console, Sheetgo automates data retrieval using secure OAuth 2.0 authentication and scheduled refreshes. This ensures SEO and marketing teams always have up-to-date organic search data inside Google Sheets for reporting and optimization.
Prerequisites
A verified website property in Google Search Console
A Google Cloud Project
Google Cloud Console: https://console.cloud.google.com/
Google Search Console API documentation: https://developers.google.com/webmaster-tools
Google OAuth 2.0 documentation: https://developers.google.com/identity/protocols/oauth2
Enabled Search Console API in your Google Cloud project
OAuth 2.0 Client ID and Client Secret
A Refresh Token generated via OAuth consent flow
Your verified Search Console Property URL (URL-encoded when used in requests)
A Sheetgo account using the same Google account connected to Search Console
Step 1: Identify the Required API Endpoint
Google Search Console provides endpoints to retrieve site information and search performance data. The base endpoint is
https://searchconsole.googleapis.com/webmasters/v3/
To list verified sites, use
https://searchconsole.googleapis.com/webmasters/v3/sites
Refer to the documentation linked in the Prerequisites to confirm supported parameters and reporting options.
Step 2: Generate API Credentials
Google Search Console uses OAuth 2.0 authentication. Log in to Google Cloud Console and enable the Search Console 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 in Sheetgo.
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 full GET request URL into the Request URL field, such as https://searchconsole.googleapis.com/webmasters/v3/sites. For property-specific data, include your URL-encoded site address in the endpoint. Then open the Headers section and insert the following JSON configuration:
{
"Authorization": "Bearer YOUR_ACCESS_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": "startRow",
"per_page_param": "rowLimit"
}
}
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 such as query, clicks, impressions, CTR, and average position. If necessary, add a Filter by Condition processor before selecting the destination to refine your dataset. Confirm the sheet tab where the Search Console 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 your Search Console data and populate your Google Sheet. Configure scheduled refreshes to keep your SEO 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.