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...
🔌 Nodes & Integrations Used (2)
📖 Implementation & Setup Guide
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
- Set your desired schedule
- Enter your desired domain
- 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.
- **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.
⚡ How to import this workflow into n8n:
- Click the Direct Download JSON button above to save
Export search console results to Google Sheets.json. - Log in to your n8n Cloud or self-hosted n8n instance.
- In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
- Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
- Click Execute Workflow to test and switch to Active!
Related General Automation Workflows
View All in General Automation →Generate Application Copy
Production-ready n8n automation template for Generate Application Copy built by AhiXLight. Seamlessly connects Execute Workflow Trigger, OpenAI with 4 configured nodes.
2-way sync Google Contacts and Notion
Sync your Google Contacts with your Notion database. You can filter contacts by label or sync all contacts. All contact information is kept in sync between G...
2D Image to 3D Model Automation
Production-ready n8n automation template for 2D Image to 3D Model Automation built by AhiXLight. Seamlessly connects HTTP Request, Google Sheets, Google Drive with 17 configured nodes.
2 way sync assignments completion between Canvas LMS and Notion
Syncs assignments and completion states to and fro between Canvas LMS and a Notion database. Automatically triggers every 2 hours during the schoolday by def...