Automate inventory reordering and vendor bill approvals with Odoo, Gmail, and Slack
Ready for 3.0What this workflow does
This workflow has 20 nodes and runs on a schedule (every day at 08:00) (plus 1 other trigger). Along the way it connects Odoo, Gmail and Slack.
How it runs
Trigger: On a schedule (every day at 08:00) (plus 1 other trigger).
- Fetch Low-Stock Products in Odoo (Odoo): work with custom
- Set Vendor Bill Information (Edit Fields (Set)): sets 4 fields: vendorName, billAmount, billReference…
- Check Products Below Reorder Level (If): checks a condition and branches into true / false
- Notify Automation Error via Slack (Slack): uses Slack
- Check Vendor in Odoo (Odoo): work with custom
- Fetch Preferred Vendor in Odoo (Odoo): work with custom
- Post No Reorder Needed to Procurement (Slack): uses Slack
- Verify Vendor Recognition in Odoo (If): checks a condition and branches into true / false
- Fetch Vendor Contact in Odoo (Odoo): get (custom)
- Create Draft Vendor Bill in Odoo (Odoo): create (custom)
…plus 8 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (7)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Odoo
n8n-nodes-base.odoo - If
n8n-nodes-base.if - Gmail
n8n-nodes-base.gmail - Slack
n8n-nodes-base.slack - Gmail Trigger
n8n-nodes-base.gmailTrigger - Edit Fields (Set)
n8n-nodes-base.set
From the author
Quick overview This workflow automates two Odoo processes: a daily low-stock check that drafts purchase orders and emails vendors via Gmail, and an email-driven vendor bill intake flow that routes draft bills to Slack for approval before posting them in Odoo.…