A Granola Maker Organizes Stock Tracking With Gemini in Sheets, Saving 20 Hours a Week
Google's Workspace blog says Jamie's Farm granola uses Gemini to organize its stock tracking, saving her 20 hours a week on paperwork. Gemini in Sheets builds tables, formulas, pivot tables and charts from a prompt.
Who this is about: Granola maker (Jamie's Farm)
What it takes
- Cost
- Free planGemini: Free with a Google account. Google AI Plus is $4.99 a month and Google AI Pro is $19.99 a month; Ultra starts at $99.99.Price checked Oct 15, 2026 on gemini.google. Prices change; check before you buy.
- Setup time
- An afternoonOur estimate from the source, for one business.
- Skill needed
- No codeApps and settings only.
Explain it simply
Gemini sits in a side panel in Google Sheets. You describe what you need, like a reorder list that flags items running low, and it builds the table, formulas or chart for you. A small food business uses it to keep stock records in order.
What was done
The owner keeps stock counts in Google Sheets and uses Gemini to organize the tracking. The blog doesn't publish her prompts; ours are based on Google's help page for Gemini in Sheets.
How it went
Google's blog: "Gemini helps her organize her stock-tracking, saving her 20 hours a week on paperwork."
- A Google post about a Google product, with no detail on how the 20 hours were counted.
- Gemini in Sheets needs an eligible Workspace or Google AI plan and works best on native Sheets files rather than .xlsx.
Prompt
Context: You are the owner of a small product business keeping stock in a Google Sheet with one row per SKU per week.
ASK GEMINI PROMPT 1 (set up):
"In this sheet, columns are [COLUMN_LIST]. Create a new tab called Reorder. For each SKU, calculate average weekly units sold over the last [WEEKS] weeks, weeks of stock left (on hand / average weekly sales), and a reorder point = average weekly sales x (supplier lead time in weeks + [SAFETY_WEEKS]). Add a Status column that says REORDER when on hand is below the reorder point."
ASK GEMINI PROMPT 2 (format):
"Apply conditional formatting to the Reorder tab: red fill when Status is REORDER, amber when weeks of stock left is under [AMBER_WEEKS]. Sort by weeks of stock left, smallest first, and freeze the header row."
ASK GEMINI PROMPT 3 (weekly):
"Create a pivot table of units sold by [CHANNEL_COLUMN] and SKU for the last 4 weeks, and a chart of the top [TOP_N] SKUs. Then list in plain words the 5 SKUs I should reorder this week and why."Our template, written from the source and the vendor docs; the source did not publish its own prompt. Replace the [brackets] before you use it.
Business fit
Who this helps, and how:
Food and product makers: build a reorder tab that flags low stock from your counts and sales.
Shopify & ecommerceCafés and shops: turn a messy stock sheet into a weekly summary without writing formulas.
Local & service
Related
- Evidence grade CA Granola Maker Checks Long Retailer Manuals in NotebookLM Before She ShipsVendor or secondhand, using Gemini Notebook (NotebookLM)
- Evidence grade DDraft Client Replies and Proposals With the Gemini Already in Your Workspace PlanLight evidence, using Gemini and Google Workspace
- Evidence grade BA Café Owner Turns a Photo of the Inventory Sheet Into Shopping Lists by StoreStrong evidence, using ChatGPT, Slack and Obsidian
- Evidence grade DTurn a Narrated Phone Video of a Task Into a Printable Staff SOPLight evidence, using Gemini
- AI operations examples small businessDepartment hub: AI for operations, 57 examples
Similar tools
Other tools for this job, and how they differ. Chosen by our editors, never paid for.
- Microsoft 365 Copilot
Copilot in Excel does similar table and formula work with a Copilot licence.
- ChatGPT
Can analyze an uploaded spreadsheet, but outside your live sheet.
“Vendor or secondhand” (grade C) means: A tool maker's case study, a promotional demo, or someone else's write-up. How we grade. Spotted a mistake? Suggest a correction.