Receive Telegram Messages and Store Them in Google Sheets
Workflow Description
An automation that captures messages from Telegram users, processes them through an AI-powered agent, and automatically saves the data and conversation history in Google Sheets while delivering intelligent responses back to users.
How it works
- 1.Receive incoming messages from a Telegram channel or group via webhook
- 2.Process the message content through an AI agent that understands context and maintains conversation memory
- 3.Store the messages, metadata, and AI responses in connected Google Sheets tables
- 4.Send intelligent replies back to Telegram users based on agent processing
Use cases
- Collect team feedback and customer inquiries directly from Telegram and automatically categorize them in spreadsheets
- Build a smart chatbot that saves every interaction in Google Sheets for analytics and training purposes
- Create an intelligent form that accepts Telegram responses and organizes them into structured data tables
- Track customer requests and complaints through Telegram while maintaining a complete audit log in sheets
Requirements
- Active Telegram bot with valid Access Token and webhook configuration
- Google account with edit permissions on target Google Sheets
- API key for LM Chat Open Router or compatible natural language processing service
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