Six months ago I was spending 15 hours a week on keyword research, gap analysis, and content planning. Now the agent does it, and I spend 45 minutes reviewing what it found.

The agent is named Kai. It's a Claude AI running on a cron job that fires every Sunday at 6 AM. Here's what it actually does:

1. Hits the Google Search Console API with my domain and pulls impression/click/position data for the past month 2. Cross-references with my content calendar (a spreadsheet I maintain) 3. Runs DataForSEO queries on keywords where I'm ranking 4-8 (low-hanging fruit territory) 4. Audits my existing content for keyword gaps and opportunities 5. Spits out a report with ranked recommendations ordered by potential impact

The whole thing runs in about 8 minutes. Costs me $0.80 per run in API fees. Would cost me a full workday if I did it manually.

Why I built it

The original friction point: I'd sit down Friday afternoon with the best intentions to do keyword research, get three tabs deep into SEMrush or Semrush, and lose 4 hours to the rabbit hole. I'd find great opportunities but never act on them. The data would sit. It was friction at the moment of action.

An agent removes that friction by doing the part that bores me (API calls, data compilation, cross-referencing) and leaving only the part that requires judgment (should I actually write about this, and how would I angle it).

The stack