Weekly SEO keyword opportunity report in Notion

By General Input

Every Monday morning, get a ranked Notion page of keywords your competitors rank for that you don't, prioritized by volume and CPC.

Integrations

  • Similarweb
  • Notion

Type

Agentic Task

Categories

  • Marketing

Build me an agent workflow that produces a weekly SEO keyword opportunity report in Notion.

Trigger: cron, every Monday at 7:00am in my local timezone.

Configurable inputs I want exposed on the workflow: my target domain (a single domain like example.com, lowercase, no www, no path), a list of 3 to 8 competitor domains in the same format, a 2-letter ISO country code (default us), a lookback window in months (default 3), and the Notion parent page ID of an existing page I will call "SEO Opportunities".

What the agent should do on each run, using Similarweb and Notion:

1. Call Similarweb "Organic Keyword Competitors (Desktop)" for my target domain to confirm the real organic competitor set. If the result overlaps with my configured competitor list, prioritize the intersection; otherwise still respect my configured list.

2. Call Similarweb "Website Keywords" for my target domain and for each competitor domain over the lookback window in the configured country. Capture keyword, position, traffic share, search volume, CPC, and SERP features for each row.

3. Compute the opportunity set. Two buckets: (a) gap keywords, where one or more competitors have meaningful traffic share and my domain does not appear or ranks below position 20, and (b) defensive keywords, where my traffic share for a keyword has clearly dropped versus the prior period. Bias toward mid-volume terms where competitors have real share. Discard implausible head terms (very high volume plus very high CPC plus dominant brand SERP).

4. For any borderline candidate the agent wants to validate, call Similarweb "Keywords Overview" to confirm volume, click distribution, competition density, and SERP composition before keeping it in the final list.

5. Rank the surviving opportunities by a simple score that rewards search volume and reasonable CPC and penalizes clearly transactional or brand-dominated SERPs. Keep the top 15.

6. Use Notion "Create a Page" to create a new page under my "SEO Opportunities" parent page. Title it like "SEO opportunities, week of {Mon DD YYYY}". The page body must be: a 4 to 6 sentence executive summary at the top (what changed this week, the strongest gap, the biggest defensive risk, a clear next action), then a heading "Top 15 opportunities", then a table with these columns in this order: Keyword, Monthly volume, Best competitor + their rank, My current rank or "not ranking", CPC, Recommendation (one sentence). Below the table add a short "Defensive watch" section listing up to 5 keywords where my traffic share slipped, with the prior and current share values.

Quality bar: do not propose head terms with implausible difficulty, never recommend a keyword you did not validate with Keywords Overview when it was borderline, and keep every recommendation to a single concrete sentence ("publish a comparison page targeting X", "refresh the existing blog post on Y", etc.). If a Similarweb call returns no data or a credit error, note that inline in the executive summary instead of failing the whole run.

Related prompts

Explore more prompts
Screen chartered vessels for AIS gaps and sanctions red flagsCompare candidate store locations with drive time trade areasBrowse every competitor ad and build a Notion swipe fileAudience persona studio for brand and product marketersArtwork desk for the Notion posts still missing an imageShare of voice dashboard for your brand and competitorsInfluencer campaign roster board with AI creator briefsSmart home entity health cockpit for Home AssistantOpen model approval desk for your production AI stackBid board that watches every procurement portal for you