Detect stale website content with OpenAI, Google Sheets, and Gmail
n8n14 modulesv1.0Stale 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 fetches your sitemap, identifies pages that have not been updated in a configurable number of days, fetches each stale page, and uses AI to assess whether the content is actually outdated or still accurate. - Sitemap parsing: Fetches your si
At a glance
Detect stale website content with OpenAI, Google Sheets, and Gmail is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Gmail, Slack, Google Sheets, Webflow. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- Gmail, Slack, Google Sheets, Webflow, OpenAI, WordPress
- Modules
- 14
- Price
- Free
- Version
- v1.0
About this workflow
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 fetches your sitemap, identifies pages that have not been updated in a configurable number of days, fetches each stale page, and uses AI to assess whether the content is actually outdated or still accurate. - Sitemap parsing: Fetches your sitemap.xml and extracts all URLs with their last-modified dates - Staleness filtering: Flags pages not updated in more than X days (default: 180) and sorts by most stale first - Page content extraction: Fetches each stale page and extracts the title and body text - AI freshness analysis: An OpenAI-powered agent reviews each page and rates it LOW, MEDIUM, HIGH, or CRITICAL with specific update suggestions - Audit logging: Saves every reviewed page to a Google Sheet with the full AI analysis - HTML email report: Builds a color-coded summary email showing each flagged page with its AI verdict and sends one consolidated digest How to set up 1. Open Site Configuration and set your sitemapUrl, staleDays (default: 180), and alertEmail 2. Create a Google Sheet with a ContentAudit tab (columns: scandate, pageurl, lastmodified, dayssinceupdate, aireview) 3. Paste your Google Sheet URL into the Save to Content Audit Sheet node 4. Connect your Gmail OAuth2 credentials on the Email Content Audit Report node 5. Connect your Google Sheets credentials 6. Connect your OpenAI API credentials on the OpenAI Chat Model node 7. Activate — runs every Monday at 7 AM Requirements - n8n account (cloud or self-hosted) - A website with a sitemap.xml (most CMS platforms generate one automatically) - OpenAI API key (uses gpt-4o-mini) - Gmail account with OAuth2 - Google Sheets How to customize - Change the staleDays threshold in Site Configuration (default: 180 days / 6 months) - Increase the page limit above 20 in the Code node for larger sites - Add specific URL path filters to focus on blog posts, docs, or landing pages only - Replace Gmail with Slack for faster team notifications - Connect to your CMS API (WordPress, Ghost, Webflow) to pull content directly instead of scraping
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n → click the menu → Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 5
Click Execute Workflow to test, then activate.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
Related N8n workflows
Fetch Facebook Ad Account insights and update Google Sheets rows accordingly
Post images and text from Google Drive and Sheets to LinkedIn
Transcribe audio files from Google Drive using OpenAI Whisper and send an email
Send Slack message when user unsubscribes
Qualify WhatsApp insurance leads with OpenAI, HubSpot, and Slack
Send messages to Slack using a ChatGPT assistant response from a custom webhook
Generate Images on Telegram 🤖🖼️ from Text and Voice using Grok Imagine & Kie AI
Gmail AI Email Manager
Reviews
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
- JSON blueprint — instant download
- Setup guide PDF included
- 5 downloads · valid 30 days
- Works with n8n
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you