Automate SEO reporting with Search Console, GA4 and Sheets

Most SEO reports are the same two numbers stitched together by hand: where you rank, and how much organic traffic that ranking is worth. This template does the stitching. On a schedule, it queries Search Console for query and page-level ranking data, pulls GA4's organic session and conversion figures for the same window, and appends both into a Google Sheet that the rest of the team can read without ever opening either platform.

Why it made the cut

It is from n8n's own official workflow library, which means one-click import and a maintained node set behind Search Console and GA4, rather than a forum post you have to reverse-engineer. Search Console and GA4 are the two data sources every organic report actually needs, so this template covers the ground floor rather than a niche extra. It is a sound base to extend with a client-facing dashboard or a Slack summary once the raw feed is flowing.

How to run it

1. Open the template on the n8n workflows page below and import it into your instance in one click.
2. Connect your Google account for Search Console and GA4 through n8n's OAuth credential flow.
3. Point the workflow at your property and GA4 data stream, and set the destination Sheet.
4. Set the schedule trigger (daily or weekly) and activate.

Worth knowing

Templates like this drift when Google changes an API response shape or a scope requirement, so test a manual run before trusting the schedule. It writes raw rows to a Sheet; charting, filtering by branded versus non-branded queries, and any client formatting are left to you. Google's own API quotas apply, so a very large property may need the date range narrowed.