Weekly Google AI Overviews visibility tracker for your brand

Build me an agent workflow that tracks my brand's visibility inside Google's AI Overviews on a weekly cadence. This is GEO and AEO share-of-voice monitoring, not traditional SEO rank tracking.

Trigger: cron, every Monday at 7am in my local time zone.

Inputs I will configure on the workflow: a Google Sheet spreadsheet ID and tab for my commercial buyer questions (one query per row, for example 'best CRM for early-stage SaaS' or 'Salesforce vs HubSpot for startups'), a separate Google Sheet spreadsheet ID and tab to use as the longitudinal log, my brand name, a list of tracked competitor brand names, and the Slack channel for the digest.

On each run, do the following:

1. Read the list of buyer questions from the configured Google Sheet using the Google Sheets Get Values operation. Skip blank rows.

2. For each question, call the Real-Time Web Search Search operation with fetch_ai_overviews=true so the response includes the live Google AI Overview when one is present. Use a US English locale by default, configurable on the workflow.

3. For every query, extract: whether an AI Overview was returned, the list of domains cited in the overview, whether my brand was mentioned by name in the overview text, which of my tracked competitors were mentioned by name, and how each mentioned brand was framed (positive, neutral, or negative). Use the agent's own reading of the overview text for the framing judgment.

4. Append one row per query to the longitudinal log Google Sheet using the Google Sheets Append Values operation. Columns should be: run date, query, AI Overview present (yes/no), our brand mentioned (yes/no), our framing, competitors mentioned (comma-separated), competitor framings, cited domains (comma-separated), and a short notes field for anything unusual.

5. Compare this week's rows against the previous week's rows for the same queries in the same log. Identify week-over-week shifts: queries where we newly appeared, queries where we dropped out, queries where our framing improved or worsened, queries where a competitor newly appeared or dropped out, and queries where the cited domains changed materially.

6. Send a narrative Slack message to the configured channel using the Slack Send a Message operation. Lead with the three biggest week-over-week visibility shifts in plain English, then a short coverage summary (how many queries returned an AI Overview, our brand mention rate, top competitor mention rate), and finish with a link to the log spreadsheet.

Keep the Slack digest short and skimmable. The full data lives in the sheet; the message exists to surface what changed.

On the first run, when there is no prior week to compare against, write the baseline rows to the log and post a Slack message saying the baseline is set, with the coverage summary only.

Additional information

What does this prompt do?

Runs every Monday morning and checks Google's AI Overview for each commercial buyer question you care about, like 'best CRM for early-stage SaaS' or 'Salesforce vs HubSpot for startups'.
For every question, captures whether an AI Overview appeared, which domains Google cited, whether your brand and your tracked competitors were mentioned by name, and how each brand was framed.
Appends one row per question to a longitudinal Google Sheet so you can see your share of voice in AI Overviews trend over weeks and months.
Posts a short Slack digest that leads with the three biggest week-over-week visibility shifts, so your team sees what changed without opening the sheet.

What do I need to use this?

A list of buyer questions you want to track in a Google Sheet (one query per row), plus a separate sheet or tab to use as the longitudinal log.
A RapidAPI account subscribed to Real-Time Web Search, so the agent can pull live Google AI Overviews.
A Google account connected to General Input, so the agent can read your question list and append to your log sheet.
A Slack workspace and the channel you want the Monday digest posted to.
Your brand name and the competitor brand names you want flagged when they appear in AI Overviews.

How can I customize it?

Change the schedule (for example, run it every Friday afternoon instead of Monday morning, or run it twice a week).
Edit the question list in your Google Sheet at any time. The agent reads it fresh on every run, so adding or removing buyer questions takes seconds.
Swap the Slack channel, change the digest tone, or have it call out only shifts that exceed a threshold you set.
Update the list of tracked competitor brands so the agent flags new entrants or drops ones you no longer care about.

Frequently asked questions

What is a Google AI Overview and why should I track it?

AI Overviews are the AI-generated summaries Google now shows above traditional results for many commercial buyer questions. They cite a handful of sources, and your visibility inside that box increasingly drives clicks and brand consideration. This workflow tells you, week after week, whether you are in the box and how you are framed.

How is this different from regular SEO rank tracking?

Standard SEO tools tell you where you rank in the blue links. This tracks something newer: whether your brand is mentioned and cited inside Google's AI Overview answer itself, which is what people read before they ever scroll. It is sometimes called GEO or AEO tracking.

Will it work if some queries do not show an AI Overview?

Yes. The agent logs whether an AI Overview was present for each query, so you also see coverage trends, not just share of voice. Queries with no overview that week show up as blanks in your log and roll into the digest as 'no overview this week'.

How many questions can I track?

Start with the ten to thirty buyer questions that matter most for your category. The list lives in your Google Sheet, so you can grow it as you go. Each tracked query consumes a small amount of your Real-Time Web Search quota per run.

Can I track competitor framing, not just mentions?

Yes. The agent reads the AI Overview text and notes whether each competitor was described positively, neutrally, or as a downside. That framing goes into the Slack digest when something changes meaningfully week over week.