Export Google Search Console Data to Sheets

This n8n workflow fetches performance data from Google Search Console via API, including keywords, pages, clicks, impressions, CTR, and average positions, then exports it directly to a Google Sheets document. It runs on a customizable schedule, allowing users to set their domain and date ranges for targeted queries. The workflow handles data formatting through edit fields nodes to ensure clean, spreadsheet-ready output.

Key benefits include time savings by eliminating manual data exports from Search Console, enabling real-time SEO monitoring, trend analysis, and report generation. It's ideal for digital marketers, SEO specialists, and web analysts who need to track site performance over time without repetitive logins or complex scripting.

Use cases: Generate weekly SEO reports for stakeholders, monitor keyword rankings and traffic shifts, integrate with other tools for deeper analytics, or automate performance dashboards. Prerequisites include n8n setup, Google OAuth credentials for Search Console and Sheets access. Customize sheets URL, domain, and schedule for seamless operation.