Automating Competitor Analysis with n8n + AI | Weekly Insights for Product Managers

Description

🧠 Description - Discover how to automate weekly competitor analysis using n8n and AI. In this demo, I showcase a workflow that: - Analyzes competitors’ websites automatically - Extracts and summarizes key insights on market position, product portfolio, and pricing strategy - Updates a shared Google Sheet with fresh data every week - Sends results directly to product managers’ inboxes 🔧 Built with: n8n, OpenAI/Gemini LLM, Google Sheets, Outlook automation 📅 Trigger: Weekly via n8n Schedule ============================================================= ⏰ Timecodes ⏰ 0:00 Result of the AI Agent workflow execution (Google Sheet) 2:49 E-Mail sent with the execution result (Google Sheet) 3:05 Schedule trigger (n8n) 3:38 Workflow overview (n8n) 4:03 AI Agent - Prompt & System message (n8n) 4:54 Using ChatGPT to design prompt and system message (n8n) 8:32 Connecting to LLM (n8n) 9:20 Memory 9:37 Google Sheet tools - Update and GET (n8n) 12:12 E-Mail and Workflow execution (n8n) 13:10 Next steps #n8n #AIautomation #ProductManagement #CompetitorAnalysis #nocode #AIAgents