How to Automate Search Console to Sheets Reporting?
Description
Turn SEO data into a live report without manual exports. The workflow collects search queries, top pages, and daily results from Google Search Console and writes them into Google Sheets on a schedule. It is built for marketers and SEO teams that want fast, simple reporting they can share.
The schedule trigger starts the run, then a set node defines your domain and lookback days. Three HTTP requests pull query level, page level, and date level data from Search Console. Each response is split into single rows, mapped into clean fields like clicks, impressions, CTR, and position, and then pushed to three Google Sheets tables. You can switch domains by editing one value. The output is tidy, so it is easy to build charts and summaries.
You will need access to the Search Console property and a Google Sheet. Set the credentials in n8n for both Google Search Console and Google Sheets, adjust the date window, and pick your sheet. Expect weekly reports to refresh in minutes, not hours. This helps agencies, in house teams, and founders who need a simple view of traffic trends, winning pages, and keyword movement.
Tools Required
What this workflow does?
- Scheduled runs pull fresh Search Console data on your timeline.
- Simple domain and days input to control the site and date window.
- Three API calls fetch query, page, and date metrics with clicks, impressions, CTR, and position.
- Row splitting turns API arrays into single items ready for sheets.
- Field mapping standardizes the output for clean spreadsheets.
- Three Google Sheets updates write queries, pages, and dates to separate tables.
- OAuth credentials for Google services keep access secure and easy to manage.
What are the benefits?
- Reduce manual exports from 2 hours to 5 minutes per report
- Automate over 80 percent of SEO reporting work
- Improve data accuracy by removing copy and paste errors
- Unify queries, pages, and daily trends in one sheet
- Switch domains quickly by changing one input field
How to set this up?
- Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
- You'll need accounts with Google Search Console and Google Sheets. See the Tools Required section above for links to create accounts with these services.
- In the n8n credentials manager, create a Google OAuth2 credential for Search Console. Double click any Search Console HTTP Request node, choose Credential to connect with, click Create new credential, and follow the on screen steps. Make sure the webmasters scope is included.
- In the n8n credentials manager, create a Google Sheets OAuth2 credential. Open each Google Sheets node, choose Credential to connect with, click Create new credential, and complete the Google sign in.
- Make a copy of your reporting Google Sheet and note the spreadsheet ID and target sheet names or ranges. Paste the IDs and ranges into the three Google Sheets nodes.
- Open the Set your domain node and enter your domain as a Search Console domain property format, for example sc-domain:yourdomain.com, and set the days value for your date window.
- Open each HTTP Request node and confirm the date range makes sense for your report window. Adjust start and end dates if needed.
- Click Execute Node on each HTTP Request to verify you receive rows. If you see zero rows, check property access and date order.
- Run one Split Out node and confirm it outputs single items. Check the Edit Fields nodes to ensure clicks, impressions, CTR, and position map correctly.
- Execute each Google Sheets node and confirm new rows appear in the correct sheet tabs.
- Set the Schedule Trigger to your desired cadence, such as daily or weekly, and save the workflow.
- Troubleshoot common issues: ensure your Google account has access to the Search Console property, verify the spreadsheet ID and tab names, check API scopes, and confirm the date range is valid.
Need help or want to customize this?
Ask in the Free Futurise Community.
Similar Templates
These templates were sourced from publicly available materials across the web, including n8n’s official website, YouTube and public GitHub repositories. We have consolidated and categorized them for easy search and filtering, and supplemented them with links to integrations, step-by-step setup instructions, and personalized support in the Futurise community. Content in this library is provided for education, evaluation and internal use. Users are responsible for checking and complying with the license terms with the author of the templates before commercial use or redistribution.Where an original author was identified, attribution has been provided. Some templates did not include author information. If you know who created this template, please let us know so we can add the appropriate credit and reference link. If you are the author and would like this template removed from the library, email us at info@futurise.com and we will remove it promptly.
