Analyse and track inventory in a spreadsheet

Who did it: Hog Island Oyster Co. (San Francisco)

Staff use Gemini in Sheets to analyse and track growing inventory, making sorting and processing easier.

Time saved: not stated in the source.

Steps

1. Keep inventory in one Google Sheet with clear column headers.
2. Open Gemini in Sheets and ask a question about it.
3. Check the numbers it gives against the sheet.

The prompt

Example prompt written by FirstAIWin to match the documented task — not the original user's words. Replace the [brackets].

Using this inventory sheet, show me which items have dropped the most over the last 4 weeks and which are below [threshold]. Make a summary table.

Source: Google blog (Vendor blog)