A simple inventory tracker in Google Sheets with low stock emails

Short answer: Use a free Google Apps Script that keeps stock levels from a log of what comes in and goes out, and emails you each morning about anything at or below its reorder level. It runs in your own Google account; nothing is sent to us. Setup takes 5 steps: Make an Items tab; Make a Moves tab; Make a Settings tab; Paste the script; Update your stock.

How to set it up

1. Make an Items tab. Add a tab called Items with the headings SKU, Name, Reorder at and On hand. List each item with its reorder level; leave On hand empty, the script fills it.
2. Make a Moves tab. Add a tab called Moves with the headings Date, SKU, Quantity and Note. Each delivery is a row with a positive quantity; each sale or use is a row with a negative one.
3. Make a Settings tab. Add a tab called Settings and type the email for low stock alerts in B1.
4. Paste the script. Open Extensions, then Apps Script, paste in the code from our email, and save. Reload the sheet and a Inventory menu appears.
5. Update your stock. Choose Inventory, then Update stock now. On hand fills in for every item. Choose Check stock every morning to have it updated, and any low items emailed, around 7 each day.

Want this set up for your business? Free written scope in 20 minutes

Get the script

Good to know

• Your starting stock is just a first Moves row with a positive quantity.
• SKUs are matched without regard to upper or lower case.
• Selling on Shopify? Our low stock alert script reads stock straight from a sheet export.

Questions

What does this script do?

It is a free Google Apps Script that keeps stock levels from a log of what comes in and goes out, and emails you each morning about anything at or below its reorder level.

How do I set it up?

In 5 steps: 1. Make an Items tab; 2. Make a Moves tab; 3. Make a Settings tab; 4. Paste the script; 5. Update your stock. 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.