Use case P61 · Human
Grocery shopper uses ChatGPT to find patterns in her receipts and plan around food already at home
- Money and shopping
- Beginner
- ChatGPT, Google Sheets
- Source checked · news article
The short version
What they did
Amanda Claypool logged her grocery receipts in a spreadsheet and asked ChatGPT to analyze purchase frequency and spending. She graphed her cheddar purchases and used the broader patterns to stock staples and plan meals around her pantry. Her reported change in shopping habits is the result here, not a verified savings amount or proof that buying larger packages always costs less.
Result (as claimed)
“Instead I now plan around what I already have in my pantry. So I end up making fewer trips to the store and use up what I have on hand first.”
“I’ve started stocking up on staples like sour cream, tofu, and even cashews to reduce the number of last-minute trips I need to make in between shops.”
Prompt
I want to understand my grocery buying habits and plan meals around food already at home. My purchase log is [attach spreadsheet with dates, stores, items, quantities, units and prices]. My current pantry list is [paste list].
1. Group purchases by item and category, showing total spending and days between purchases for common staples.
2. Make a chart of [item] over the period covered by the log.
3. Suggest three meals using my pantry and a short shopping list for missing ingredients.Give me a compact table, the chart and plain-English observations. Check totals with calculations and flag missing quantities or unclear units. Don’t assume larger packs save money; calculate comparable unit prices only where the data supports it. Don’t claim savings the log doesn’t show.
Do it yourself
These steps are my suggested way in, not Amanda’s setup.
What you need
- A chat assistant that can read spreadsheets and make charts, such as ChatGPT, Claude or Gemini.
- A month or more of grocery receipts or order history.
- A spreadsheet, such as Google Sheets or Excel.
Start simple
- Log each receipt in a sheet: date, store, item, quantity, unit and price.
- Upload the sheet and paste the prompt above.
- Ask which staples you buy most often and how many days pass between purchases.
- Ask for a chart of one item you think you overbuy.
- Write your pantry list and ask for three meals that use what you have.
Take it further
- Take photos of receipts and ask the AI to turn them into rows, then check them against the paper.
- Keep a short staples list with how much to keep on hand.
- Ask it to compare unit prices between pack sizes, using the numbers in your log.
Check your work
- Add up one week’s totals yourself and compare them with the AI’s.
- Spot-check a few rows against the receipts. Misread prices and quantities are common.
- A bigger pack only saves money if you use it before it spoils. Check the math and your waste.
Others did this too
- Grocery shopper uses ChatGPT to flag odd entries in her spending tracker and checks them against receipts. Joyce Zahariadis, 2026-08-05, blog post. “It helped me catch mistakes, notice repeats, separate categories, and ask better questions before placing another order.”
Source checked. The link, author, date and quote were confirmed against the source. The result itself has not been reproduced. Prompt adapted for this library, inspired by the case. Business size: Individual. Results are quoted as the source claimed them and never improved. Spot an error or a broken link? Email charlie@cbarmorecpa.com.