{"product_id":"n8n-daily-restaurant-prep-planner-deepseek-google-sheets-telegram","title":"n8n Daily Restaurant Prep Planner: DeepSeek + Google Sheets + Telegram","description":"\u003ch3\u003eTurn your daily restaurant prep into a one-click, AI-planned workflow\u003c\/h3\u003e\n\u003cp\u003e\u003cstrong\u003en8n Daily Restaurant Prep Planner: DeepSeek + Google Sheets + Telegram\u003c\/strong\u003e automatically generates a day-specific restaurant prep list from your Google Sheets master data, uses \u003cstrong\u003eDeepSeek\u003c\/strong\u003e (OpenAI chat model) to plan quantities in structured JSON, logs tasks back to Google Sheets, and keeps your team updated via \u003cstrong\u003eTelegram\u003c\/strong\u003e and \u003cstrong\u003eGmail\u003c\/strong\u003e—including completion confirmations and a weekly digest.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily at 07:00 (Asia\/Jakarta)\u003c\/strong\u003e or instantly when a \u003cstrong\u003ePOST\u003c\/strong\u003e request hits \u003ccode\u003e\/prep\/generate\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads the “PrepItems” master list\u003c\/strong\u003e from Google Sheets and builds a context for the selected date\/weekday, including items, par levels, and units.\u003c\/li\u003e\n  \u003cli\u003eSends the context to \u003cstrong\u003eDeepSeek\u003c\/strong\u003e to generate a \u003cstrong\u003eJSON prep plan\u003c\/strong\u003e, then validates that at least one prep item is returned.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends planned tasks\u003c\/strong\u003e to the “PrepLog” sheet with \u003cstrong\u003ePENDING\u003c\/strong\u003e status.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNotifies your team\u003c\/strong\u003e by posting a formatted prep summary to \u003cstrong\u003eTelegram\u003c\/strong\u003e and emailing the manager via \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eAccepts task updates via \u003cstrong\u003ePOST\u003c\/strong\u003e to \u003ccode\u003e\/prep\/complete\u003c\/code\u003e to mark items \u003cstrong\u003eDONE\u003c\/strong\u003e or \u003cstrong\u003eSKIPPED\u003c\/strong\u003e, updates the matching \u003cstrong\u003erow_key\u003c\/strong\u003e in “PrepLog”, and confirms via Telegram + Gmail.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns weekly on Monday at 09:00\u003c\/strong\u003e to compute completion stats, generate a short weekly digest with \u003cstrong\u003eDeepSeek\u003c\/strong\u003e, and send it via Gmail and Telegram (or alerts “no data” if nothing is logged).\u003c\/li\u003e\n  \u003cli\u003eIf planning fails or completion payloads are invalid, it sends an \u003cstrong\u003eerror alert\u003c\/strong\u003e to Telegram and the manager via Gmail.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eStandardize opening prep checklists using your existing \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e master.\u003c\/li\u003e\n  \u003cli\u003eReduce manual planning by letting \u003cstrong\u003eDeepSeek\u003c\/strong\u003e generate quantities each morning.\u003c\/li\u003e\n  \u003cli\u003eImprove accountability with PENDING → DONE\/SKIPPED tracking and real-time \u003cstrong\u003eTelegram\u003c\/strong\u003e updates.\u003c\/li\u003e\n  \u003cli\u003eReview staff performance weekly with an AI-generated completion digest.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduling + webhooks\u003c\/strong\u003e: daily 07:00 (Asia\/Jakarta), Monday 09:00; webhook endpoints \u003ccode\u003e\/prep\/generate\u003c\/code\u003e and \u003ccode\u003e\/prep\/complete\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e: reads “PrepItems”, writes to “PrepLog”, updates rows by \u003cstrong\u003erow_key\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDeepSeek (OpenAI chat model)\u003c\/strong\u003e: generates the daily prep \u003cstrong\u003eJSON\u003c\/strong\u003e plan and weekly digest.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTelegram + Gmail\u003c\/strong\u003e: sends prep summaries, completion confirmations, and error alerts.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n workflow nodes\u003c\/strong\u003e used include \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003ccode\u003egmail\u003c\/code\u003e, \u003ccode\u003ewebhook\u003c\/code\u003e, and \u003ccode\u003esplit\u003c\/code\u003e out.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45865765503155,"sku":"N8N-18357","price":32.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/kjHZcqka6yLUZPR097hIG_Q3lX3P8S.png?v=1787044649","url":"https:\/\/buyflowscripts.com\/products\/n8n-daily-restaurant-prep-planner-deepseek-google-sheets-telegram","provider":"N8N Commerce","version":"1.0","type":"link"}