The problem: You run low on something important at the worst time, or you over-order because you guessed. Keeping track of stock and reorder points by memory doesn't scale.
What you end up with: A weekly list of items running low, based on your stock sheet and reorder points, with a draft order email to each supplier ready for you to check and send.
What you'll need
A simple stock sheet with each item, current count, reorder point, usual order quantity, and supplier contact.
Getting set up
Running out of stock because reorders slipped through the cracks? Here's how to tackle it, based on each tool's official docs. First, pick a tool. Google says Gemini in Sheets works with your data using plain-English prompts, and Gemini in Gmail can draft professional emails. Microsoft says Copilot in Excel analyzes data, and in Outlook it drafts emails. xAI lists routines on a schedule in every Grok Bot plan. Next, set a reorder point for each item, the count that means it's time to order. Then, pick a weekly count day. And last, the agent flags and drafts. You approve and send every order.
Step by step
- Update your stock counts on count day.
- Have the agent list every item at or below its reorder point.
- Ask it to group those items by supplier.
- Have it draft one order email per supplier, using your usual quantities.
- Check quantities, prices, and delivery timing.
- Approve and send each order yourself.
- Log what you ordered, so next week's list knows it's on the way.
A prompt to start with
Copy this prompt, then make it your own. "Using this stock sheet, list every item at or below its reorder point, grouped by supplier. For each supplier, draft a short, polite order email using our usual order quantities and ask them to confirm price and delivery date. Don't change quantities or add items. Mark anything unclear with [CHECK]."
What you'll get
A low-stock list grouped by supplier, and one draft order email per supplier, ready to approve.
If something goes wrong
If it flags items you've already ordered, add an "on order" column. If reorder points feel wrong, adjust them after a few weeks of real use. If seasonal items run out, raise their reorder points ahead of busy times.
Keep in mind
Counts are only as good as your sheet. Check prices and terms before you send. The agent doesn't place or pay for orders. You approve and send each one.
Sources
- Google Workspace — AI tools for business
- Microsoft Copilot for small business — product page and FAQ
- Grok Bot — official product page (xAI)
Where each fact came from
- Recommended tools · checked Oct 28, 2026 · rechecked regularly — Google Workspace — AI tools for business
- Getting set up · checked Oct 28, 2026 · rechecked regularly — Microsoft Copilot for small business — product page and FAQ
Heads-up: some links here may become affiliate links down the road. Here's how that works. Right now, no affiliate programs are connected.