Usage

1. Make a copy of this google sheet https://docs.google.com/spreadsheets/d/REPLACE_WITH_DOCUMENT_ID/edit?usp=sharing

2. Set your google service credentials and add these scopes https://www.googleapis.com/auth/webmasters, https://www.googleapis.com/auth/webmasters.readonly, https://www.googleapis.com/auth/adwords

3. Replace the domains with your desired domains

4. Understanding the Workflow:

• Nodes Overview: This workflow contains several nodes:

• Set your domain: Sets the domain to be used in the queries.

• Schedule Trigger: Starts the workflow based on a defined schedule.

• HttpRequest (query, page, date): Fetches data from Google's Search Console API using specified dimensions and dates.

• Split Out (x3): Splits the incoming JSON array into individual items for further processing.

• Edit Fields (x3): Maps the outgoing data to specified fields, preparing it for insertion into Google Sheets.

• Google Sheets (x3): Adds or updates entries in specified Google Sheets documents with the fetched data.

• Inputs and Outputs:

• Input: API response from Google Search Console regarding keywords, page data, and date data.

• Output: Entries written to Google Sheets containing keyword data, clicks, impressions, CTR, and positions.

2. Setup Instructions:

• Prerequisites:

• An n8n instance set up and running.

• Active Google Account with access to Google Search Console and Google Sheets.

• Google OAuth 2.0 credentials for API access.

• Step-by-Step Setup:

1. Open n8n and create a new workflow.
2. Add the nodes as described in the JSON.
3. Configure the Google OAuth2 credentials in n8n to enable API access.
4. Set your domain in the Set your domain node.
5. Customize the Google Sheets document URLs to your personal sheets.
6. Adjust the schedule in the Schedule Trigger node as per your requirements.
7. Save the workflow.

• Configuration Options:
• You can customize the date ranges in the body of the HttpRequest nodes.
• Adjust any fields in the Edit Fields nodes based on different data requirements.

3. Use Case Examples:

• Useful in tracking website performance over time using Search Console metrics.
• Ideal for digital marketers, SEO specialists, and web analytics professionals.
• Offers value in compiling performance reports for stakeholders or team reviews.

4. Running and Troubleshooting:

• Running the Workflow:

• Trigger the workflow manually or wait for the schedule to run it automatically.

• Monitoring Execution:

• Check the execution logs in n8n's dashboard to ensure all nodes complete successfully.

• Common Issues:

• Invalid OAuth credentials – ensure credentials are set up correctly.

• Incorrect Google Sheets URLs – double-check document links and permissions.

• Scheduling conflicts – make sure the schedule set does not overlap with other workflows.

Search console REPORTS

Purpose and structure

This folder contains the Search console REPORTS workflow. Its executable nodes use googleSheets, httpRequest, scheduleTrigger, set, splitOut. The table and connection map below are derived from the JSON, not an inferred guarantee of behavior.

Setup

Import inactive. Configure your own credentials and replace REPLACE_WITH_* values. Review external destinations and Code nodes before running.

Entry points

Schedule Trigger

Verification

Sanitized source candidate; not runtime-tested. This overview is generated from node metadata. Read the folder README for the connection map, credential types, and license.

Attribution

https://github.com/Zie619/n8n-workflows/blob/94007c1445d9258a7da116646b79473e7c7c3282/workflows/Splitout/0657_Splitout_Schedule_Update_Webhook.json MIT; preserve source notices.