Log weekly SEO technical audits with Google PageSpeed, Search Console, and Sheets

by Malik Shahzad Awan · 74 views · created 2026-08-02 · Market Research

What this workflow does

This workflow has 19 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects Google Sheets. It also calls googleapis.com and searchconsole.googleapis.com over HTTP.

How it runs

Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).

1. Set Website URL (Edit Fields (Set)): sets 1 field: websiteUrl
2. Fetch Page Sitemap (HTTP Request): calls an HTTP API
3. Fetch Post Sitemap (HTTP Request): calls an HTTP API
4. Parse Page Sitemap XML (XML): converts between XML and JSON
5. Parse Post Sitemap XML (XML): converts between XML and JSON
6. Merge: merges the data from its input branches
7. Extract URLs from Sitemaps (Code): runs custom JavaScript code
8. Fetch URL Status (HTTP Request): calls an HTTP API
9. Fetch PageSpeed Score (HTTP Request): calls googleapis.com
10. Inspect URL Indexing (HTTP Request): calls searchconsole.googleapis.com (POST)

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

Services it uses

Google Sheets

HTTP calls to: googleapis.com, searchconsole.googleapis.com

Before you upgrade to n8n 3.0

Nodes used (8)

• Manual Triggern8n-nodes-base.manualTrigger
• Edit Fields (Set)n8n-nodes-base.set
• HTTP Requestn8n-nodes-base.httpRequest
• Schedule Triggern8n-nodes-base.scheduleTrigger
• XMLn8n-nodes-base.xml
• Mergen8n-nodes-base.merge
• Coden8n-nodes-base.code
• Google Sheetsn8n-nodes-base.googleSheets

From the author

Quick overview This workflow runs manually or weekly to pull URLs from your site’s XML sitemaps, checks each URL’s HTTP status, Google PageSpeed Insights performance score, and Google Search Console indexing state, then appends the results to a Google Sheets…

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