Connect Telegram with Google Sheets
Workflow Description
Automation connecting Telegram conversations to Google Sheets via an intelligent agent. Receives user messages, processes them with advanced language models, and stores data and conversation history in organized spreadsheets while maintaining context.
How it works
- 1.Receive messages from Telegram through trigger and verify message type
- 2.Process messages using an intelligent agent powered by language model via Open Router
- 3.Store messages and responses in Google Sheets with timestamps
- 4.Maintain conversation history in memory buffer and send reply back to user
Use cases
- Automatically collect and categorize customer inquiries into organized spreadsheet records
- Create intelligent conversations with full conversation history saved for analysis and review
Requirements
- Active Telegram account with bot token
- Google Sheets account with write permissions
- Open Router API key to access language models
- Configure memory buffer to maintain conversation context
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