Find competitor content gaps from sitemaps with Bright Data, GPT-5.6 and Slack
Quick overview Compares your site with a competitor by crawling both sitemap trees through Bright Data, finds topic words in their URL slugs that never appear in yours, has GPT-5.6 rate the top gaps, then writes them to Sheets, Slack and the form page.
How it works Receives a form submission with your domain and a competitor domain. Uses Bright Data Web Unlocker to fetch each site’s robots.txt, extracts declared sitemap URLs (or falls back to common sitemap paths), and validates responses as real XML. Recursively crawls sitemap indexes to collect page URLs, skipping non-content and localized sitemap branches and stopping at the configured depth and per-site limits. Compares the two sites by tokenizing URL slugs into topic words and ranks words that appear across many competitor URLs but none of yours. Fetches a limited number of example competitor articles for the top gaps via Bright Data, extracts a title and opening text, and compiles a brief. Sends the brief to OpenAI GPT-5.6 to summarize each gap’s angle and rate whether it is worth covering. Appends one row per rated gap to Google Sheets, posts a formatted summary to a Slack channel, and shows the results as an HTML table in the form completion page.
Setup Create a Bright Data Web Unlocker zone and add it as an HTTP Header Auth credential, then set the matching zone name in the workflow settings. Add credentials for OpenAI (Chat model), Google Sheets, and Slack. Update the Google Sheets document URL/ID and ensure a tab named "gaps" exists (or change the target tab setting to your sheet name). Set the Slack channel name in the settings (for example, #content) and ensure the workflow has permission to post there. Open the form trigger, copy its public URL, and share it with whoever should submit domains for comparison.
Related Templates
AI Weather Forecasts with MCP Integration
Real-time Weather Forecasts with MCP Tools This n8n workflow demonstrates how to integrate real-time weather intelligen...
Google Sheets UI for n8n Workflow
Google Sheets UI for Workflow Control This n8n template provides a practical and efficient way to manage your n8n workf...
Demo Workflow - How to use workflowStaticData()
This workflow demonstrates how to use the workflowStaticData() function to set any type of variable that will persist wi...
🔒 Please log in to import templates to n8n and favorite templates
Workflow Visualization
Loading...
Preparing workflow renderer
Comments (0)
Login to post comments