Recipe No. 50 · Operations
Weekly supplier order list
Every week, email suppliers the items that fell below par in your stock sheet.
- Serves
- Cafés & restaurants
- Made with
- n8n
- Prep (setup)
- ~45 min est.
- Yield
- 1–2 hrs/week saved, est.
- Level
- Intermediate
- Plan needed
- n8n: free to self-host (you pay hosting) or n8n Cloud (paid). Check your plan.
- Est. SMS cost
- No SMS needed
- TriggerSchedule Trigger
- Step 2Google Sheets 'Get Rows'
- Step 3Code/Set node
- Step 4Gmail 'Create Draft' per supplier
- Step 5Test with dummy data, then turn it on and…
Ingredients
- Google Sheets inventory with par levels
- n8n
- Gmail
Editor-reviewedLast checked 2026-10-16v1.0.0 · Free
Steps reviewed against current tool UIs by the editor; not yet run end-to-end in a live account. Time saved is an estimate; results vary. Costs from Axis Consulting and Twilio pricing; check current pricing.
Method
- Schedule Trigger: Thursday 15:00.
- Google Sheets 'Get Rows'; Filter: on hand < par.
- Code/Set node: order qty = par − on hand; group by supplier.
- Gmail 'Create Draft' per supplier (review before sending).
- Test with dummy data, then turn it on and review results for the first week.