Connect Telegram with Google Sheets
Workflow Description
An intelligent automation that connects Telegram conversations with Google Sheets, where an AI agent receives, processes, and stores messages automatically. The system maintains conversation history in memory and provides smart responses based on context.
How it works
- 1.Receive message from Telegram via chat trigger
- 2.Process the message using an AI agent connected to OpenRouter LM
- 3.Store message and response in Google Sheets automatically
- 4.Manage conversation history using memory buffer window
- 5.Send intelligent response back to user via Telegram
Use cases
- Record all customer inquiries and answers in an organized spreadsheet
- Build a conversation database to analyze patterns and drive continuous improvement
Requirements
- Active Telegram account with configured bot and valid token
- Google Sheets with proper structure including columns for question, answer, and timestamp
- Valid OpenRouter API key to power the language model
Service Value
Ready-made workflow template for automation delivery and service execution.
Apps Used
Details
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (23)
SendTyping
Set
SetResponse
Set
Settings
Set
Schedule
Google Sheets
ScheduleToMarkdown
Code
ScheduleBot
Agent
n8nChatSettings
Set
telegramChatSettings
Set
telegramInput
Set
n8nInput
Chat Trigger
Switch
Switch
telegramResponse
Set
n8nResponse
No Op
LLM
Lm Chat Open Router
Memory
Memory Buffer Window
Sticky Note
Sticky Note
Sticky Note1
Sticky Note
Sticky Note2
Sticky Note
Sticky Note3
Sticky Note
Sticky Note4
Sticky Note
Sticky Note5
Sticky Note
Sticky Note6
Sticky Note
Sticky Note7
Sticky Note