Automation library · Chat assistants

Create a session-based Telegram chatbot with OpenAI

Started by an incoming Telegram message, and works across Google Sheets and Telegram. It puts OpenAI behind a retrieval step, so answers are drawn from documents you supply rather than from the model alone. 31 steps, 2 branches: large, and worth reading before you trust it with anything live.

LargeCalls a model: OpenAIRetrieval

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

The flow

Starts it 1Model 7Logic 8Service 15

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

  1. 1OpenAI Chat ModelLm Chat Open AiModel
  2. 2Simple MemoryMemory Buffer WindowModel
  3. 3Get messageTelegram triggerStarts it
  4. 4OpenAI Chat Model1Lm Chat Open AiModel
  5. 5OpenAI Chat Model2Lm Chat Open AiModel
  6. 6Telegram ChatbotAgentModel
  7. 7Get sessionGoogle SheetsService
  8. 8Summarization ChainChain SummarizationModel
  9. 9Basic LLM ChainChain LlmModel
  10. 10Send responseTelegramService
  11. 11Command or text?SwitchLogic
  12. 12Send summaryTelegramService
  13. 13Send answerTelegramService
  14. 14Update databaseGoogle SheetsService
  15. 15Disable previous sessionGoogle SheetsService
  16. 16Send current sessionTelegramService
  17. 17Get message1SetLogic
  18. 18Get session1Google SheetsService
  19. 19Get message2SetLogic
  20. 20Set new sessionGoogle SheetsService
  21. 21Trim resumeCodeLogic
  22. 22Prompt + ResumeCodeLogic
  23. 23Trim questionCodeLogic
  24. 24Session activatedTelegramService
  25. 25Set to expireGoogle SheetsService
  26. 26Response + TextGoogle SheetsService
  27. 27Set new current sessionGoogle SheetsService
  28. 28fullTextCodeLogic
  29. 29Exist?IfLogic
  30. 30KOTelegramService
  31. 31OKTelegramService

How it's built

Starts on
An incoming Telegram message
Steps
31, with 2 branches
Size
Large: read it before trusting it with anything live
Connects to
Google Sheets, Telegram
Model
OpenAI
Retrieval
Answers are drawn from documents you supply, not from the model alone

Questions

What does it need to run?

An n8n account, plus your own Google Sheets 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. Its answers draw on documents you give it, not on the model alone. Model calls are billed by the provider, not by n8n.

How long does it take to set up?

Take your time. At 31 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 31 steps before you point it at anything that matters.