This n8n workflow automates the process of extracting AI-generated content overviews from a webhook, analyzing website pages for SEO improvements, and storing the insights into Google Sheets. It is designed to enhance content strategy and SEO performance by leveraging AI models and automated data handling.
The workflow begins with a webhook receiving structured data, including HTML content, sources, and search queries. This data is processed, converted into Markdown, and stored in Google Sheets for easy reference. Scheduled triggers automate regular URL analysis, where URLs listed in Google Sheets are fetched and processed in batches.
For each URL, the workflow extracts the page title and H1 tags, fetches full page content, and converts it from HTML to Markdown. It then generates AI-based SEO recommendations using the Gemini 2.5 Pro language model, based on the page’s content and AI overviews. These insights are stored back into Google Sheets, providing actionable guidelines to improve SEO and content quality.
This workflow is particularly useful for digital marketers, SEO specialists, and content managers who want to automate content audits, gather AI-driven SEO insights, and continuously optimize their website’s performance without manual intervention.
Reviews
There are no reviews yet.