This n8n workflow automates the process of extracting content from multiple websites listed in a Google Sheet, analyzing each site’s data with OpenAI, and updating the sheet with summarized insights. Starting with a manual trigger, it reads URLs from Google Sheets, fetches website HTML, extracts the content, cleans and shortens the text, and sends it to OpenAI for analysis. The AI generates a value proposition, industry, target audience, and market classification for each site. The results are merged, parsed, and then stored back into Google Sheets, providing an efficient way to gather and organize website insights at scale. This workflow is ideal for market research, competitive analysis, or content aggregation tasks.