BB SEO Writer: Article Crawling → AI-Optimized Report Generation → Performance Tracking in Google Sheets

Problem:

An SEO team needed to audit existing articles, generate AI-optimized improvement reports, and track performance metrics, doing this manually meant crawling pages by hand, writing recommendations without data context, and maintaining separate spreadsheets with no consistent structure or automation.

Solution:

Built a form-triggered n8n three-section SEO pipeline, the Crawl Article section fetches article content via API, polls for completion status with a 5-second wait loop, converts the content from HTML to Markdown for clean processing, and merges with a set key for identification; the Generate Optimized Report section passes the crawled content to an OpenAI create_report model that produces an AI-optimized improvement report, cleans the HTML output, converts it to base64, saves it as an HTML file, and uploads it to Google Drive; the Generate and Save Performance Report section searches Google Drive for the performance folder, checks if a tracking sheet exists and creates one if not, retrieves article performance data via query, and inserts the metrics into the correct Google Sheets tab.

Result:

Delivered a fully automated SEO audit pipeline that crawls any article on demand, generates a structured AI optimization report saved to Google Drive, and logs all performance data to a persistent Google Sheets tracker, replacing hours of manual auditing with a single form submission.