iamvaar This workflow corresponds to n8n.io template #5815 — we link there as the canonical source.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"meta": {
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "fe401179-5a8b-4232-b148-9bf4d96ceb9b",
"name": "Get Products with low stock",
"type": "n8n-nodes-base.airtable",
"position": [
-2340,
-540
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "46bfdc76-b244-41a9-a686-09c8eb140968",
"name": "Get supplier Details for those low stock products",
"type": "n8n-nodes-base.airtable",
"position": [
-2120,
-540
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "836a5efb-0cad-4508-8703-911241f0b847",
"name": "Calculate Dynamic Re-order Quantity",
"type": "n8n-nodes-base.code",
"position": [
-1900,
-540
],
"parameters": {},
"typeVersion": 2
},
{
"id": "7d04d71d-3d40-4575-b567-6e6bb8712e3a",
"name": "Run Every Mid Night",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-2520,
-540
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "50c4223b-83d7-4204-a2ad-75b390b9298b",
"name": "Create purchase records in table",
"type": "n8n-nodes-base.airtable",
"position": [
-2160,
-280
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "87965ea3-6e2a-495d-a040-fcf15ba8bb2a",
"name": "Search records",
"type": "n8n-nodes-base.airtable",
"position": [
-2500,
-280
],
"parameters": {},
"typeVersion": 2.1,
"alwaysOutputData": true
},
{
"id": "18390f14-6622-4f6c-8c24-ec123c4a807e",
"name": "Remove Duplicate Product Orders",
"type": "n8n-nodes-base.code",
"position": [
-2340,
-280
],
"parameters": {},
"typeVersion": 2
},
{
"id": "cc7b13bc-d8f8-4c26-b503-5d9a8fcfd010",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2600,
-980
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "790b9e2e-63fb-4d15-b0e9-47d1ab6dfdd2",
"name": "Schedule Trigger",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-1360,
-520
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "93b3ea8a-5b0a-41b6-863c-1c78bc6ec59d",
"name": "Get Purchase Orders which are pending",
"type": "n8n-nodes-base.airtable",
"position": [
-1120,
-520
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "4ba6d12d-cbe6-418e-a9bb-102f54451b03",
"name": "Group products with suppliers",
"type": "n8n-nodes-base.code",
"position": [
-900,
-520
],
"parameters": {},
"typeVersion": 2
},
{
"id": "ce853473-aa77-4215-a7e2-4b584f6b5986",
"name": "Get the record id's of PO",
"type": "n8n-nodes-base.code",
"position": [
-720,
-400
],
"parameters": {},
"typeVersion": 2
},
{
"id": "275e3674-127b-4acf-92cd-c554b61239f9",
"name": "Update the PO status to sent",
"type": "n8n-nodes-base.airtable",
"position": [
-500,
-540
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "fd03a9df-1892-465b-9dc5-6c13cb2c1f16",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1420,
-980
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "e725f7f0-85a1-4cec-af79-fee429ff2667",
"name": "Send PO to suppliers via Email",
"type": "n8n-nodes-base.sendInBlue",
"position": [
-700,
-700
],
"parameters": {},
"typeVersion": 1
}
],
"connections": {
"Search records": {
"main": [
[
{
"node": "Remove Duplicate Product Orders",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "Get Purchase Orders which are pending",
"type": "main",
"index": 0
}
]
]
},
"Run Every Mid Night": {
"main": [
[
{
"node": "Get Products with low stock",
"type": "main",
"index": 0
}
]
]
},
"Get the record id's of PO": {
"main": [
[
{
"node": "Update the PO status to sent",
"type": "main",
"index": 0
}
]
]
},
"Get Products with low stock": {
"main": [
[
{
"node": "Get supplier Details for those low stock products",
"type": "main",
"index": 0
}
]
]
},
"Group products with suppliers": {
"main": [
[
{
"node": "Send PO to suppliers via Email",
"type": "main",
"index": 0
},
{
"node": "Get the record id's of PO",
"type": "main",
"index": 0
}
]
]
},
"Send PO to suppliers via Email": {
"main": [
[]
]
},
"Remove Duplicate Product Orders": {
"main": [
[
{
"node": "Create purchase records in table",
"type": "main",
"index": 0
}
]
]
},
"Create purchase records in table": {
"main": [
[]
]
},
"Calculate Dynamic Re-order Quantity": {
"main": [
[
{
"node": "Search records",
"type": "main",
"index": 0
}
]
]
},
"Get Purchase Orders which are pending": {
"main": [
[
{
"node": "Group products with suppliers",
"type": "main",
"index": 0
}
]
]
},
"Get supplier Details for those low stock products": {
"main": [
[
{
"node": "Calculate Dynamic Re-order Quantity",
"type": "main",
"index": 0
}
]
]
}
}
}
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
In-depth description of this automation:
Source: https://n8n.io/workflows/5815/ — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
How it works
Airtable, Sendinblue, HTTP Request
I prepared a detailed guide that showed the whole process of integrating the Binance API and storing data in Airtable to manage funding statements associated with tokens in a wallet.
Crypto, HTTP Request, Airtable
Stop wasting hours on manual dialing and listening to ringtones. This workflow transforms your Airtable into a high-velocity AI Call Center using Vapi AI**.
Airtable, HTTP Request
How it works
Airtable Trigger, Sendinblue, Airtable +1
Reel-Analysis-Of-Favourite-Content-Creator. Uses httpRequest, airtable. Scheduled trigger; 26 nodes.
HTTP Request, Airtable