Plan daily restaurant prep lists with DeepSeek, Google Sheets, Telegram and Gmail
Ready for 3.0What this workflow does
This AI workflow has 33 nodes and runs on a schedule (cron 0 7 * * *) (plus 3 other triggers). Along the way it connects Google Sheets, OpenAI Chat Model, Telegram and Gmail.
How it runs
Trigger: On a schedule (cron 0 7 * * *) (plus 3 other triggers).
- Set Prep Date Context (Edit Fields (Set)): sets 2 fields: prep_date, day_name
- Normalize Completion (Edit Fields (Set)): sets 2 fields: row_key, status
- Read Prep Log (Google Sheets): uses Google Sheets
- Read Prep Master List (Google Sheets): uses Google Sheets
- If: checks a condition and branches into true / false
- Build Weekly Prep Stats (Code): runs custom JavaScript code
- Build Prep Context (Code): runs custom JavaScript code
- Update Prep Log Status (Google Sheets): update
- Set Prep Error Alert (Edit Fields (Set)): sets 1 field: error_msg
- If: checks a condition and branches into true / false
…plus 17 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 (11)
- Webhook
n8n-nodes-base.webhook - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - If
n8n-nodes-base.if - Split Out
n8n-nodes-base.splitOut - Telegram
n8n-nodes-base.telegram - Gmail
n8n-nodes-base.gmail
From the author
Mise en place, automated. This workflow builds your daily restaurant prep list from a Google Sheets master, has AI plan the quantities, logs tasks back to Sheets, and notifies the team. Crews confirm completion from their stations, and Mondays bring a…