Skip to content
For Companies in Egypt 🇪🇬Request an on-site engineer visit for turnkey setup & direct supportBook a visit
Sheet Pulse

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

  1. 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.

  2. 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.

  3. 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.

Stock alerts

📦 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

The store keeper recorded today's issues and the quantity went from 11 to 8, so the message reached the buyer to order from the supplier before it ran out.

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.

Sheet Pulse

Orange juice 1L sold 3

12:15

✅ Done: quantity is now 21 (was 24)

Item: Orange juice 1L

12:15

The salesperson recorded the sale with one message from the shop, and the quantity came off the sheet right away.
  • 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.

All frequently asked questions

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.