Connect Telegram with Google Sheets
Workflow Description
Automate receiving Telegram messages and saving them directly to Google Sheets with advanced conditional processing and instant confirmations sent back to users through Telegram.
How it works
- 1.Receive incoming messages from a specific Telegram channel or group
- 2.Evaluate message content and apply custom conditional logic
- 3.Insert extracted data into corresponding rows in Google Sheets
- 4.Send a confirmation message to the sender via Telegram
Use cases
- Collect customer inquiries from Telegram and automatically log them in work tracking sheets
- Monitor team messages and notifications while maintaining a cloud-based audit log
- Create a rapid-response system for customer queries with conversation documentation
Requirements
- Telegram bot API token or connection credentials
- Full read-write access permissions to the target Google Sheets file
- Pre-defined column names in the spreadsheet for data structure alignment
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