How to Build a No-Code AI Competitive Intelligence System

TL;DR: You can build an automated competitive intelligence system in an afternoon using Make.com ($10-19/mo), Perplexity AI ($5/1K search requests), and Google Sheets (free). The system monitors your competitors’ websites, product launches, pricing changes, and press coverage — then delivers a structured weekly briefing to your inbox. Total cost: $15-25/month for most teams. [1][2]

---

Why You Need Automated Competitive Intelligence

Most businesses do competitive research the same way: a frantic Google search before a quarterly review, a few saved bookmarks that never get read, and the occasional alert from a competitor’s product launch that you find out about from a customer.

This reactive approach misses what matters: subtle positioning changes, pricing adjustments, new features rolling out to segments of their user base, and shifts in their messaging that signal a strategic pivot.

A 2025 survey by Crayon found that companies with dedicated competitive intelligence programs are 2.3x more likely to achieve revenue targets, but only 35% of small-to-mid-size businesses have any formal CI process at all. [3] The barrier isn’t willingness — it’s time and resources.

That’s where no-code AI automation changes the game. A Make.com workflow wired to Perplexity’s search API can do what a junior analyst would spend 4-5 hours per week on, in about 15 minutes, for less than $25/month in tooling costs.

What You’ll Build

Here’s the system at a glance:

Competitor List (Sheet) → Scheduled Trigger → Perplexity Research → AI Analysis → Briefing (Sheets + Email)

The workflow runs weekly and covers four research areas per competitor:

1. Website changes — New pages, updated messaging, pricing shifts
2. Product/feature launches — New releases, beta programs, deprecations
3. Press and media coverage — News articles, analyst mentions, reviews
4. Social signals — Key posts from leadership, hiring patterns, funding news

Results land in a structured Google Sheet and a formatted email briefing.

Tools You’ll Need

Tool	Role	Cost	Setup time
Make.com	Workflow orchestration, scheduling, data routing	Free (1K ops/mo) or Core ($10.59/mo)	Already running
Perplexity API	Real-time web research with citations	$5/1K search requests (Search API) or Sonar model token pricing	10 min
Google Sheets	Structured storage and dashboard	Free	5 min
Gmail (or any email)	Delivery of the briefing	Free	Already configured

Make.com is the right choice here because its visual scheduler, HTTP modules, and email integration handle the full pipeline without needing to manage a server. Perplexity’s Search API returns synthesized answers with real citations, which is more useful for competitive research than raw search results or a general-purpose LLM that may hallucinate competitors’ features. [2]

Step 1: Set up your competitor tracking sheet

Create a Google Sheet with two tabs:

Tab 1: Competitors

Column	Example	Purpose
name	Acme Corp	Display name
website	https://acme.com	Primary domain for research
twitter	@acmecorp	Leadership social accounts
crunchbase	https://crunchbase.com/org/acme	Funding and news
last_checked	2026-07-01	Track when you last researched
notes		Manual notes overlay

Tab 2: Intelligence Log

Column	Example
date	2026-07-08
competitor	Acme Corp
category	Product launch
summary	Announced AI-powered reporting module in beta
source_url	https://acme.com/blog/ai-reporting
impact	Medium
action_item	Evaluate for our roadmap

Fill in 3-5 competitors to start. Even one competitor is useful — the system scales horizontally by just adding rows.

Step 2: Get your Perplexity API key

1. Go to perplexity.ai/settings/api and create an account.
2. Navigate to the API section and generate a new API key.
3. Choose the Search API ($5/1K requests) for raw research with citations, or the Sonar Pro model ($5/M input tokens) if you want deeper synthesis. For competitive intelligence, the Search API is more cost-effective — each search returns curated results with source links. [2]
4. Add $10-20 in credits. At one research pass per competitor per week, $10 lasts roughly 4-6 months.

Step 3: Build the Make.com workflow

Create a new scenario in Make.com and set up the following modules:

3a: Schedule trigger

Add a Schedule module set to run weekly (Monday at 8:00 AM). For testing, set it to every hour temporarily — you can change it back once the workflow is verified.

3b: Read competitor list from Google Sheets

Add a Google Sheets > Search Rows module. Connect your sheet and select Tab 1. This pulls your competitor list into the workflow.

Use an Iterator module to process each competitor one at a time — Make runs the downstream modules once per row.

3c: Research module — Perplexity Search API

Add an HTTP > Make a Request module with these settings:

• Method: POST
• URL: https://api.perplexity.ai/search/query
• Headers:
  • Authorization: Bearer {{apiKey}} (store the key in Make’s variable system)
  • Content-Type: application/json
• Body (JSON):

{
  "query": "What's new at {{competitor.name}} in the last 7 days? Look for: product launches, pricing changes, new features, partnerships, leadership changes, funding news. Provide specific details with source URLs.",
  "max_results": 8
}

Why Perplexity over a standard LLM call: A general-purpose model like GPT-4o will sometimes fabricate competitors’ product announcements. Perplexity’s Search API grounds every claim in a real source URL. For competitive intelligence, accuracy matters more than eloquence — a hallucinated feature launch could send your team in the wrong direction for weeks. [2]

3d: Parse and structure the response

Add a Tools > Parse JSON module to extract the response. Perplexity returns structured results with answer, citations, and source_urls.

Then add an OpenAI / Claude AI module (or Make’s built-in AI > Text Generator) to categorize the findings:

Template prompt:

Analyze this competitive intelligence data about {{competitor.name}}:

{{perplexityResponse.answer}}

Return a JSON array of findings. Each finding needs:
- category: one of ["product_launch", "pricing", "positioning", "partnership", "leadership", "funding", "other"]
- summary: one sentence describing what happened
- source_url: the URL where this was found
- impact: one of ["high", "medium", "low"]
- action_item: one sentence on what we should do about it

3e: Log to Google Sheets

Add a Google Sheets > Add Row module connected to Tab 2 (Intelligence Log). Map the AI output fields to the columns.

For each finding returned by the AI, a new row is added.

3f: Build the weekly briefing email

After all competitors are processed, add an Email > Send an Email module (Gmail or SMTP).

Use an Aggregator module to collect all intelligence findings into a single formatted email body:

Subject: Competitive Intelligence Briefing — {{date}}

Summary: {{totalFindings}} new developments tracked across {{competitorCount}} competitors.

High Impact Items:
{{#each findings where impact="high"}}
• [{{competitor}}] {{summary}} — {{action_item}}
{{/each}}

All Findings:
{{#each findings}}
• [{{impact}}] [{{category}}] {{competitor}}: {{summary}}
  Source: {{source_url}}
{{/each}}

Send it to yourself and your leadership team.

Step 4: Test and refine

Run the scenario manually from Make. Expect these teething issues:

• Too generic — Narrow the Perplexity query. Instead of “what’s new at Acme Corp,” try “Acme Corp product changes pricing updates [month] 2026.” Specific dates produce specific answers.
• Missing a competitor — Add more context in the query: “Acme Corp (formerly AcmeSoft, Series B, 200 employees, B2B SaaS in the analytics space).” The more context, the better the AI understands what’s relevant.
• Too many noise findings — Tighten the categorization prompt. Add a relevance field and filter to only log items with relevance > 6/10.

After 2-3 runs, you’ll have a tuned system that surfaces genuinely useful intelligence.

Cost Breakdown

Component	Cost	Notes
Make.com Core	$10.59/mo	10K operations — this workflow uses ~50 ops/run
Perplexity Search API	~$0.50-1.00/mo	5 competitors × 1 search/week = ~20 searches/mo
Google Sheets	Free
Gmail	Free
Total	~$12/mo	Less than one hour of a junior analyst’s time

At scale (20+ competitors), bump Make to Pro ($18.82/mo) for more operations, and Perplexity costs stay under $5/mo. [1][2]

Going further

Once the basic system is running, add these upgrades:

• Slack notifications — Replace the email module with a Slack webhook for real-time alerts on high-impact items. Add a Filter module before Slack that only fires when impact = "high".
• Monthly trends dashboard — Add a scheduled workflow that reads the Intelligence Log, aggregates by competitor and category over the last 30 days, and writes a summary row to a Trends tab.
• Multi-language monitoring — If competitors operate in different markets, add a per-competitor language field to your sheet and pass it to Perplexity as a query parameter.
• Competitor landing page monitoring — Use Perplexity’s ability to retrieve specific URLs. Once a week, have the workflow check each competitor’s pricing page and blog for substantive changes, using the last_checked timestamp as a reference.

The bottom line

Competitive intelligence doesn’t require a dedicated analyst or expensive software. A Make.com workflow with Perplexity’s grounded search API does what most teams pay $500+/month for — automated, structured, cited competitive monitoring — for about $12/month and an afternoon of setup.

The key insight: don’t try to build a perfect system on day one. Start with three competitors, a simple query, and a Google Sheet. Run it for two weeks, see what surfaces, then refine. The compound value of 52 weekly briefings a year — instead of zero — transforms how your team makes product and positioning decisions.

---

References

[1] Make.com Pricing Plans. Core plan $10.59/month, Pro plan $18.82/month. make.com/en/pricing

[2] Perplexity API Pricing — Search API at $5 per 1,000 requests, Sonar model pricing at $0.20-$15 per million tokens. docs.perplexity.ai/docs/getting-started/pricing

[3] Crayon Competitive Intelligence ROI Report. Companies with dedicated CI programs are 2.3x more likely to hit revenue targets. crayon.co/resources/reports/competitive-intelligence-roi

[4] n8n Competitive Research Workflow Template — Alternative approach using n8n and Perplexity. n8n.io/workflows

📖 Related Reads

• ToolBrain — tool reviews, LLM comparisons, and AI workflow guides
• NiteAgent — AI agent development, frameworks, and production patterns

Cross-links automatically generated from NoCode Insider.