{"product_id":"n8n-google-sheets-to-telegram-auto-send-new-production-orders","title":"n8n Google Sheets to Telegram: Auto-send New Production Orders","description":"\u003ch3\u003eAuto-send new production orders from Google Sheets to Telegram every 15 minutes\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow watches your Google Sheets production order tracker, sends each unannounced order to a shop-floor Telegram chat, and then marks those rows as “Announced” so the same orders are never sent twice.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduled checks:\u003c\/strong\u003e Runs on a \u003cstrong\u003e15-minute schedule\u003c\/strong\u003e (or you can run it manually) to look for new production orders.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads your sheet:\u003c\/strong\u003e Loads all rows from the selected \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e worksheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters unannounced orders:\u003c\/strong\u003e Selects rows that contain an \u003cstrong\u003eOrder ID\u003c\/strong\u003e and are \u003cstrong\u003enot yet marked as announced\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFormats one message per order:\u003c\/strong\u003e Builds a \u003cstrong\u003eplain-text\u003c\/strong\u003e alert for each qualifying order and highlights \u003cstrong\u003eurgent orders\u003c\/strong\u003e based on the \u003cstrong\u003edue date\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePosts to Telegram:\u003c\/strong\u003e Sends each formatted order message to a configured \u003cstrong\u003eTelegram chat\u003c\/strong\u003e for shop-floor visibility.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates the sheet:\u003c\/strong\u003e Writes the configured \u003cstrong\u003e“Announced”\u003c\/strong\u003e value back to the corresponding rows in Google Sheets to prevent re-sending.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eProduction planning teams want immediate shop-floor alerts when new work orders are added to a Google Sheet.\u003c\/li\u003e\n  \u003cli\u003eSmall manufacturers use a lightweight tracker and need Telegram notifications instead of building a full dashboard.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers need a reliable example of \u003cstrong\u003eGoogle Sheets → Telegram\u003c\/strong\u003e with row updates for idempotency.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTech stack \/ nodes used:\u003c\/strong\u003e \u003ccode\u003eschedule trigger\u003c\/code\u003e, \u003ccode\u003egoogle sheets\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003ccode\u003etelegram\u003c\/code\u003e, \u003ccode\u003eset\u003c\/code\u003e, and a \u003ccode\u003esticky note\u003c\/code\u003e for workflow guidance.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eConfiguration steps:\u003c\/strong\u003e Connect your Google account and select the spreadsheet\/worksheet for both read and update. Connect Telegram, set the target chat ID, and ensure the bot can post.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSheet columns expected:\u003c\/strong\u003e Order, Product, Quantity, Due date, Station, Priority, and Announced (or adjust column names and urgent settings in the Settings step).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45742829240499,"sku":"N8N-17508","price":34.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/WswSYrFJCL4FZXIJQE73L_JbJWwwUv.png?v=1785402917","url":"https:\/\/buyflowscripts.com\/products\/n8n-google-sheets-to-telegram-auto-send-new-production-orders","provider":"N8N Commerce","version":"1.0","type":"link"}