Hébergement VPS n8n | Automatisation sécurisée et évolutive
Formation n8n en Français : Automatisation & Agents IA
This workflow turns a Telegram bot into a full restaurant concierge: it answers menu questions, understands text and voice messages, helps the customer build an order conversationally, always proposes one relevant upsell, and saves the confirmed order to Google Sheets. New chats are logged as clients and get an automatic review request 2 hours later. A separate daily schedule sends your Marketing sheet campaigns to every active (non-unsubscribed) client.
flowchart TD
TG[Telegram Trigger] --> CFG[Configuration]
SCH[Daily Marketing Schedule] --> CFG
CFG --> LOG[Log New Client]
CFG --> CTX[Prepare Chat Context]
CFG --> CAMP[Get Todays Marketing Campaign]
LOG --> WAIT[Wait Before Review Request]
WAIT --> REVIEW[Send Review Request]
CTX --> ROUTE{Route By Message Type}
ROUTE -->|Text| FTXT[Format Text Input]
ROUTE -->|Voice| VOICE[Get Voice File]
ROUTE -->|Unsupported| UNSUP[Send Unsupported Message Reply]
VOICE --> TRANS[Transcribe Voice Message]
TRANS --> FVOICE[Format Voice Input]
FTXT --> AGENT[Restaurant AI Concierge]
FVOICE --> AGENT
AGENT --> REPLY[Send Agent Reply]
CAMP --> ACTIVE[Get Active Clients]
ACTIVE --> LOOP[Loop Over Clients]
LOOP -->|each| SENDM[Send Marketing Message]
SENDM --> LOOP
LOOP -->|done| DONE[Mark Campaign As Done]
<aside> ✅
Before you start, have these ready:
Google Sheet setup — create one spreadsheet with 4 tabs:
| Tab | Columns |
|---|---|
| Clients | CLIENT, NAME, DATE, UNSUBSCRIBE |
| Marketing | DATE, MESSAGE, DONE |
| Menu | ITEM, DESCRIPTION, PRICE |
| Orders | CHAT_ID, CUSTOMER_NAME, ORDER_ITEMS, UPSELL_OFFERED, ORDER_TOTAL, ORDER_DATE |
Credentials to create in n8n: