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
- Keep inventory in one Google Sheet with clear column headers.
- Open Gemini in Sheets and ask a question about it.
- 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)