Automate detection and refresh of stale website content using OpenAI, Google Sheets, and Gmail.
Parses the sitemap to enumerate URLs and last-modified dates. Flags pages not updated beyond the configured threshold and collects content for review. Logs results in Google Sheets and sends a color-coded Gmail digest to stakeholders.
A complete end-to-end workflow that detects stale content, analyzes accuracy, and reports clear updates.
Parse sitemap to extract URLs and last-modified dates.
Filter pages by the staleDays threshold.
Fetch each stale page and extract title and body text.
Analyze freshness with OpenAI and assign a verdict (LOW, MEDIUM, HIGH, CRITICAL) plus update suggestions.
Log results to Google Sheets with the full AI analysis.
Build and send a color-coded HTML email report via Gmail with all flagged pages.
Before adopting the agent, teams struggle with manual audits, scattered data, and delayed updates. After adoption, stale pages are automatically detected, AI-suggested updates are provided, and data is centralized with automated reporting.
A simple 3-step process that non-technical users can follow.
Parse sitemap to collect all URLs and their last-modified dates.
Filter pages by the configured staleDays and fetch each stale page's content for review.
Run OpenAI freshness analysis, log results to Google Sheets, and send a color-coded Gmail digest.
A realistic scenario showing weekly automation on a mid-sized site.
Scenario: A site with 350 pages is scanned every Monday at 7:00 AM. The agent parses the sitemap, identifies pages older than 180 days, fetches content for each, and uses OpenAI to score freshness. Results are logged to the ContentAudit Google Sheet and a color-coded HTML Gmail digest is sent to the marketing team. Outcome: 72 pages flagged with concrete update recommendations and owners assigned for remediation.
One supporting sentence.
Identify outdated pages and plan refreshes based on AI verdict.
Prioritize updates by impact score and last-modified date.
Maintain accuracy to protect brand and user trust.
Coordinate updates with content calendars and campaigns.
Align audits with topics and quarterly plans.
Scale audits across multiple domains and CMSs.
Connects OpenAI, Google Sheets, and Gmail to automate the workflow.
Analyzes page content and assigns AI freshness verdict and concrete update suggestions.
Logs each reviewed page and the full AI analysis for traceability.
Sends a consolidated HTML digest to recipients.
One supporting sentence with practical scenarios for operation.
One supporting sentence with practical concerns addressed.
Stale is defined by pages not updated within the configured staleDays threshold. The AI freshness score helps distinguish actual outdated content from pages that remain accurate. The workflow fetches content and compares it to current data to determine relevance. It flags pages that require review and updates, and those that are still valid with notes for future checks.
Yes. You can adjust the staleDays threshold in Site Configuration. The change applies to the next audit run and can be overridden for specific sections or topics. This enables tailoring to campaigns or product launch windows.
The agent uses sitemap.xml to enumerate URLs and will fetch each page listed there. You can apply URL filters to focus on blog posts, docs, or landing pages. Pages outside the sitemap are not included in the automated audit.
OpenAI analyzes page content against typical freshness cues and your domain context. It outputs a verdict (LOW, MEDIUM, HIGH, CRITICAL) and provides concrete update actions. Suggestions are designed to be actionable for editors and content teams.
Audit data is stored in Google Sheets linked to your Content Audit tab. Configuration details stay in your integration layer, and the agent logs are accessible to authorized users. Data remains within your connected accounts unless exported.
Yes. Notification channels can be swapped by reconfiguring integrations. Slack or other messaging tools can replace Gmail for reporting updates. You can still keep a consolidated digest as a post in the channel.
The agent supports pagination and higher page limits in the code node. For very large sites, you can run more frequent cycles or segment audits by section. You can also increase the page limit to accommodate more pages per run, balancing performance and accuracy.
Automate detection and refresh of stale website content using OpenAI, Google Sheets, and Gmail.
