Competitor Research Agent (n8n Automation Template)

Effortlessly generate competitor intelligence reports using AI

Built for marketers, founders, analysts, and B2B strategists — this automation scans public data, news, and websites to generate research reports without writing a single prompt manually.

✅ What This Automation Does:

• 🔍 Pulls competitor names & websites from a Google Sheet

• 📰 Uses Tavily API to fetch the latest company-related news (last 7 days)

• 🧠 Sends company data to Perplexity (LLaMA 3.1) for a full intelligence breakdown

• ✍️ Automatically formats it into a clean, structured report using AI

• 📄 Updates Google Sheet with the final output, fully hands-free

• 🗓️ Optionally runs every day at 8 AM via scheduler

📊 The Report Includes:

• Market Position

• Product Portfolio

• Pricing Strategy

• Corporate Updates

• Financial Status

• Growth Metrics

Each section is generated using real news, public data, and analysis prompts with GPT-style structure.

🧩 Tools Used:

• n8n (automation engine)

• Tavily API (real-time web search)

• Perplexity AI (Claude-style research prompt)

• OpenAI or LangChain formatting

• Google Sheets (report destination)

🧠 Who It’s For:

• B2B founders & CMOs

• Competitive intelligence researchers

• Marketing agencies & consultants

• Anyone doing manual competitor tracking

🔧 What You Need:

• Tavily API Key

• Perplexity API Key (or OpenRouter)

• Google Sheets account (OAuth2 connected in n8n)

• (Optional) OpenAI key for formatting

📦 What You Get:

• ✅ Ready-to-import .json automation file