# Generate monthly SEO analytics reports with Search Console: n8n workflow

> Started by an incoming Telegram message, and works across Discord, Google Sheets, Slack and Telegram. It hands the judgement calls to OpenAI.

Source: https://millionrounds.com/workflow/generate-monthly-seo-analytics-reports-with-search-console (Millionrounds; every figure on the page links to its filing or article)

[Automation library](https://millionrounds.com/workflows) · [Content](https://millionrounds.com/workflows?category=Content#library)

# Generate monthly SEO analytics reports with Search Console

Started by an incoming Telegram message, and works across Discord, Google Sheets, Slack and Telegram. It hands the judgement calls to OpenAI. 41 steps, 3 branches: large, and worth reading before you trust it with anything live.

Large Calls a model: OpenAI

[Download free](https://millionrounds.com/login?next=%2Fapp%2Fworkflow%2Fgenerate-monthly-seo-analytics-reports-with-search-console)

**41 steps** Large: read it before trusting it with anything live

**3** Branches: places the flow splits

**0** Loops or waits

**4** Services it connects to

## The flow

Starts it 2 Model 7 Logic 12 Service 20

The steps in the order they run, from what starts it.

- 1 **Schedule Trigger** Schedule trigger *Starts it*
- 2 **Append row** Google Sheets Tool *Service*
- 3 **Get row(s)4** Google Sheets Tool *Service*
- 4 **Get GA History** Google Sheets Tool *Service*
- 5 **Get Search Console History** Google Sheets Tool *Service*
- 6 **Get PageSpeed History** Google Sheets Tool *Service*
- 7 **Get Technical Audit History** Google Sheets Tool *Service*
- 8 **Get row(s) in sheet in Google Sheets** Google Sheets Tool *Service*
- 9 **Get row(s) in sheet in Google Sheets1** Google Sheets Tool *Service*
- 10 **Get row(s) in sheet in Google Sheets2** Google Sheets Tool *Service*
- 11 **Telegram Trigger** Telegram trigger *Starts it*
- 12 **OpenAI** Lm Chat Open Ai *Model*
- 13 **OpenAI 2** Lm Chat Open Ai *Model*
- 14 **Edit Fields (Add Your Target Website URL)** Set *Logic*
- 15 **Analytics Agent** Agent *Model*
- 16 **Final Analytics Agent** Agent *Model*
- 17 **SEO Agent** Agent *Model*
- 18 **Performance Agent** Agent *Model*
- 19 **Technical Agent** Agent *Model*
- 20 **If (Check Admin)** If *Logic*
- 21 **HTTPS (Search console)** Http Request *Service*
- 22 **HTTPS (Crawl Website Homepage)** Http Request *Service*
- 23 **HTTPS (Fetch PageSpeed Data)** Http Request *Service*
- 24 **Get Analytics report** Google Analytics *Service*
- 25 **Merge All** Merge *Logic*
- 26 **Sheet (Save Final Report)** Google Sheets *Service*
- 27 **No Operation, do nothing** No Op *Logic*
- 28 **If (Check User Message)** If *Logic*
- 29 **Code (Format Search Console Data)** Code *Logic*
- 30 **Code (Extract On-Page SEO Data)** Code *Logic*
- 31 **Code (Format PageSpeed Data)** Code *Logic*
- 32 **Code (Format GA Data)** Code *Logic*
- 33 **Aggregate All Reports** Code *Logic*
- 34 **Telegram (Send SEO Report Message)** Telegram *Service*
- 35 **Slack (Send SEO Report Message)** Slack *Service*
- 36 **Teams (Send SEO Report Message)** Microsoft Teams *Service*
- 37 **Discord (Send SEO Report Message)** Discord *Service*
- 38 **Rapiwa (Send SEO Report Message on WhatsApp)** Rapiwa *Service*
- 39 **If (Check Perfect Message for 'SEO Analysis')** If *Logic*
- 40 **Send a alert message to Admin** Telegram *Service*
- 41 **Code (Score On-Page SEO)** Code *Logic*

## How it's built

- **Starts on:** An incoming Telegram message
- **Steps:** 41, with 3 branches
- **Size:** Large: read it before trusting it with anything live
- **Connects to:** Discord, Google Sheets, Slack, Telegram
- **Model:** OpenAI

## Questions

What does it need to run?

An n8n account, plus your own Discord, Google Sheets, Slack and Telegram accounts, and a key for OpenAI. You connect your own accounts after importing it; none are included.

What starts it?

It starts on an incoming Telegram message.

Does it use AI?

Yes. It calls OpenAI. Model calls are billed by the provider, not by n8n.

How long does it take to set up?

Take your time. At 41 steps it is large: read it before trusting it with anything live.

How do I import it?

Copy the workflow, open a new workflow in n8n and paste. The steps appear on the canvas, ready for your own accounts.

**Before you run it**

Nothing here has been tested by us. It is somebody's working automation, read and described from its own steps. Treat the connections it wants as a list of accounts it will touch, and read the 41 steps before you point it at anything that matters.

## Run it in n8n

- **Create your n8n account** Free to start. n8n is where the workflow runs. [Create an n8n account ↗](https://millionrounds.com/n8n)
- **Download the workflow** Free with a Millionrounds account. [Download free](https://millionrounds.com/login?next=%2Fapp%2Fworkflow%2Fgenerate-monthly-seo-analytics-reports-with-search-console)
- **Paste it into n8n** Open a new workflow in n8n and paste. Then connect your own accounts.

Stored with the author's traces removed: canvas notes, instance identifiers, saved credential names and any live document they had left behind.

## Connects to

Each opens the other workflows that use it.

[Discord](https://millionrounds.com/workflows?service=Discord#library)[Google Sheets](https://millionrounds.com/workflows?service=Google+Sheets#library)[Slack](https://millionrounds.com/workflows?service=Slack#library)[Telegram](https://millionrounds.com/workflows?service=Telegram#library)

## Workflows like it

Also content, with the same services where possible, closest in size first.

- [**Create & share AI videos with Telegram and Gemini** 41 steps · calls a model · Google Drive, Google Sheets](https://millionrounds.com/workflow/create-and-share-ai-videos-with-telegram-and-gemini)
- [**Create and publish UGC social videos from Telegram with OpenAI** 41 steps · calls a model · Google Drive, Google Sheets](https://millionrounds.com/workflow/create-and-publish-ugc-social-videos-from-telegram-with-open)
- [**Host a Telegram AI bot with a local model and Redis** 41 steps · calls a model · Redis, Telegram](https://millionrounds.com/workflow/host-a-telegram-ai-bot-with-a-local-model-and-redis)
- [**Verify Telegram channel subscriptions with Postgres** 41 steps · Google Drive, Postgres](https://millionrounds.com/workflow/verify-telegram-channel-subscriptions-with-postgres)
- [**Automatic Instagram content creation with OpenAI and Telegram** 42 steps · calls a model · Airtable, Telegram](https://millionrounds.com/workflow/automatic-instagram-content-creation-with-openai-and-telegra)
- [**Convert Reddit business pain points to LinkedIn posts** 40 steps · calls a model · Google Sheets, LinkedIn](https://millionrounds.com/workflow/convert-reddit-business-pain-points-to-linkedin-posts)