AI stock control for cafes: five weekly time savers

What changed in Google Sheets on Android?

Google began rolling out Gemini, its AI assistant, in the Google Sheets spreadsheet app on Android on 9 September 2026. Google's announcement says eligible plans can ask questions about data, analyse it and create charts. That's a reason to try a weekly review on your phone, not a reason to change your whole stock system.

Complex edits and generating formulas, the instructions a spreadsheet uses to calculate things, remain jobs for the web version. Don't assume that access to questions and charts on Android includes every spreadsheet tool.

Start with records you can trust

For cafe stock management, I'd start with dated entries for deliveries, counted stock and waste. Record an agreed item name and unit each time, plus a reason when food is thrown away. Keep those types of entry separate so the sheet doesn't add a delivery to a stock count.

Use litres for milk rather than switching between cartons and bottles. Agree names for products too: dairy milk and oat milk must stay separate. If someone misses a count, mark it as missing rather than entering zero.

None of this needs AI. A simple spreadsheet with agreed headings may already save time on cafe stock checks.

Group waste notes without losing their meaning

In Google Sheets, the AI function, a spreadsheet instruction that asks the assistant to work with your entries, can group information into categories. That's a possible starting point for organising waste notes, not proof that every label will be right. It's where I'd start with AI for cafe spreadsheets.

I'd supply a fixed set of reasons such as unsold food, preparation offcuts and spoiled ingredients. Ask it to use those labels and mark anything uncertain for review. Keep the original note beside the suggested label.

For example, a note saying milk was left out shouldn't silently become expired stock. Those are different problems, and merging them hides what you need to fix.

Compare waste across recorded weeks

Once the labels have been checked, ask for a comparison of recorded waste by item and week. Request the dates covered and the entries behind each total. I'd use the spreadsheet's normal sums to check the amounts rather than trusting a tidy-looking answer.

For a cafe in Musselburgh, this might reveal repeated entries for unsold sandwiches. It doesn't prove the owner should prepare fewer: a closed lunch service or a missing waste record could change the picture. To reduce cafe food waste, check what happened before changing an order or a preparation habit.

Flag missing entries before the next order

Give the assistant your counting days and ask it to flag gaps, mixed units and entries that may have been recorded twice. Ask for the date and item for each issue, not a general claim that the records look fine. These are suggestions to check, not permission to delete anything.

An apparent duplicate could be a second delivery. A blank entry means unknown, not no stock, and the software cannot tell you what's on a shelf that nobody checked. If a simple spreadsheet rule already highlights blanks, keep that instead.

Draft a reorder review rather than an order

Use recorded stock, confirmed deliveries and order levels you've already set to prepare a list for review. Ask the assistant to flag items below those levels and show which records it used. Don't ask it to invent an ideal order from a few waste notes.

Check the fridge and cupboards before sending anything to a supplier. Include deliveries already due, upcoming closures and known bookings in your decision. I'd keep supplier orders under human control, especially while you're still finding mistakes in the records. If a normal spreadsheet calculation already does this, AI may add nothing.

Turn checked figures into a staff handover

After reviewing the numbers, try asking for a short note for the person opening next. It should name the items to count again, deliveries to confirm and waste patterns to watch. Tell it to use only the checked findings and not add advice of its own.

The saving here is rewriting, not judgement. Read the note before sharing it, and never treat it as food safety advice or permission to use food. Your usual food safety checks still apply.

I use the same draft-then-check rule when turning job notes into an AI quote draft. Preparing the words and approving them are different jobs.

When you should not buy AI stock control

If stock and waste aren't recorded consistently, start with a simple spreadsheet rather than an AI subscription. AI won't repair missing counts or work out what someone meant by an unexplained note. Fix the recording habit first.

Doing nothing is fine if your current sheet gives you the answers you need and stock checks aren't taking troublesome amounts of time. Don't upgrade a plan just to try an attractive chart. If you already have access through an eligible plan, test it on a copy of your records without handing it control of the live sheet.

Only pay for AI once a trial saves time after checking and correcting its output. That's the standard I'd use for my own work.

Measure the whole job before deciding

Time your current process from opening the records to finishing the order review or handover. Then time the same task using AI with comparable records, including preparing the data, writing requests, checking answers and fixing mistakes. Keep track of wrong labels, missed gaps and wrong totals as well as minutes. Write down the initial setup time separately so it doesn't disappear from the comparison.

Also watch whether recorded waste actually changes after you adjust something. Faster analysis doesn't by itself mean less food in the bin. Keep any purchasing changes small enough to review, rather than changing everything after a convincing answer.

How I approach cafe stock checks

My AI for your business service starts with the repetitive job you want help with, not a promise to replace your judgement. For a cafe in Leith, I'd look at the current records and choose a task with a result you can check.

WebLothian is affordable on purpose. I keep the work focused so a local business can get useful help without paying for changes it doesn't need. I quote every job in writing before work starts.

Doing nothing has a cost too. Every week the stock count eats an evening, the waste notes go unread and the same order goes in by habit, and the cafes down the road that get this under control spend that time on their customers instead.

If you'd like me to look at your stock sheet, book the free consultation (opens in a new tab). I'll help you decide whether a small AI trial or a simpler spreadsheet is the sensible next step.