Daily Google brand reputation watcher with AI Overview alerts

Build a deterministic code workflow that monitors how Google ranks our branded queries every weekday morning. The trigger is a cron, Monday through Friday at 7am US Eastern. There is no input payload; the workflow reads everything it needs from a Google Sheet.

Step 1. Read the query list from Google Sheets using Get Values. The source sheet has one row per branded query and contains four kinds of terms: our company name, our executives' names, our product names, and our flagship feature names. The spreadsheet id and the range (for example Queries!A2:B) should be configured at the top of the workflow so a non-technical owner can edit the sheet without touching the workflow. Each row also carries a label column so we can group the alert output later.

Step 2. For every query in that list, call Real-Time Web Search Search with num=10, fetch_ai_overviews=true, and gl=us, hl=en. Capture, for each query: the ordered list of result domains for the top 10 organic results, a boolean for whether an AI Overview was returned, and the full AI Overview text body when present. Handle the response envelope of { status, request_id, data } and read results from data. If a single query errors, log it and keep going so one bad query does not block the rest of the run.

Step 3. Append one snapshot row per query to a separate ledger sheet using Google Sheets Append Values. The ledger columns are: run_date (ISO date in ET), query, label, top_10_domains (comma-separated, in rank order), ai_overview_present (true/false), and ai_overview_text (the full body, or empty). This sheet is the audit trail and the source of truth for tomorrow's diff.

Step 4. Before appending, read the ledger to pull yesterday's snapshot rows (the most recent run_date strictly before today) using Get Values. For each query in today's run, compare against yesterday's row for the same query and detect three change types: (a) a domain that is in today's top 10 but was not in yesterday's, (b) a domain that was in yesterday's top 10 but is not in today's, and (c) a material change to the AI Overview text. Treat a material AI Overview change as either present-to-absent, absent-to-present, or a normalized text similarity below roughly 0.85 (case-folded, whitespace-collapsed) so cosmetic edits do not trigger alerts.

Step 5. If at least one query produced a change, post exactly one Slack message via Send a Message to a configured channel. The message should be a single grouped digest, not one message per query. Format it with a short header ("Brand SERP changes for {today}"), then a section per changed query showing: the query and label, new domains added to page 1 with the rank they entered at, domains that dropped off, and a one-line note about the AI Overview change with a short before/after excerpt if applicable. If no query changed, do not post anything. The channel id should be a workflow config value.

Constraints. Keep the flow strictly deterministic: discrete nodes, no agent reasoning. All thresholds (similarity cutoff for AI Overview changes, top N, schedule) should be named constants at the top of the workflow so they are obvious to tune. This is a reputation and PR monitoring workflow for branded queries, deliberately separate from commercial SEO keyword rank trackers. The value is catching a new domain on page 1, a domain dropping off, or an AI Overview narrative shift for terms where our brand is the subject of the search.

Additional information

What does this prompt do?

Reads your list of branded queries (company name, exec names, product names, flagship features) from a Google Sheet you control.
Every weekday at 7am ET, fetches the live top 10 Google results plus the AI Overview text for each query.
Logs a snapshot row per query to a ledger sheet so you have a daily audit trail of rank order and AI Overview narrative.
Sends one Slack message only when a new domain enters page one, an existing domain drops off, or the AI Overview text changes. Silent on quiet days.

What do I need to use this?

A Real-Time Web Search account (RapidAPI subscription, free plan works for small query lists).
A Google account with edit access to two sheets: your branded query list and the daily ledger.
A Slack workspace and the channel you want alerts posted in.

How can I customize it?

Change the schedule, for example run twice a day or only on Mondays.
Add, remove, or relabel branded queries by editing the source Google Sheet, no workflow changes needed.
Route alerts to a different Slack channel, a private DM, or a dedicated brand reputation channel.
Widen or narrow the scope by including competitor brand names so you also see when they show up on your turf.

Frequently asked questions

How is this different from a regular SEO rank tracker?

Standard rank trackers watch commercial keywords you are trying to win. This watcher tracks the queries where your brand is the answer, your company name, your executives, your products, and your flagship features. It catches a competitor or a critical article moving onto page one before anyone on your team notices.

What counts as a change worth alerting on?

Three things: a new domain entering the top 10 for any branded query, an existing domain dropping off the top 10, or the Google AI Overview text shifting in a meaningful way. Cosmetic wording tweaks are ignored so your Slack channel stays quiet on no-news days.

Will this spam my Slack channel?

No. If today's snapshot matches yesterday's, the workflow posts nothing. You only get a message on days when one of the three change conditions actually fires.

Can I track competitor brand queries too?

Yes. Add their company name, product names, or executive names to the same Google Sheet. The workflow treats every row the same way, so you will see competitor SERP movement alongside yours.

What happens when a query has no AI Overview?

The snapshot row records that no AI Overview was present and the workflow moves on. If an AI Overview appears on a later run, the diff treats that as a change and you get an alert.