Analyze website SEO and log AI recommendations to Google Sheets with OpenAI
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 11 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects OpenAI, Google Sheets, Slack and Gmail.
How it runs
Trigger: When an HTTP POST request hits its webhook URL.
- Workflow Configuration (Edit Fields (Set)): sets 2 fields: websiteUrl, analysisTimestamp
- Fetch Website HTML (HTTP Request): calls an HTTP API
- Extract SEO Elements (HTML): parses or builds HTML
- AI SEO Analysis (OpenAI): uses OpenAI
- Format AI Output (Edit Fields (Set)): sets 4 fields: aiAnalysis, websiteUrl, timestamp…
- Route by SEO Score (Switch): routes items into 2 branches
- Log to Google Sheets (Google Sheets): append or update
- Send Slack Alert (Slack): uses Slack
- Send Email Report (Gmail): uses Gmail
- Final Report Storage (Edit Fields (Set)): sets 2 fields: finalReport, reportId
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (9)
- Webhook
n8n-nodes-base.webhook - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - HTML
n8n-nodes-base.html - OpenAI
@n8n/n8n-nodes-langchain.openAi - Switch
n8n-nodes-base.switch - Google Sheets
n8n-nodes-base.googleSheets - Slack
n8n-nodes-base.slack - Gmail
n8n-nodes-base.gmail
From the author
Analyze website SEO issues and generate optimization actions with AI Author: Hyrum Hurst, AI Automation Engineer at QuarterSmart Contact: [email protected] This workflow provides a fully automated, AI-powered SEO analysis system designed to turn any…