Detect stale website content with OpenAI, Google Sheets, and Gmail
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 14 nodes and runs on a schedule (cron 0 7 * * 1). Along the way it connects OpenAI Chat Model, Google Sheets and Gmail.
How it runs
Trigger: On a schedule (cron 0 7 * * 1).
- Site Configuration (Edit Fields (Set)): sets 3 fields: sitemapUrl, staleDays, alertEmail
- Fetch Sitemap XML (HTTP Request): calls an HTTP API
- Parse Sitemap URLs (Code): runs custom JavaScript code
- Any Stale Pages? (If): checks a condition and branches into true / false
- Fetch Page Content (HTTP Request): calls an HTTP API
- Extract Page Text (HTML): parses or builds HTML
- AI Content Freshness Analyzer (AI Agent): runs an AI agent, with model: OpenAI Chat Model
- Build Report Row (Edit Fields (Set)): sets 4 fields: pageUrl, lastModified, daysSinceUpdate…
- Save to Content Audit Sheet (Google Sheets): append
- Combine Into One (Aggregate): combines items into one
…plus 2 more steps. See the full node list below.
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 (11)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - HTML
n8n-nodes-base.html - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Google Sheets
n8n-nodes-base.googleSheets - Gmail
n8n-nodes-base.gmail - Aggregate
n8n-nodes-base.aggregate
From the author
Stale Content Detector for Websites Who is this for Content marketers, SEO managers, and website owners who want to automatically find pages on their site that are outdated or need refreshing — without manually auditing every page. What it does This workflow…