← Back to library

Load a weekly grocery basket from a rules spreadsheet

Christina Souch, tired of weekly re-picks on her UK grocer site, had Claude draft a 40-plus product spreadsheet with quantities and rules, then load the basket via Claude in Chrome. Early runs pulled every saved regular, stalled, invented an extra item or stopped early. Strict prompt rules mostly fixed it; checkout stayed hers.

  • OutcomeHave a browser agent load your regular shop into the basket from a spreadsheet, leaving review and checkout to you.
  • SetupUnder an hour
  • LevelStarter
  • CreditChristina Souch
View original
Works with
Claude

Published Oct 23, 2026Updated Oct 23, 2026AI dry run on sample input: passed Oct 23, 2026Source verified Oct 23, 2026

When should you use it?

  • Your weekly shop is mostly the same items
  • The store's reorder feature is clumsy
  • You will check the basket before paying

Not for: Letting an agent check out or pay; Very long lists in one run, which may hit limits

What do you need, and what do you get?

You need

  • A sheet of exact product names, quantities and frequency
  • Conditional rules such as price caps or multibuy
  • A signed-in store account in the browser

You get

  • A basket filled only from your list
  • A note of items it could not find

How does it work, step by step?

  1. Build the list firstUse exact product names from the store, plus quantity, weekly or monthly, and any price rule.
  2. Let the list decide everythingTell the agent it may use saved favorites to find items but must add nothing that is not listed.
  3. Search exact namesForbid shortened search terms so it finds the right product.
  4. Split long listsRun 40-plus items in two batches if it stalls.
  5. Review, then check out yourselfRemove extras, add misses and pay manually.

The prompt

The original prompt by Christina Souch, word for word, with a link to where it was published. Below it is our adapted version with fill-in blanks, if you want it. Works in Claude. Values in lime are placeholders.

Original prompt by Christina Souch

Word for wordby Christina Souch
The spreadsheet is the ONLY source of truth for what to buy. You may use Favourites or Regulars to find items faster, but:
- ONLY add items that appear in the spreadsheet
- If an item is in Favourites but NOT in the spreadsheet → skip it
- If an item is in the spreadsheet but NOT in Favourites → search for it When searching, use the EXACT product name from the spreadsheet. Do not shorten, simplify, or optimize the search term. Copy the full product name directly from Column A. Never add anything not explicitly listed in the spreadsheet.

Exactly as published by Christina Souch in Can Claude Automate My Grocery Shopping?.

Our adapted version (optional)

Adapted prompt0 variables
Fill my basket on [store site] using only the Google Sheet [link]. Nothing outside the sheet counts. My saved favorites may help you locate products quickly; still, add only items listed in the sheet, in the stated quantity. Type the full product title from column A into search, word for word. Apply the rules in column D (price caps, multibuy). Never add anything not listed. Do not check out. When done, list any items you could not add and why.

What can go wrong?

  • Bulk-adding from saved regulars ballooned one test basket to over three times the usual spend.
  • It claimed in-stock items were unavailable when it simply stopped; check the missing list.

Our take

Christina Souch's write-up is one of the most honest grocery-agent reports available, and the failure list is the valuable part. Early runs grabbed everything saved as a regular, invented items, stalled or stopped short, which is exactly the chaos you should expect until rules are tight. The fix that mattered was making the spreadsheet the single source of truth and forbidding creative searching: if it is not on the list, do not add it. Treat the agent as a basket loader, never a buyer. Review the cart, add anything missing, remove mistakes, and check out yourself. Split long lists into batches if the session times out. Exact product names and pack sizes beat vague descriptions, and a column for weekly versus monthly items prevents over-ordering. Her verdict that it was not yet faster than doing it by hand is worth remembering before you depend on it; the win may be consistency and fewer forgotten staples rather than speed. Save the working prompt and sheet together so next week starts from a known good state.

Where the time goes back: Once the rules are tight, the repetitive part of the weekly shop is loaded for you to review.

FAQ

Did it save time in her tests?
Not yet, in the author's tests, but the basket was mostly correct after tightening the rules.
Can it run weekly?
She notes it can be saved as a shortcut and scheduled, with you still reviewing.

Source and credit

The original prompt on this page is by Christina Souch, shown word for word with a link to where it was published. The summary, notes and adapted version are ours.

Original
Can Claude Automate My Grocery Shopping?
Creator
Christina Souch
Published on
christinasouch.com
Original date
Jan 27, 2026
License
Not openly licensed; the original prompt is shown word for word with credit and a link to the original
Originally for
Claude
AI dry run
Oct 23, 2026: passed. Dry-run tested by our AI test agent on sample input. PASS: Gates held on desk check; no live sends or purchases.
AI dry run on sample data; not run with live connected accounts. The playbooks.bot test agent filled the prompt with synthetic inputs, produced the output and checked it against the page's stated outputs and guardrails.
Verified
Oct 23, 2026: source link resolves to the original, the credited creator published it, our excerpt or prompt matches it, and the license allows our use.

Are you the creator? Claim or correct this page.

More in Food & Health

All 35 Food & Health playbooks →

Related playbooks

Food & HealthRoutine✓ AI dry run

An agent that watches for clinical trials for your diagnosis

Get a short morning alert only when a trial, approval or study that matches your diagnosis is new, with the source attached, so you can take it to your doctor.

Credit: Kevin Wimer (@kevinace)

Under an hour
Food & HealthWorkflow✓ AI dry run

Build a private, offline health tracker by chat

Describe the readings you need to track and build a phone web app with an AI that stores everything on the device, with no account.

Credit: u/TheVPAline on r/ClaudeAI

An afternoon+
Food & HealthWorkflow✓ AI dry run

Build one care file for a relative seen by many doctors

Gather a loved one's records from every specialist into one place an assistant can review, so medication and record inconsistencies become questions for the care team.

Credit: light_hue_1 on Hacker News

An afternoon+
Food & HealthRoutine✓ AI dry run

Set up a ChatGPT coach that helps someone start hard tasks

Help an adult family member who struggles to get going (for example with ADHD) set up their own ChatGPT with one main conversation for scheduling and check-ins, a separate Project for each big task, and instructions that ask a single question per turn and always end with a small, clearly finished next step.

Credit: u/Worldly_Beautiful557 on r/ChatGPT

Under an hour