Automate Inventory Management with Google Sheets & Gmail — n8n 工作流
概览
✅ What problem does this workflow solve?
Managing inventory manually requires constant monitoring, manual purchase order creation, and back-and-forth communication with suppliers.
This workflow automates the entire inventory replenishment cycle — from detecting low-stock items to generating purchase orders and emailing suppliers automatically.
It ensures accurate stock levels, reduces manual work, and prevents stockouts.
💡 Main Use Cases
🔍 Identify low-stock items automatically based on t
使用的节点
Google SheetsGmailCode
工作流预览
Send Order to Suplier
S
Switch Email & PO
Generate Email & PO
Order Handling
N
No Operation, do nothing
L
Loop Over Items
⚡
T
Trigger Everyday
Get Low Stock Product
Get Purchase Order
C
Check Record Exists Or Not
Store a Purchase Order
11 nodes12 edges
工作原理
- 1
触发器
工作流由 定时 触发器启动，按预定计划运行。
- 2
处理
数据流经 11 个节点, connecting code, gmail, googlesheets。
- 3
输出
工作流完成自动化并将结果发送到配置的目标。
节点详情 (11)
GO#1
Google Sheets
googleSheets
GM#2
Gmail
gmail
CO#3
Code
code
如何导入此工作流
- 1点击右侧 下载 JSON 按钮保存工作流文件。
- 2打开你的 n8n 实例，依次点击 工作流 → 新建 → 从文件导入。
- 3选择下载的
automate-inventory-management-with-google-sheets-gmail文件并点击导入。 - 4为每个服务节点配置 凭证（API 密钥、OAuth 等）。
- 5点击 测试工作流 验证一切正常，然后激活它。
或直接在 n8n → 从 JSON 导入 中粘贴：
{ "name": "Automate Inventory Management with Google Sheets & Gmail", "nodes": [...], ...}
集成
codegmailgooglesheetsifscheduletriggersplitinbatchesswitch
创建者
InfyOm Technologies
@infyom
标签
codegmailgooglesheetsifscheduletriggersplitinbatchesswitch