Skip to content

Closet inventory from purchase and sale emails

A weekly run reads your inbox for purchase confirmations and resale item sold notices and drops them in a review tray. Nothing enters or leaves your closet inventory until you confirm it.

Ecommerce and resaleWorks with Claude Code · Claude Desktop with MCP+1Community example
Build your promptSee requirements

What it does

  • Checks the week's mail for new purchase confirmations
  • Spots resale sold notices and matches them to a listed item when confident
  • Adds both to a pending tray with the source email subject
  • Tracks items listed for sale, where and at what price
  • Clears items marked gone more than a year ago

Your approval boundaries

Approval required

These actions always wait for your yes:

  • Adding a purchase to the closet
  • Marking an item sold or gone

You decide what happens next.

More about this workflow

This setup is for online sellers and resale shops juggling listings, orders and buyers. It takes a repeat chore off your plate and hands back something you can check quickly.

First, it checks the week's mail for new purchase confirmations. Next, it spots resale sold notices and matches them to a listed item when confident. Then it adds both to a pending tray with the source email subject. After that, it tracks items listed for sale, where and at what price. Finally, it clears items marked gone more than a year ago. It works with your email, photo storage and database, each on its own login with limited access.

You get the prep work done and waiting for you. The agent stops and asks for your yes before adding a purchase to the closet and marking an item sold or gone, and says plainly if a step cannot be undone.

“Nothing reaches the closet until you tap Add to closet or Mark as gone.”
techymara techymara on GitHub · Sep 24, 2026
Before you startEmail · Photo storage accessScoped permissionsClaude Code or Claude Desktop with MCP
Explore required tools and model recommendations

Tools and access

  • Gmail

    Handles the email part of this job. Grant read-only plus compose (drafts) scopes.

    API required: Yes. Needs a Google Cloud project with an OAuth app and the Gmail API turned on. The agent signs in through OAuth with only the scopes you pick.

    Sign up: Google Workspace

  • Photo storage

    Handles the photo storage part of this job. Grant read-only access to one photo folder.

    API required: No. A shared folder or drive for item photos. No API needed if the agent can read it.

    No sign-up needed

  • Supabase

    Handles the database part of this job. Grant a role limited to one table.

    API required: Yes. Needs a Supabase project and an API key. Give the agent a role limited to one table.

    Sign up: Supabase

Official links only. Not sponsored, no affiliate links.

Model recommendations

Best pick

Gemini 3.8 Flash

Built for agent workflows, with a free tier to test on.

$0.75 per million input tokens and $3.75 per million output tokens through December 31, 2026. $1.50 and $7.50 from January 1, 2027.

Google docs as of October 11, 2026

Cheaper backup

Gemini 3.5 Flash-Lite

Low cost for many listings at once.

$0.30 per million input tokens, $2.50 per million output tokens.

Google docs as of October 11, 2026

Our own picks. Not sponsored, no affiliate links.

Build your prompt

Add your details, then copy the prompt into your tool.

1Your details

Fill these in and the prompt updates as you type.

app, sheet or page

e.g. clothing, shoes, bags

2Your prompt

4 of 4 still empty
Fill these in before you run it: [INVENTORY LOCATION: app, sheet or page] [RESALE SITES YOU USE] [RUN DAY] [CATEGORIES: e.g. clothing, shoes, bags] You are the Closet inventory from purchase and sale emails agent. A weekly run reads your inbox for purchase confirmations and resale item sold notices and drops them in a review tray. Nothing enters or leaves your closet inventory until you confirm it. Use only the details filled in above. If any [BRACKETED] item is still blank or unclear, stop and ask for it first. Do not guess. What you do on your own: - Checks the week's mail for new purchase confirmations - Spots resale sold notices and matches them to a listed item when confident - Adds both to a pending tray with the source email subject - Tracks items listed for sale, where and at what price - Clears items marked gone more than a year ago What you must never do without a yes from a person: - Adding a purchase to the closet - Marking an item sold or gone Rules: - Before any step on the list above, stop and ask. Say in plain words what you want to do, who it affects, and whether it can be undone. - If something cannot be undone, say so first, in one short line. - Write drafts, not final actions. A person sends, pays, posts, or deletes. - Keep a short log of every action you took and every source you read. - If you are unsure, ask instead of guessing.
View run instructionsPaste into: Claude Code, Claude Desktop with MCP, Zapier Agents

Your answers stay in this browser only.

Run your workflow

Connect your tools with only the access this setup needs, then follow these steps.

Steps

Do these in order. Test on old data before it touches live work.

  1. 1Connect Gmail with its own login, not yours. Grant read-only plus compose (drafts) scopes.
  2. 2Set up Photo storage. Keep it to read-only access to one photo folder.
  3. 3Connect Supabase with its own login, not yours. Grant a role limited to one table.
  4. 4Paste the prompt where your harness takes instructions. See the note under the Copy button.
  5. 5Do a dry run on old or test data first. Check every draft and every stop point by hand before you let it near live work.
  6. 6Read its log after the first real run. Only widen access once a week of runs looks clean.

Safeguards and trust score

The score describes this example setup’s access, approval boundaries, ability to undo changes, and scope.

Access18 / 30

Can draft things that send or spend, so it sits close to risky actions.

Human approval30 / 30

Waits for a yes on: adding a purchase to the closet, marking an item sold or gone.

Undo and logs14 / 20

Proposes changes to live records, so the setup needs a change log and a way back.

Scope16 / 20

Runs on its own login across 3 tools. Fewer connections means a smaller blast radius.

How to raise it

  • Access: Take away its ability to send, post or spend. Let it only write drafts, and have a person press send or pay from their own account +6
  • Undo and logs: Stop it from editing live records. Have it write the change as a proposal you apply, and keep a log of every change with a way to roll it back +3
  • Scope: Cut it down from 3 connected tools to the 2 it needs most, each with its own limited login instead of your full account +2

Do all of these to reach 89, up from 78.

Want help getting there? Get an AI Trust Audit from Pixeldesigns

Reviewed by Trustcase (example setup). How scoring works

Embed badge

Show this trust score on your site or README. It links back here.

Trustcase trust score badge
Markdown
[![Trustcase trust score for Closet inventory from purchase and sale emails](https://trustcase.dev/badge/closet-inventory-from-purchase-and-sale-emails.svg)](https://trustcase.dev/use-cases/closet-inventory-from-purchase-and-sale-emails)
HTML
<a href="https://trustcase.dev/use-cases/closet-inventory-from-purchase-and-sale-emails"><img src="https://trustcase.dev/badge/closet-inventory-from-purchase-and-sale-emails.svg" alt="Trustcase trust score for Closet inventory from purchase and sale emails" height="20"></a>

More ecommerce and resale workflows