n8n Google Sheets to Telegram: Auto-send New Production Orders

Auto-send new production orders from Google Sheets to Telegram every 15 minutes

This 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.

What this workflow does

• Scheduled checks: Runs on a 15-minute schedule (or you can run it manually) to look for new production orders.
• Reads your sheet: Loads all rows from the selected Google Sheets worksheet.
• Filters unannounced orders: Selects rows that contain an Order ID and are not yet marked as announced.
• Formats one message per order: Builds a plain-text alert for each qualifying order and highlights urgent orders based on the due date.
• Posts to Telegram: Sends each formatted order message to a configured Telegram chat for shop-floor visibility.
• Updates the sheet: Writes the configured “Announced” value back to the corresponding rows in Google Sheets to prevent re-sending.

Use cases

• Production planning teams want immediate shop-floor alerts when new work orders are added to a Google Sheet.
• Small manufacturers use a lightweight tracker and need Telegram notifications instead of building a full dashboard.
• Automation engineers need a reliable example of Google Sheets → Telegram with row updates for idempotency.

Technical details

• Tech stack / nodes used: schedule trigger, google sheets, code, telegram, set, and a sticky note for workflow guidance.
• Configuration steps: 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.
• Sheet columns expected: Order, Product, Quantity, Due date, Station, Priority, and Announced (or adjust column names and urgent settings in the Settings step).