Forecast inventory and route purchase orders with Google Sheets, OpenAI, Telegram, Slack, and Gmail

by Rahul Joshi ✓ · 54 views · created 2026-07-31 · CRM, AI Summarization

What this workflow does

This AI workflow has 30 nodes and runs on a schedule (every day at 06:00) (plus 2 other triggers). Along the way it connects Slack, Google Sheets, Telegram and Gmail and 1 more.

How it runs

Trigger: On a schedule (every day at 06:00) (plus 2 other triggers).

1. Get Sales History (Google Sheets): uses Google Sheets
2. Get Inventory Levels (Google Sheets): uses Google Sheets
3. Get Vendor Directory (Google Sheets): uses Google Sheets
4. Get Existing Purchase Orders (Google Sheets): uses Google Sheets
5. Parse Approval Callback (Code): runs custom JavaScript code
6. Slack: uses Slack
7. Merge: merges the data from its input branches
8. Switch: routes items into 2 branches
9. Calculate Demand Forecast (Code): runs custom JavaScript code
10. Update PO Status - Approved (Google Sheets): update

…plus 17 more steps. See the full node list below.

Services it uses

SlackGoogle SheetsTelegramGmailOpenAI

Before you upgrade to n8n 3.0

Nodes used (12)

• Error Triggern8n-nodes-base.errorTrigger
• Slackn8n-nodes-base.slack
• Schedule Triggern8n-nodes-base.scheduleTrigger
• Google Sheetsn8n-nodes-base.googleSheets
• Coden8n-nodes-base.code
• Ifn8n-nodes-base.if
• Switchn8n-nodes-base.switch
• Telegramn8n-nodes-base.telegram
• Gmailn8n-nodes-base.gmail
• OpenAI@n8n/n8n-nodes-langchain.openAi
• Mergen8n-nodes-base.merge
• Telegram Triggern8n-nodes-base.telegramTrigger

From the author

Quick overview This workflow runs daily to forecast SKU demand from Google Sheets data, drafts purchase-order justifications with OpenAI, routes critical and warning items for Telegram review and Slack alerts, logs decisions back to Google Sheets, and sends…

View the original on n8n.io → Check your own copy