Codex to predict household reorders by use

Sachiko had already been tracking household purchases in a spreadsheet and checking twice a month when supplies might need replacing. Codex took over the preparation: on the first and fifteenth, it reads order emails and the purchase-history sheet, including purchases made between scheduled checks.

The updated history supports an estimate of what may be needed before the next review. The sheet separates likely purchases, product capacities and prices, past orders, and the calculation rules. That makes the reminder more specific than a generic instruction to check the cupboard.

An important adjustment was grouping history by use rather than exact product name. Changing shampoo brands or tissue products should not reset the household's buying cycle. The actual product, capacity and retailer remain separately recorded. Price comparisons between Amazon and Yodobashi Camera are normalized to a matching unit, such as each item or each millilitre, instead of comparing a refill pouch with a multipack's total price.

Codex puts the result in a Gmail draft containing candidate items, prices and unit costs. It does not send the email or place orders. Sachiko checks what remains at home and decides whether preferences or slower consumption make a suggested purchase unnecessary. The reported result is a recurring shopping memo in an inbox she already uses, not a measured saving or guaranteed depletion forecast.

Prompt
Suggested prompt (written by Agents In Use, not the author's)

Source: note.com · さちこ (@00sachiko)