n8n Daily Restaurant Prep Planner: DeepSeek + Google Sheets + Telegram

Turn your daily restaurant prep into a one-click, AI-planned workflow

n8n Daily Restaurant Prep Planner: DeepSeek + Google Sheets + Telegram automatically generates a day-specific restaurant prep list from your Google Sheets master data, uses DeepSeek (OpenAI chat model) to plan quantities in structured JSON, logs tasks back to Google Sheets, and keeps your team updated via Telegram and Gmail—including completion confirmations and a weekly digest.

What this workflow does

• Runs daily at 07:00 (Asia/Jakarta) or instantly when a POST request hits /prep/generate.
• Reads the “PrepItems” master list from Google Sheets and builds a context for the selected date/weekday, including items, par levels, and units.
• Sends the context to DeepSeek to generate a JSON prep plan, then validates that at least one prep item is returned.
• Appends planned tasks to the “PrepLog” sheet with PENDING status.
• Notifies your team by posting a formatted prep summary to Telegram and emailing the manager via Gmail.
• Accepts task updates via POST to /prep/complete to mark items DONE or SKIPPED, updates the matching row_key in “PrepLog”, and confirms via Telegram + Gmail.
• Runs weekly on Monday at 09:00 to compute completion stats, generate a short weekly digest with DeepSeek, and send it via Gmail and Telegram (or alerts “no data” if nothing is logged).
• If planning fails or completion payloads are invalid, it sends an error alert to Telegram and the manager via Gmail.

Use cases

• Standardize opening prep checklists using your existing Google Sheets master.
• Reduce manual planning by letting DeepSeek generate quantities each morning.
• Improve accountability with PENDING → DONE/SKIPPED tracking and real-time Telegram updates.
• Review staff performance weekly with an AI-generated completion digest.

Technical details

• Scheduling + webhooks: daily 07:00 (Asia/Jakarta), Monday 09:00; webhook endpoints /prep/generate and /prep/complete.
• Google Sheets: reads “PrepItems”, writes to “PrepLog”, updates rows by row_key.
• DeepSeek (OpenAI chat model): generates the daily prep JSON plan and weekly digest.
• Telegram + Gmail: sends prep summaries, completion confirmations, and error alerts.
• n8n workflow nodes used include if, set, code, gmail, webhook, and split out.