Short answer: Use a free Google Apps Script that emails you once when an item drops to its reorder point, and not again until it's restocked. It runs in your own Google account; nothing is sent to us. Setup takes 5 steps: Set up the Inventory tab; Paste the script; Install the checks; See it work; Use it for any number.
How to set it up
- Set up the Inventory tab. Make a tab called Inventory with the item, how many you have, and the level where you want to reorder.
- Paste the script. Open Extensions, then Apps Script, and paste in the code below, and put your email address at the top in place of you@yourbusiness.com.
- Install the checks. The first time it runs, Google asks for permission because the script works in your own account. Review it and allow it; that only happens once. Run
installTriggersonce. It checks whenever someone edits the sheet and every hour as well, so imports and form entries are caught too. - See it work. Drop an item below its reorder point and the alert arrives. Edit it again and no duplicate is sent. Restock it and the alert resets for next time.
- Use it for any number. It works for any number you want to watch, not just stock.
Want this set up for your business? Free written scope in 20 minutes
Get the script
Download it free
We'll email you the script (Code.gs). It runs in your own Google account; nothing is sent to us.
Ready-made copy
A Google Sheet with the tabs and the script already in place: click Make a copy and it works.
$19 one-time, emailed straight after payment.
Have us install it for you
We set it up in your Google account in a short Connect session, connect it to your sheet and check that it runs.
$49 one-time.
Questions
What does this script do?
It is a free Google Apps Script that emails you once when an item drops to its reorder point, and not again until it's restocked.
How do I set it up?
In 5 steps: 1. Set up the Inventory tab; 2. Paste the script; 3. Install the checks; 4. See it work; 5. Use it for any number. The full steps are on this page.
Is it free, and does it send my data anywhere?
It is free: enter your email on this page and we email you the script (Code.gs). It runs in your own Google account; nothing is sent to us.
Can you install it for me?
Yes. We set it up in your Google account in a short Connect session, connect it to your sheet and check that it runs.
Want this connected to the rest of your tools? Send us a short brief.
Pushbuild · Automate your business with Pushbuild: pushbuild.com/