How It Works

This automation pulls data directly from Google Search Console and exports it to Google Sheets. You’ll instantly have keyword, page, and performance metrics in one place—making it easier to track SEO progress, visualize trends, and run reports without logging into Search Console every time.

Setup & Use

1. Set your schedule – Choose how often the workflow should run (daily, weekly, etc.).

2. Enter your domain – Add the website you want to track.

3. Connect Google Sheets – Link your own sheet or duplicate the provided template.

 Inputs & Outputs

• Input: API data from Google Search Console (keywords, pages, dates).

• Output: Automatically updated Google Sheets with clicks, impressions, CTR, and position metrics.

Setup Instructions

Requirements:

• An active n8n instance

• Google account with access to Search Console + Sheets

• Valid Google OAuth2 credentials

Step-by-Step:

1. Open n8n and create a new workflow.

2. Import the provided nodes from the JSON.

3. Add your Google OAuth2 credentials for API access.

4. Insert your target domain in the domain node.

5. Replace the Google Sheets URLs with your own sheet.

6. Set your schedule trigger.

7. Save and run the workflow.

Customization Options:

• Adjust date ranges in the API request.

• Map additional fields for extended reporting.

• Integrate with Slack or dashboards for alerts.

💡 Use Cases

• Track SEO performance over time

• Automate client or team reports

• Monitor keyword rankings and CTR changes

• Save time vs. manual Search Console checks

Running & Troubleshooting

• Run Options: Test manually or let the schedule run automatically.

• Monitoring: Review execution logs in n8n to confirm success.

• Common Fixes:

  • Invalid credentials → recheck OAuth setup

  • Missing data → verify correct Google Sheets link and permissions

  • Scheduling issues → avoid overlaps with other automations

   

How to Import and Use Your n8n Template

1

Import in n8n

Open n8n → go to Workflows → Import from File → select the JSON file you received.

2

Connect Credentials

Open nodes marked with a warning, add your API keys (Shopify, Gmail, etc.), then Save and Execute.