Gemini Text prompt

Inventory Tracker Sheet Template

Get a ready inventory sheet design with columns, formulas and low-stock alerts for your shop.

Free No login · Commercial use allowed · Copy and use
  • 0 times copied
  • 77 words
  • Updated November 10, 2026

The prompt

Design a simple inventory tracker in Google Sheets for a [type of shop] with about [number] products.
Give me:
1. Sheet structure: tab names and columns (product, SKU, opening stock, purchases, sales, closing stock, reorder level, supplier)
2. Formulas for closing stock and a 'Reorder' status that shows when stock is below the reorder level
3. Conditional formatting rules (red for reorder, yellow for low)
4. A weekly summary tab with total stock value
5. Step-by-step setup instructions a beginner can follow

What to write in the [brackets]

ReplaceWith
[type of shop]e.g. hardware store, pharmacy, boutique
[number]Approximate number of products

How to use this prompt

  1. Click "Copy prompt" above.
  2. Open Gemini (the free version works for most prompts).
  3. Paste the prompt and replace every part in [square brackets] with your own details.
  4. Send it, then ask follow-up questions to improve the answer (e.g. "make it shorter", "write it in Hindi").
  5. Check facts, prices and numbers before you use the result with customers.

Tips for better results

  • Ask Gemini to create it directly in Google Sheets if you use Workspace.
  • Update sales daily — it takes 5 minutes.

Try these variations

After the first answer, send one of these as a follow-up message:

  • Add a supplier purchase order tab.

FAQ

Does this prompt work only with Gemini?

No. It works in ChatGPT, Gemini, Claude and most other AI chat tools. Results vary a little between tools.

Is this prompt free to use for my business?

Yes. All prompts in the Cracckk Prompt Library are free, including for commercial work. Always check AI output before you publish or send it.

Can I use it in Hindi or another Indian language?

Yes. Add a line like "Reply in Hindi" or "Use Hinglish" at the end of the prompt.