Overview
This n8n node allows you to query Google Search Console's Search Analytics data for a specific website and date range. It is useful for automating the extraction of search performance metrics (such as clicks, impressions, CTR, and position) for SEO analysis, reporting, or integration with other tools. For example, you could use this node to regularly pull search analytics data into a spreadsheet, dashboard, or trigger further workflows based on search trends.
Properties
| Name | Type | Meaning |
|---|---|---|
| Authentication | options | Selects the authentication method: Service Account or OAuth2. |
| Site URL | string | The full URL of the site to extract data from (e.g., https://blog.ikhuerta.com/). |
| Start Date | string | The start date for the data extraction in YYYY-MM-DD format. |
| End Date | string | The end date for the data extraction in YYYY-MM-DD format. |
Output
The node outputs a JSON array containing the results of the Search Analytics query. Each item typically includes fields such as:
- clicks: Number of clicks received.
- impressions: Number of times the site appeared in search results.
- ctr: Click-through rate.
- position: Average position in search results.
- keys/dimensions: The page URL(s) for which the data applies.
Note: The exact structure depends on the response from the Google Search Console API for the "searchAnalytics.query" endpoint with the "page" dimension.
Dependencies
- Google Search Console API: Requires access to the Google Search Console property for the specified site.
- Authentication: You must configure either a Google Service Account credential or an OAuth2 credential in n8n.
- For Service Account: Ensure the service account has access to the Search Console property.
- For OAuth2: The connected Google account must have access to the Search Console property.
Troubleshooting
Common Issues:
- Invalid Credentials: If credentials are not set up correctly, authentication will fail. Double-check your Service Account permissions or OAuth2 setup.
- Site Not Verified: The specified Site URL must be verified in your Google Search Console account.
- Date Format Errors: Dates must be in YYYY-MM-DD format; otherwise, the API may return errors.
- No Data Returned: If there is no data for the selected date range or site, the output array may be empty.
Error Messages:
"User does not have sufficient permission": Ensure the authenticated user/service account has access to the specified site."Requested entity was not found": Check that the Site URL is correct and matches exactly what is registered in Search Console."Invalid 'startDate' or 'endDate'": Verify the date formats and logical order (startDate should not be after endDate).