Automated Google Search Console Data Reporter - n8n Workflow

• SEO Specialists and Digital Marketers needing regular performance reports.


• Analysts who require centralized Search Console data for dashboarding.


• Users looking for advanced examples of parallel processing within an n8n workflow.


• Teams seeking reliable n8n templates for data aggregation and reporting.

Maintaining a comprehensive log of website search performance is crucial for optimization, yet manual data extraction from Google Search Console is time-consuming. This specialized n8n workflow solves this by providing a reliable, automated reporting solution. This n8n template runs on a defined schedule, fetching three distinct data sets—keyword queries, page URLs, and daily performance aggregates—from the Google API. By utilizing several key n8n node types for processing and formatting, the workflow ensures that the messy API JSON output is perfectly structured before being appended to corresponding sheets in a designated Google Sheets document. This powerful automation turns a complex monthly chore into a seamless background task running entirely within n8n.

This powerful n8n workflow begins execution using the Schedule Trigger n8n trigger node, which allows for daily, weekly, or monthly execution.

1. Configuration: The flow first hits the Set your domain n8n node, where the target domain (e.g., funautomations.io) and the number of reporting days (30 days in the default setup) are defined. These variables are then used in the API calls.


2. Parallel Data Fetching: The workflow immediately splits into three parallel paths. Each path uses an HTTP Request n8n node to contact the Google Search Console API. They request data categorized by query (keywords), page (URLs), and date (daily performance).


3. Data Structuring: Upon receiving the raw JSON API response, each path uses a Split Out n8n node to handle the array of results, ensuring each row is processed individually. Following this, an Edit Fields (Set) n8n node is crucial. This n8n node maps the dynamic Search Console data (e.g., keys[0]) to standardized output fields like Keyword, clicks, impressions, ctr, and position.


4. Final Reporting: Finally, three separate Google Sheets n8n node instances (one for Queries, one for Pages, and one for Dates) use the Append or Update operation to insert the newly structured performance data into the appropriate tab of the designated Google Sheets document. This reliable data flow ensures continuous monitoring of SEO performance using this highly effective n8n template.

To deploy and run this robust n8n workflow successfully, follow these steps:

1. Import: Copy the provided JSON data and import it into your self-hosted or cloud n8n instance.


2. Google Sheets Setup: Create a copy of the reference Google Sheet (URL provided in the Sticky Note) or ensure your target spreadsheet contains the necessary tabs ('Query', 'PAGES', 'Dates') with columns matching the expected output (Keyword/Page/Date, clicks, impressions, ctr, position).


3. Credential Setup (Google Sheets): Configure a Google Sheets OAuth2 API credential in n8n and link it to the three final Google Sheets n8n node instances. Ensure this credential has permission to write to the designated spreadsheet.


4. Credential Setup (Search Console API): Configure a Google OAuth2 API credential specifically for the Search Console HTTP Request n8n node instances. This requires setting the appropriate scopes, including https://www.googleapis.com/auth/webmasters.


5. Configure Domain: Locate the Set your domain n8n node and replace the placeholder domain (funautomations.io) with the verified domain property you wish to report on.


6. Activate: Save and activate the n8n workflow. The Schedule Trigger n8n trigger will initiate the report based on its set interval.

Schedule Trigger: This n8n trigger node initiates the automation process on a scheduled basis, making it a reliable, set-and-forget reporting tool.
Set your domain (Set n8n node): A configuration n8n node used to dynamically define the target domain and the data range in days (e.g., 30 days) for all subsequent API requests. This centralizes key parameters for the n8n template.
Get query Report / Get Page Report / date (HTTP Request n8n node): Three parallel instances fetching performance data from the Google Search Console API. They utilize Google OAuth2 credentials and specify dimensions (query, page, or date) in the JSON request body.
Split Out n8n node (x3): Essential for handling API responses. It takes the array of data rows and separates them, allowing downstream n8n nodes to process each record individually.
Edit Fields (Set n8n node) (x3): Performs critical data mapping. It standardizes the data structure, mapping the primary dimension key (Keyword, Page, or Date) and ensuring all metrics (clicks, impressions, ctr, position) are correctly typed and named for consistent insertion into the Google Sheets n8n node.
Update queries to Sheets / Update Pages to Sheets / Update date report to sheets (Google Sheets n8n node): The final action n8n nodes. They connect to a single Google Sheets document and perform an Append or Update operation, writing the processed Search Console metrics into separate, dedicated tabs, completing the n8n workflow.