Run a restaurant concierge chatbot on Telegram with OpenAI and Google Sheets
Ready for 3.0What this workflow does
This AI workflow has 24 nodes and runs on Telegram events (message) (plus 1 other trigger). Along the way it connects Telegram, Google Sheets, OpenAI Chat Model and OpenAI.
How it runs
Trigger: On Telegram events (message) (plus 1 other trigger).
- Configuration (Edit Fields (Set)): sets 6 fields: restaurant_name, menu_link, review_link…
- Log New Client (Google Sheets): append or update
- Prepare Chat Context (Edit Fields (Set)): sets 2 fields: chat_id, customer_name
- Get Todays Marketing Campaign (Google Sheets): uses Google Sheets
- Wait: pauses before continuing
- Route By Message Type (Switch): routes items into 2 branches
- Get Active Clients (Google Sheets): uses Google Sheets
- Send Review Request (Telegram): uses Telegram
- Format Text Input (Edit Fields (Set)): sets 2 fields: user_message, input_channel
- Get Voice File (Telegram): work with file
…plus 8 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (13)
- Telegram Trigger
n8n-nodes-base.telegramTrigger - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Wait
n8n-nodes-base.wait - Telegram
n8n-nodes-base.telegram - Switch
n8n-nodes-base.switch - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Simple Memory
@n8n/n8n-nodes-langchain.memoryBufferWindow - Google Sheets Tool
n8n-nodes-base.googleSheetsTool - OpenAI
@n8n/n8n-nodes-langchain.openAi - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches
From the author
Quick overview This workflow runs a Telegram-based restaurant concierge that answers menu questions, takes text or voice orders with an OpenAI agent, and saves confirmed orders to Google Sheets, then follows up with an automated review request and sends a…