Daily SEO keyword rank tracker with biggest movers report
Every weekday at 7am, see which keywords climbed, which slipped, and which competitors broke into the top 5, delivered as a short written report.
ScrapingBee
Google Sheets
GmailMarketingAI ReportsDaily DigestsResearch & MonitoringEvery weekday at 7am, run an SEO keyword rank tracker that reports the biggest movers for our domain and emails the report to our marketing distribution list.
Step 1. Read the tracked keyword list from Google Sheets using Get Values. The sheet has a tab called 'keywords' with one keyword per row in column A. Our domain is stored in cell B1 of the same tab.
Step 2. For each keyword, call the ScrapingBee Google Search operation to pull the top 10 organic results as structured JSON. Find the position of our domain in the results, or record 'not in top 20' if it does not appear. Also capture the URLs in positions 1 through 5 so we can detect new competitors.
Step 3. Append a new row to the 'history' tab in the same spreadsheet using Append Values, with today's date, the keyword, our domain's position, and the current top 5 URLs.
Step 4. Read yesterday's rows from the 'history' tab with Get Values and compare. For each keyword, identify whether our position moved up or down by 3 or more, and which URLs in the top 5 are new compared to yesterday.
Step 5. Write a short narrative report (a few paragraphs, not a raw table) covering top gains, top losses, notable new competitor URLs that broke into the top 5, and any keywords where our domain dropped out of the top 20 entirely. Keep the tone factual and concise.
Step 6. Send the report via Gmail (Send a Message) to our marketing distribution list with a subject line like 'SEO rank report for {date}, X gains and Y losses'.
If a keyword has no prior history row (for example, it was added yesterday), skip the comparison for that keyword and just note that it is newly tracked.
What does this prompt do?
- Reads your tracked keyword list from a Google Sheet every weekday at 7am and looks up where your domain ranks in Google for each one.
- Logs the daily position for every keyword to a history tab so you keep a record of where you started and where you ended up.
- Calls out the biggest movers, climbs and drops of three or more positions, plus any keyword where you fell out of the top 20 entirely.
- Spots new competitor URLs that broke into the top 5 since yesterday so you know who is suddenly taking your space.
- Writes a short narrative report covering top gains, top losses, and notable new competitors, and emails it to your marketing distribution list.
What do I need to use this?
- A Google account with a sheet that holds the keywords you want to track and a second tab for the daily history log.
- A ScrapingBee account, used to pull the top 10 Google results for each keyword.
- A Gmail account that can send the daily report to your marketing distribution list.
How can I customize it?
- Change the schedule, send it daily, three times a week, or only on Mondays, instead of every weekday at 7am.
- Adjust the movement threshold, for example flag changes of five or more positions instead of three.
- Swap the recipient list or send the report to a Slack channel instead of email.
FAQs
Where does the list of keywords come from?
Which search engine does this check?
Will it work if my domain is not in the top 10?
Can I track more than one domain?
How do I change who receives the email?
Related templates
Stage a batch of filings overnight, then approve each completed form from a screenshot before anything is ever submitted.
Review every conversation Fin closed as resolved, judge which ones actually stuck, and see what the gap is worth against your bill.
Work every return, damage and warranty claim in one queue, with the order, the delivery date and a policy-backed recommendation already on screen.
See who is due, build a week of dinners on demand, swap anything you do not like, then send the recipe and grocery links yourself.
See every install this week day by day, with the crew, the homeowner, whether materials were ordered, and the latest jobsite photos.
See exactly which ingredients next week needs based on what you actually sold, adjust anything by hand, then build a one-click grocery cart.
Stop refreshing rank trackers every morning.
Connect Google Sheets, ScrapingBee, and Gmail once, and Geni emails you the day's biggest SEO movers before standup.