Capture Telegram Messages and Log Them to Google Sheets
Workflow Description
An automation that intercepts incoming Telegram messages and logs them directly into a Google Sheets spreadsheet, enabling organized tracking of conversations and centralized data storage from your Telegram bot without manual effort.
How it works
- 1.Receive new messages sent to your Telegram bot or channel
- 2.Process and format message data based on your requirements
- 3.Append messages and metadata to your designated Google Sheets table
Use cases
- Collect customer inquiries from Telegram and organize them in a tracking spreadsheet
- Archive comments and feedback from Telegram groups into a structured sheet automatically
- Create a centralized database of requests and information submitted through your Telegram bot
Requirements
- Active Telegram account with an existing configured bot
- Google Sheets spreadsheet with pre-defined columns for receiving data
- Write permissions on the target Google Sheets file
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 (29)
Trigger
Set
Global data
Set
Telegram1
Set
Telegram2
Set
Telegram3
Set
Telegram4
Set
Sticky Note
Sticky Note
Sticky Note1
Sticky Note
Sticky Note2
Sticky Note
Sticky Note3
Sticky Note
Sticky Note4
Sticky Note
Telegram5
Set
Switch_MessageType
Switch
Sticky Note5
Sticky Note
Telegram6
Set
Menu
Switch
Command?
If
Change status
Google Sheets
Start bot?
If
Register
Execute Workflow
Payment Handler
Execute Workflow
Trigger Data for Payment
Set
Trigger Data for Register
Set
Switch
Switch
Data for Invoice
Set
Send Invoice
Execute Workflow
Sticky Note6
Sticky Note
Sticky Note7
Sticky Note
Switch_Commands
Switch