Templates / Export search console results to Google Sheets

Export search console results to Google Sheets

Ready for 3.0

by Zacharia Kimotho ✓ · 36,439 views · created 2024-12-07 · Market Research

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What this workflow does

This workflow has 14 nodes and runs on a schedule (every day). Along the way it connects Google Sheets.

How it runs

Trigger: On a schedule (every day).

  1. Set your domain (Edit Fields (Set)): sets 2 fields: domain, days
  2. Get query Report (HTTP Request): calls an HTTP API (POST)
  3. Get Page Report (HTTP Request): calls an HTTP API (POST)
  4. date (HTTP Request): calls an HTTP API (POST)
  5. Split Out: splits a list into separate items
  6. Split Out: splits a list into separate items
  7. Split Out: splits a list into separate items
  8. Edit Fields (Edit Fields (Set)): sets 5 fields: Keyword, clicks, impressions…
  9. Edit Fields (Edit Fields (Set)): sets 5 fields: page, clicks, impressions…
  10. Edit Fields (Edit Fields (Set)): sets 5 fields: date, clicks, impressions…

…plus 3 more steps. See the full node list below.

Services it uses

Google Sheets

Before you upgrade to n8n 3.0

Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.

Nodes used (5)

From the author

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…

Excerpt from Zacharia Kimotho's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.