Weekly SEO Keyword-Gap Report

Each week this workflow crawls a defined list of competitor domains, harvests the search queries and topics their top pages rank for, and diffs that corpus against your own site's keyword footprint. Anything your competitors cover that you don't becomes a "gap." An LLM scores each gap by estimated intent value and topical adjacency to what you already rank for, then writes a clean, prioritized brief — keyword, the competitor URL that owns it, suggested page type, and a one-line angle — and drops it as a dated doc in a shared Google Drive folder your content team already watches.

Use it when you own a content or SEO program and want a standing, no-touch source of net-new topic ideas instead of paying for a manual audit every quarter. It fits teams that publish on a weekly cadence and need a Monday-morning queue of vetted opportunities. It is especially useful in competitive categories where rivals ship content fast and gaps open and close week to week — the recurring schedule keeps your editorial backlog honest without anyone running a tool by hand.

A weekly schedule trigger kicks off the run. Exa performs semantic and keyword search across your configured competitor domains plus your own site, pulling the queries and page topics each ranks for. OpenAI receives both keyword sets, computes the set difference, and ranks the gaps by intent and relevance — discarding branded or off-topic noise — then formats a Markdown brief. The finished report is written to a dated file in Google Drive, where the content team picks up the highest-priority gaps for the week. Swap the competitor list, scoring rubric, or destination folder by editing the trigger and the OpenAI prompt; no other changes are required.