Automation library · Content

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.

LargeCalls a model: OpenAI

Download free
41 stepsLarge: read it before trusting it with anything live
3Branches: places the flow splits
0Loops or waits
4Services it connects to

The flow

Starts it 2Model 7Logic 12Service 20

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

  1. 1Schedule TriggerSchedule triggerStarts it
  2. 2Append rowGoogle Sheets ToolService
  3. 3Get row(s)4Google Sheets ToolService
  4. 4Get GA HistoryGoogle Sheets ToolService
  5. 5Get Search Console HistoryGoogle Sheets ToolService
  6. 6Get PageSpeed HistoryGoogle Sheets ToolService
  7. 7Get Technical Audit HistoryGoogle Sheets ToolService
  8. 8Get row(s) in sheet in Google SheetsGoogle Sheets ToolService
  9. 9Get row(s) in sheet in Google Sheets1Google Sheets ToolService
  10. 10Get row(s) in sheet in Google Sheets2Google Sheets ToolService
  11. 11Telegram TriggerTelegram triggerStarts it
  12. 12OpenAILm Chat Open AiModel
  13. 13OpenAI 2Lm Chat Open AiModel
  14. 14Edit Fields (Add Your Target Website URL)SetLogic
  15. 15Analytics AgentAgentModel
  16. 16Final Analytics AgentAgentModel
  17. 17SEO AgentAgentModel
  18. 18Performance AgentAgentModel
  19. 19Technical AgentAgentModel
  20. 20If (Check Admin)IfLogic
  21. 21HTTPS (Search console)Http RequestService
  22. 22HTTPS (Crawl Website Homepage)Http RequestService
  23. 23HTTPS (Fetch PageSpeed Data)Http RequestService
  24. 24Get Analytics reportGoogle AnalyticsService
  25. 25Merge AllMergeLogic
  26. 26Sheet (Save Final Report)Google SheetsService
  27. 27No Operation, do nothingNo OpLogic
  28. 28If (Check User Message)IfLogic
  29. 29Code (Format Search Console Data)CodeLogic
  30. 30Code (Extract On-Page SEO Data)CodeLogic
  31. 31Code (Format PageSpeed Data)CodeLogic
  32. 32Code (Format GA Data)CodeLogic
  33. 33Aggregate All ReportsCodeLogic
  34. 34Telegram (Send SEO Report Message)TelegramService
  35. 35Slack (Send SEO Report Message)SlackService
  36. 36Teams (Send SEO Report Message)Microsoft TeamsService
  37. 37Discord (Send SEO Report Message)DiscordService
  38. 38Rapiwa (Send SEO Report Message on WhatsApp)RapiwaService
  39. 39If (Check Perfect Message for 'SEO Analysis')IfLogic
  40. 40Send a alert message to AdminTelegramService
  41. 41Code (Score On-Page SEO)CodeLogic

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.