Weekly Competitor Intelligence Report to Notion with Perplexity
An n8n workflow that runs each week, asks Perplexity what your named competitors have shipped, priced, hired or announced, and files a cited intelligence report as a new page in Notion — turning scattered competitor stalking into a clean, dated archive your team can trust.
- 1
Run weekly
A
Schedule Triggerset toWeekson Monday at hour7gives you a fresh report to open with your coffee. ASetnode holds your competitor list as an array. - 2
Loop the competitors
An
Item Listsnode splits the array so each competitor is researched separately. Per-competitor calls keep each answer focused and the citations relevant to that specific company. - 3
Research each with Perplexity
An
HTTP Requesttosonar-proasks: 'What has [competitor] announced, launched, priced, or hired for in the last 7 days? Bullet points, cite sources, say none if nothing.' The live-web search means you catch this week's moves, not last year's. - 4
Combine into one report
An
Item Lists(aggregate) orCodenode stitches the per-competitor answers into a single markdown report with a section per company and a combined sources list. This is the body of the Notion page. - 5
Create the Notion page
A
Notionnode creates a page titledCompetitor Report — {{date}}in your intel database, with the combined markdown as content. Over time you build a timeline of the whole competitive landscape, fully cited.
Frequently asked questions
How many competitors can I track?
Practically as many as you like — the workflow loops a list you define. But quality beats quantity: 3–5 direct competitors with a focused prompt yields a sharp report, while twenty produces a shallow one. Keep the list in a Set node or a small Notion database you can edit anytime.
Won't the report repeat the same facts every week?
The prompt asks Perplexity specifically for developments in the last 7 days, so it focuses on what changed. To reinforce this, the workflow can pass the previous week's summary as context and instruct the model to only report genuinely new items — avoiding déjà-vu reports.
Why Notion rather than email?
Because competitor intel is most valuable as a searchable, dated archive. In Notion each weekly report is a page you can tag, link to deals, and look back through months later to spot a competitor's trajectory. Email buries it; Notion compounds it. You can still add an email or Slack ping on top.
Turn Every New YouTube Upload into an Email Newsletter Automatically
An n8n workflow that detects each new YouTube video, has Claude write a short, click-worthy email around it, and sends the campaign through your newsletter tool — so your subscribers hear about every upload the moment it goes live, with zero manual writing.
Free recipe
Auto-Optimize YouTube Video Descriptions and Tags for SEO with AI
An n8n workflow that reads each new video's transcript, has Claude write an SEO-optimized description, timestamped chapters and keyword tags, and saves the package to Google Sheets for a quick paste into YouTube Studio — turning throwaway descriptions into a search-traffic engine.
Free recipeAutomatically Log Daily YouTube Analytics to Google Sheets
An n8n workflow that pulls yesterday's views, watch time and subscriber change from the YouTube Analytics API every morning and appends them to a Google Sheet — giving creators a growing dashboard of channel performance without ever opening YouTube Studio.