Monthly SEO opportunity brief: GA4 + Search Console to Google Docs and Slack

Build an agent workflow that runs on the first of every month at 8am in my local timezone and publishes a monthly SEO opportunity brief by cross-referencing Google Analytics 4 with Google Search Console, then writes the brief to a Google Doc and posts the summary in Slack.

Trigger: a cron schedule firing at 08:00 on the 1st of every month.

Step 1. Use Google Analytics Run Report (GA4) against my GA4 property to pull organic landing page performance for two date ranges: the last 28 days, and the 28 days before that. Dimensions: landingPage (or landingPagePlusQueryString), sessionDefaultChannelGroup. Metrics: sessions, engagementRate, conversions, averageEngagementTime. Filter to sessionDefaultChannelGroup = 'Organic Search'. Return the rows for both windows so we can compute month over month deltas per page.

Step 2. Use Google Search Console Search Analytics Query for my verified property over the same last 28 day window. Run it twice: once grouped by page (dimensions: ['page']) and once grouped by page and query (dimensions: ['page', 'query']) so we get clicks, impressions, CTR, and average position per page, plus the top queries per page. Use searchType 'web' and filter to country if I have a primary market. Page through results with startRow and rowLimit until rows are exhausted.

Step 3. Join GA4 rows to GSC rows on landing page URL (normalize trailing slashes and protocol). Then synthesize three prioritized buckets:

Bucket A, low CTR rewrites: pages with high impressions and a CTR materially below the site median for their position range. For each, draft a new meta title and meta description that leads with the highest-intent query already driving impressions, respects Google's length guidance (around 60 chars for the title, around 155 chars for the description), and stays on brand. Include the current title and description side by side with the suggested rewrite.

Bucket B, content refresh candidates: pages whose organic sessions declined more than 20% versus the prior 28 days. For each, list the specific queries that lost the most position or impressions, and a one-line refresh angle (for example: outdated stats, missing FAQ, thin section, new competitor on SERP).

Bucket C, striking distance: pages ranking in average position 5 to 15 on queries with meaningful impression volume. For each page, list two or three topical gaps to close based on the queries it is almost ranking for, and the single highest-leverage internal link to add.

Rank opportunities within each bucket by potential session lift, not raw impressions, so small high-intent pages do not get drowned out by big-but-saturated ones. A reasonable proxy is impressions multiplied by the gap between current CTR and a realistic CTR at the target position.

Step 4. Use Google Docs Create Document to make a new doc titled 'SEO opportunity brief, <Month> <Year>'. Then use Google Docs Batch Update Document to write the body: a one-paragraph executive summary up top, then three bucket sections, each with a table of the top 10 to 15 pages and a 'next action' column per page. End with a short 'how this was generated' footer noting the GA4 and GSC date ranges.

Step 5. Use Slack Send a Message to post a short summary in my marketing channel (let me pick the channel at setup). The message should include: the doc link, the month covered, total counts in each bucket, and the single highest-leverage opportunity called out by name (page URL plus expected lift).

If GA4 or GSC returns no rows (for example the property is brand new or unverified), still create the doc with a clear note explaining which dataset was empty, and post a Slack message saying the brief could not be generated this month and why. Do not silently skip.

Additional information

What does this prompt do?

Pulls the last 28 days of organic landing page performance from Google Analytics 4 and compares it against the prior 28 days, so trends are visible at a glance.
Cross-references Google Search Console clicks, impressions, click-through rate, and average position for the same window, joined back to each page.
Sorts opportunities into three ranked buckets: pages with high impressions but low click-through rate that need new meta titles and descriptions, pages with declining organic sessions that need a content refresh, and pages stuck on positions 5 to 15 that are close to the top of page one.
Publishes a polished brief in Google Docs with an executive summary, a table per bucket, suggested meta rewrites, and concrete next actions per page.
Posts a short summary in your marketing Slack channel that links the doc and calls out the single highest-leverage opportunity for the month.

What do I need to use this?

A Google Analytics 4 property for the site you want to analyze, with read access for the connected Google account.
A verified Google Search Console property for the same site, on the connected Google account.
A Google account that can create and edit Google Docs in the folder where you want the brief saved.
A Slack workspace and a channel where the monthly summary should be posted.

How can I customize it?

Change the schedule from the first of each month to weekly, biweekly, or quarterly, and shift the time to whatever fits your team's planning rhythm.
Pick which Slack channel receives the summary and tweak the message style, for example mention your SEO lead or add a thread reply with the full bucket lists.
Adjust the bucket thresholds, for example what counts as low click-through rate, how big a session drop triggers a refresh, or which position range counts as striking distance.
Filter the analysis to a subset of the site, such as the blog, product pages, or a specific country, and rank opportunities by estimated session lift instead of raw impressions.

Frequently asked questions

Do I need both Google Analytics and Search Console connected?

Yes. The brief is built by joining the two datasets together. Google Analytics tells you what happens on the page after a visit, and Search Console tells you which queries and positions sent the visit in the first place. With only one of them, you would lose either the engagement or the keyword half of the story.

Will this work if my site is small or new?

Yes, but the smaller the site, the noisier month over month comparisons become. You can widen the comparison window from 28 days to 90 days, or relax the thresholds so the buckets are not empty for small sites with limited traffic.

Can I send the brief somewhere other than Google Docs?

Yes. The doc is the default because it is easy to share and comment on, but you can swap it for Notion, Confluence, or even a Google Sheet if your team prefers tables. Tell the workflow which destination to use when you set it up.

How are the suggested meta titles and descriptions generated?

The agent reads the page URL, the queries that already drive impressions, and the current title and description, then drafts rewrites that lead with the highest-intent query and respect Google's length guidance. They are starting points for your editor, not final copy.

What if a page shows up in more than one bucket?

Pages are placed in the bucket where the action is clearest. A page that is both losing sessions and has poor click-through rate will appear once, in the bucket where the recommended fix is most likely to move the needle, with a note that the other issue exists too.