Site content analysis via sitemap using OpenAI: HTML…

This workflow automates the process of fetching and analyzing website content by parsing the sitemap extracted from robots.txt, then processing page text with OpenAI. The results are delivered as structured HTML reports, saved to Google Sheets, or emailed. It’s ideal for fast content audits without manually reviewing hundreds of pages.

## Who it´s for
- SEO specialists conducting site audits
- Marketers gathering competitor content data
- Developers automating sitemap parsing
- Website owners seeking content analytics

## What the automation does
- Starts via webhook or manual trigger with a website URL
- Extracts sitemap from robots.txt and parses XML
- Filters and deduplicates URLs
- Sequentially fetches content from each page
- Processes text using OpenAI (e.g., quality, topic, uniqueness assessment)
- Converts results into HTML and JSON formats
- Delivers output via HTTP response, Google Sheets, or email

## What´s included
- Ready-to-use n8n workflow
- Trigger logic (webhook, manual start)
- Integrations with HTTP API, OpenAI, XML parser, Google Sheets API
- Basic setup and adaptation guide

## Requirements for setup
- n8n account with workflow editing access
- OpenAI API key
- Google Sheets access (for data storage)
- Gmail access (if email delivery is used)
- Public access to target site’s robots.txt and sitemap

## Benefits and outcomes
- Saves time during large-scale content analysis
- Standardized report format
- Enables comparison across multiple sites
- Automatic duplicate URL removal
- Flexible output options: interface, spreadsheet, or email
- Supports multilingual analysis via OpenAI

## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via Telegram: @gleb923.