Data extraction and reporting from Google Search Console to Google Sheets

• Automate SEO reporting for website performance metrics
• Track keyword performance over time using Google Search Console data
• Generate periodic reports for stakeholders on search traffic trends

Schedule trigger initiates the workflow at defined intervals Set the domain and date range for data extraction Fetch query, page, and date reports from Google Search Console Split the incoming data for individual processing Edit fields to prepare data for Google Sheets Append or update the data in specified Google Sheets

1. 1
   Import the workflow template into your n8n instance
2. 2
   Configure Google OAuth credentials for Google Sheets and Search Console
3. 3
   Set your domain and desired date range in the 'Set your domain' node
4. 4
   Adjust the schedule in the 'Schedule Trigger' node as needed
5. 5
   Save and activate the workflow to start data extraction