Automated Multi-Agent Competitor Analysis Report System - n8n Workflow

Market Researchers: Individuals needing frequent, structured competitive analysis without manual data compilation.
Product Managers: Teams requiring synthesized market reports to inform strategic decisions.
n8n Automation Engineers: Users seeking advanced examples of multi-step AI agents and data aggregation within an n8n workflow.
Business Intelligence Analysts: Professionals looking to leverage external data scraping tools (like Apify) directly within an n8n node sequence.

Manually gathering competitive data, aggregating it, and synthesizing actionable reports is time-consuming and prone to human error. This advanced n8n workflow solves this by creating a fully automated, agent-based system.

The process begins with data extraction via Apify, cleanses the data using a custom code n8n node, and then passes the output through two specialized AI agents powered by the OpenAI n8n node (LangChain integration). The first agent acts as 'The Strategic Analyst' to find key insights, and the second, 'The Report Generator,' structures this information into a professional document. The final report is saved to Google Docs and instantly announced to the team via Slack. This n8n workflow showcases the power of integrating diverse services into seamless, high-value automated processes.

This automation is initiated by a manual n8n trigger, making it ideal for on-demand execution:

1. Trigger and Data Extraction: The n8n workflow starts with the manual 'Execute workflow' n8n trigger. This immediately calls the Apify API using an HTTP Request n8n node to initiate web scraping and retrieve relevant competitor data.


2. Data Aggregation: The raw JSON data from Apify is routed through a Code n8n node ('Data Aggregation'). This essential step cleans, filters, and formats the data payload, preparing it for AI consumption.


3. Strategic Analysis: The prepared data is fed into the first specialized AI agent, 'The Strategic Analyst' (an OpenAI LangChain n8n node). This agent's prompt guides it to perform deep competitor analysis, identify SWOT factors, or determine market positioning.


4. Report Generation: The analysis from the first agent moves to the second OpenAI LangChain n8n node, 'The Report Generator.' This agent structures the analytical output into a cohesive, readable report document structure.


5. Document Creation: The final synthesized text is sent to the Google Docs n8n node ('Create Report'), which automatically generates a new document and inserts the AI-generated report content.


6. Team Notification: Finally, the Slack n8n node ('Deliver Report to Team') notifies the relevant team channel with a link to the newly created Google Doc, ensuring immediate access to the intelligence provided by this robust n8n workflow.

To deploy this powerful n8n workflow, follow these steps:

1. Import: Copy the provided JSON data and import it directly into your n8n instance using the 'New' -> 'Import from JSON' option.


2. Credentials Setup:

1. Customization: Review the Code n8n node for any necessary data structure adjustments based on the exact Apify output. Customize the system prompts within the two OpenAI LangChain n8n node configurations to refine the analysis and reporting style for your specific industry. This n8n template is highly flexible.

This n8n workflow utilizes several advanced and core n8n node types:

When clicking ‘Execute workflow’ (Manual Trigger): The starting n8n trigger. This node allows the user to run the entire sequence on demand with a single click, perfect for generating periodic reports.
Apify (HTTP Request n8n node): Acts as the data input source, calling an external Apify crawler or actor to retrieve fresh web-scraped data, which is crucial input for the analysis agents in the n8n workflow.
Data Aggregation (Code n8n node): Essential for transforming and cleaning the raw Apify output. It structures the data payload into a format easily consumable by the subsequent AI agents.
The Strategic Analyst (OpenAI LangChain n8n node): The first layer of AI intelligence. This n8n node is configured with a strategic system prompt (likely using GPT-4) to analyze the market data and extract critical insights.
The Report Generator (OpenAI LangChain n8n node): The second AI agent. It takes the output from the Strategic Analyst and performs the final task: formatting the raw insights into a polished, executive-ready report structure.
Create Report (Google Docs n8n node): Handles the final documentation output, using the content generated by the AI to create a permanent record in Google Docs, leveraging the built-in file handling capabilities of n8n.

• Deliver Report to Team (Slack n8n node): The final action, using Slack to provide real-time notification and links, completing the continuous delivery loop of this effective n8n workflow.