Export search console results to Google Sheets

How it works

This workflow gets the search console results data and exports this to google sheets. This makes it easier to visualize and do other SEO related tasks and activities without having to log into Search Console

Setup and use

1. Set your desired schedule 2. Enter your desired domain 3. Connect to your Google sheets or make a copy of this sheet.

Detailed Setup

- 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.