Connect Telegram to Google Sheets with Intelligent Processing
Workflow Description
Automation receives Telegram messages, processes them through an AI agent with conversation memory, stores results in Google Sheets, and sends intelligent replies back to users while maintaining context across interactions.
How it works
- 1.Receive incoming messages from Telegram channel or chat
- 2.Process messages using AI agent with conversation memory buffer
- 3.Save extracted data and responses to Google Sheets
- 4.Send automated reply back to Telegram user with processed result
Use cases
- Collect customer inquiries from Telegram and log them automatically in a shared Google Sheets database
- Handle administrative requests via Telegram with intelligent processing and persistent record-keeping in Google Sheets
Requirements
- Active Telegram account with Bot API token and chat access
- Google Sheets spreadsheet with editor permissions configured
- AI service API key (OpenRouter or compatible) for message processing
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