Inventory Reorders
Monitors inventory levels on a schedule, calculates reorder quantities, posts pending requests to Slack for approval.
ops and IT teamsE-commerce Operator
What it does
You get automated inventory reorders that calculate exact quantities based on your sales history and send approval requests directly to Slack. Once you approve a request with a reaction, the system automatically emails the vendor and updates your Google Sheets status without manual follow-up.
Step by step
- Parse the JSON payload from the Google Sheets webhook to extract product SKUs and current stock levels.
- Apply the reorder formula (Target Stock - Current Stock + Lead Time Sales) using standard arithmetic operations in code.
- Construct a formatted Slack message object with attachment blocks for the pending approval request.
- Update the specific row in Google Sheets by writing 'Approved' or 'Rejected' to the status column after receiving the webhook callback.
Where the LLM does the work
- Generate clear, concise email templates for vendors that adapt dynamically based on product category and urgency.
- Draft human-readable error messages for Slack notifications when inventory data is missing or malformed.
- Create logic descriptions for edge cases like zero-stock items or discontinued products to ensure the agent handles them gracefully.
Watch out for
Google Sheets webhook payloads may include hidden rows if not filtered correctly, add a check to skip empty or archived products.
Email authentication failures can cause orders to bounce, verify SPF and DKIM records are set up for your sending domain before launch.
Tools that fit
Code LLM Calculate stock runway and quantities
The agent brief
Everything your agent needs, including the gotchas. Copy it and go.
You are helping me build the following AI agent workflow. ## Goal Inventory Reorders: Monitors inventory levels on a schedule, calculates reorder quantities, posts pending requests to Slack for approval. ## Specification - What it does: You get automated inventory reorders that calculate exact quantities based on your sales history and send approval requests directly to Slack. Once you approve a request with a reaction, the system automatically emails the vendor and updates your Google Sheets status without manual follow-up. - Trigger: Triggered by an event (Scheduled · daily) - Autonomy: You approve along the way - Expected setup effort: about an afternoon - Tools/services involved: - Google Sheets: Store inventory and vendor data - Slack: Notify team and approve reorders - Gmail: Send vendor reorder emails - Code: Calculate stock runway and quantities ## Known pitfalls, handle each one explicitly in your implementation 1. Google Sheets webhook payloads may include hidden rows if not filtered correctly, add a check to skip empty or archived products. 2. Email authentication failures can cause orders to bounce, verify SPF and DKIM records are set up for your sending domain before launch. ## Reference implementation https://n8n.io/workflows/16473 (workflow template) Fetch and inspect this before building. If it matches my stack, adapt it; if not, rebuild the pattern with my tools. ## Process requirements 1. Before building: ask me which of the listed tools I actually use and what my platform is (n8n / Make / code / other). Do not assume. 2. Adapt the pattern to my answers; do not force the reference stack. 3. Address every pitfall above; tell me how you handled each. 4. Provide a test plan I can run before letting this touch real data. 5. Ask before any step that sends messages, modifies data, or spends money. Source: https://usecasesforagents.com/use-case/automate-inventory-reorders/ via usecasesforagents.com
Frequently asked questions
Can I use a different Spreadsheet than Google Sheets?
Yes. Google Sheets is only the example spreadsheet in this recipe. The same flow works with Airtable, Baserow and Excel. Swap the spreadsheet connection and keep the rest of the setup as written.
Want this running in your business?
This is what I do. I design and build AI agents like this one, and keep them running. If you want it set up for your team instead of doing it yourself, get in touch.
Who it's for
Built for Ops-IT teams who need one more recurring task off a human's plate.
Also fits E-commerce Operator.