Connect Telegram with OpenAI andGoogle Sheets
Workflow Description
An advanced automation that connects Telegram conversations to OpenAI's intelligent responses, automatically storing data in Google Sheets. Processes incoming messages through a smart agent, parses outputs, and logs results in spreadsheets for review and analysis.
How it works
- 1.Receive messages from Telegram via chat triggers
- 2.Process messages using OpenAI AI Agent
- 3.Analyze and structure outputs from the language model
- 4.Log results and data to Google Sheets
- 5.Send intelligent responses back to Telegram
Use cases
- Create a smart Telegram bot that answers customer inquiries while maintaining a conversation log
- Automatically analyze message data and categorize it in organized spreadsheets
Requirements
- Active OpenAI account with valid API key
- Telegram account with Bot Token configured
- Google Sheets file with write and edit permissions
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
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)
When chat message received
Chat Trigger
OpenAI Chat Model
OpenAI
Structured Output Parser
Output Parser Structured
Get Audio File
Set
Transcribe Recording
OpenAI
Limit
Limit
Receive Telegram message
Set
If it's a voice message
If
Set chatInput from message
Set
Set chatInput from voice
Set
List of Ingredients and nutrients
Agent
Explode the list
Split Out
Add date
Code
Store in sheet
Google Sheets
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
Respond message
Set
Sticky Note7
Sticky Note