Connect Telegram to Google Sheets with AI Agent
Workflow Description
Automation that bridges Telegram conversations to Google Sheets through an intelligent agent that understands natural language commands, automatically logs data, and remembers conversation context, enabling task and information management directly from the messaging app.
How it works
- 1.Receive messages from a Telegram channel or group
- 2.Process text with an AI agent that extracts intent and required data
- 3.Insert extracted records into the designated Google Sheets worksheet
- 4.Maintain conversation history to understand ongoing context
Use cases
- Log meeting notes from team Telegram discussions directly into a shared spreadsheet
- Build dynamic task lists through Telegram messages with automatic updates saved to Google Sheets
Requirements
- Active Telegram account with a bot or channel configured for communication
- Google account with permissions to edit spreadsheets
- API key for intelligent agent service (Open Router or equivalent)
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