Warehouses, stock and pharmacies
Low stock alert for Google Sheets: know before an item runs out
An item that runs out is a customer who goes elsewhere. With Sheet Pulse a message reaches the stock keeper or buyer on WhatsApp or Telegram when any item drops below the limit you set, and your team can take off what's sold or add what's received with one message from the phone, so the stock sheet stays right all day.
“It's out of stock” costs more than you think
In most warehouses and shops, stock lives in Google Sheets: quantities, minimums, goods in and goods out. But nobody watches every item every hour. So a salesperson finds the item gone with the customer in front of them, purchasing orders late, and goods leave the store without being recorded.
Sudden stock-outs
The quantity drops day after day, and nobody knows until it hits zero.
Late purchase orders
Purchasing learns of the shortage at the weekly count, and the supplier needs days.
A sheet that doesn't match the shelf
Sales and goods received aren't recorded on time, so the numbers drift.
How it works with your stock sheet, in three steps
Stock stays in the sheet
A column for the item and one for the quantity in Google Sheets, with a tab per store or branch if you like.
You set the limit for each item
The ready “number crossing a limit” card: “Quantity below 10”, for example. The message goes when the quantity crosses the limit, not on every edit.
The alert reaches the person in charge
A message on WhatsApp or Telegram with the item, quantity and supplier, to the stock keeper or buyer.
📦 Below the limit: Blue shirt M
Quantity now: 8 (limit: 10)
Store: main branch
Supplier: Nile Factory
Last purchase order: 3 October
Open the sheet
15:42
Six follow-ups that protect your stock
An item below its limit
Rule: the “Quantity” column goes below 10. Message: item, quantity and supplier, to the buyer.
An item out of stock
Rule: the “Quantity” column goes below 1. Message: to the store manager and the sales team's group, so nobody promises a customer an item that isn't there.
A new purchase order
Rule: a new row in the “Purchase orders” tab. Message: items, quantities and supplier, to the manager to approve.
Goods received
Rule: the “Receipt” column becomes “Received”. Message: order and supplier, to the accountant to record the invoice.
A big withdrawal
Rule: the “Issued” column goes above 100. Message: item, quantity and who issued it, to the store manager to review.
Damaged or returned
Rule: the “Status” column becomes “Damaged”. Message: item, quantity and reason, to the store manager.
“Sold 3” on WhatsApp, and the sheet updates
With smart replies a salesperson or store keeper never needs to open the sheet. They write the item's name with “sold 3” in a WhatsApp message, and the quantity comes off the balance in Google Sheets. They write “add 20” when goods arrive, and it's added. They can even add a new purchase-order row with one message. Sheet Pulse never guesses, says what it did, lets any mistake be undone with the word “undo”, and logs every movement with its sender.
Orange juice 1L sold 3
12:15
✅ Done: quantity is now 21 (was 24)
Item: Orange juice 1L
12:15
You decide who writes
Only the salespeople and store keepers you allow.
A log of every movement
Who took off or added, which item, and the quantity before and after.
Undo within 10 minutes
A wrong number? The word “undo” brings back the previous quantity.
For pharmacies: the medicine people ask for never runs out
In a pharmacy, an item out of stock means the patient goes to another pharmacy and may not come back. With Sheet Pulse a message reaches the pharmacist in charge of orders when any item drops below its limit, a transfer request between branches reaches the branch that has the stock, and the pharmacist records what's sold from the phone with one message.
A limit per item
Fast-moving items get a higher limit and rare ones a lower one, all in the sheet.
Transfers between branches
A new row in the “Transfers” tab reaches the sending branch to prepare the quantity.
The supplier order
Items below their limit reach the person in charge, or come in one daily digest before the morning order.
Who it's made for
Warehouses and distribution centres
Thousands of items and several stores: every shortage reaches its owner, every big withdrawal the manager.
Shops and stores
Salespeople record sales by message, and the owner knows what needs ordering.
Pharmacies
Items below their limit, transfers between branches and daily orders.
Factories and workshops
Raw materials and spare parts under watch, so production never stops for a missing item.
The store before and after Sheet Pulse
Without Sheet Pulse
- A shortage is found when a customer asks for a missing item.
- Purchasing learns at the weekly count.
- Sales are recorded at the end of the day, if at all.
- The manager never sees big withdrawals.
With Sheet Pulse
- Every item crossing its limit reaches its owner in good time.
- The purchase order goes out before the stock-out.
- Every sale is recorded with one message from the phone.
- Every big withdrawal reaches the manager.
All from the stock sheet you already use in Google Sheets: no new inventory software and no training. The alert arrives on the WhatsApp or Telegram your team uses every day.
Stock and warehouse questions
Will I get a message every time the quantity changes?
No. A “below” rule fires when the quantity crosses the limit, not on every edit. If it drops from 11 to 8 you get one message, and it doesn't repeat when it drops to 7.
How does a salesperson take off what's sold from WhatsApp?
With smart replies: they write the item's name with “sold 3”, the quantity comes off the sheet, Sheet Pulse answers with the new quantity, and any mistake can be undone.
Does it understand Arabic digits?
Yes. Whether the quantity is written ٨ or 8 in the sheet, Sheet Pulse reads it and compares it with the limit.
I have several stores or branches. Can I keep them apart?
Yes. Watch one sheet per store, or one tab per branch in the same sheet, and send each branch's shortages to its owner or its team's group.
Can I get one summary of shortages instead of many messages?
Yes. Set the rule to the daily digest, and every item that dropped below its limit arrives in one message in the morning.
Does it suit pharmacies?
Yes. A limit per item, transfers between branches, and sales recorded by message. Alerts reach the pharmacist in charge and their team.
How much does Sheet Pulse cost for a store or pharmacy?
Talk to our sales team on WhatsApp: we learn how many items and branches you have, and send you the right offer.
You may also like
- Late payment alertsSupplier and customer invoices and late amounts to accounts.
- Update Google Sheets from WhatsApp“Sold 3” by message, and the quantity updates in the sheet.
- Google Sheets WhatsApp alertsEverything Sheet Pulse does, on one page.
- Request a quoteLeave your details and we will reach you on WhatsApp with an offer that fits how you work.
Know about a shortage before your customer does
Message our sales team on WhatsApp and we will set up your stock alerts on your own sheet.