Hey guys - I built this really cool SEO Ranking Agent and thought this community would like it. Feel free to take it and customize it however you like. Below is a quick run-down of what it does.
What it does every Monday at 7am:
- Reads your keywords from a Google Sheet.
- Checks where you rank for each one on Google, using DataForSEO.
- Logs the result to a History tab and updates each keyword's last and best position.
- Flags keywords that dropped, sit in positions 4–15, are outside the top 15, or where Google shows a different page than the one you want.
- For the worst flagged keywords, fetches your page and the competitor page ranking above it. Claude then writes specific fixes: a new title, a new meta description, headings to add, missing subtopics and internal links. These go into an Actions tab with a priority.
- Posts a Slack summary: what climbed, what slipped, what's new on page one, and what to fix first. If a run crashes, it sends a separate Slack alert.