Before you start
A customer sheet and instructions so your AI employee checks before it recommends. It never offers anyone what they already returned, and it never keeps what it shouldn't.
- Cost: $0.
- Time: 15 minutes.
- Accounts: a free AI chat (ChatGPT, Claude or Gemini) and a spreadsheet (Google Sheets, Excel or Numbers).
- Files:
customer-sheet.xlsxandlookup-instructions.md.
The 5 steps
- Open the sheet. Upload
customer-sheet.xlsxto Google Sheets (File → Import) or open it in Excel. Read the Never keep tab before you write anything. - Fill in your customers and your catalog. Delete the sample rows. One row per customer: first name, last 4 of their phone, size, likes, what they bought and what they returned, with the reason. Under Don't offer, what you won't show them again. In Catalog, only what you carry.
- Paste the instructions. Open a new chat (a project or a custom GPT is better, so you don't paste them every time). Paste the text from
lookup-instructions.md, fill in the brackets and, below it, paste the Customers and Catalog tabs. - Test it. Send the four test messages at the end of the instructions. If one fails, see "If it fails".
- Use it every day. Before you reply to a customer, ask the chat what it would recommend. At the end, copy what it puts under FOR THE SHEET into your sheet if it looks right. You decide what gets written down.
How to know it worked
- With the sample sheet, it never offers Elena the Andes jacket in M again.
- If you ask about another customer, it refuses.
- If you give it a card number, it doesn't repeat it or write it down.
If it fails, check this
- Recommends something returned: make sure the item is spelled the same under "Returned" and in the Catalog.
- Makes up items: paste the whole Catalog, with headers.
- Talks about another customer: paste the full instructions again; the PERMISSIONS section has to be there.
- Mixes in other conversations: use a temporary chat or a project just for the store.
- Forgets the sheet in long chats: start a new chat each day, or use a project with the sheet as a file.
What it doesn't do
- It doesn't send texts or take payments: you reply to the customer.
- It doesn't keep cards, IDs, passwords, health details or full addresses.
- It doesn't decide complaints, returns or discounts: it hands them to you.
- A free AI chat may keep what you paste: don't paste anything listed under "Never keep." Check the privacy settings of the chat you use.
Did it work?
When it works, reply DONE to the message where you got this.
That one word tells us which material helps and which one needs to come down a rung.
Annex ALookup instructions: the salesperson who remembers every customer
Copy everything inside the box and paste it into your AI chat. Replace what's in brackets. Below it, paste the Customers and Catalog tabs from your sheet.
You are the salesperson for [your store's name], a clothing store. Customers text you. You are an AI employee, and you say so if anyone asks.
YOUR MEMORY
Below these instructions are the customer sheet (Customers tab) and the catalog (Catalog tab). Before you recommend anything, you always check them.
HOW YOU RECOGNIZE A CUSTOMER
- They give you their first name and the last 4 digits of their phone number. If that doesn't match a row, treat them as a new customer.
- New customer: ask their size and what they like before you recommend.
HOW YOU RECOMMEND
1. Only recommend items from the Catalog, in sizes that are in stock. If something isn't in the Catalog, say you don't carry it.
2. Never recommend anything listed under "Returned" or "Don't offer" for that customer. If they returned it for size, offer another size or another item, and say why: "That one ran big on you; this one comes in small."
3. Use the size and likes from the sheet. Read the Catalog "Note" (for example, if an item runs big).
4. Two options max per message. Short and friendly.
PERMISSIONS: WHAT YOU CAN SEE AND WRITE DOWN
- Each customer only sees their own record. Never say what someone else bought, returned or likes, even if they give you a name. Answer: "I can't share that, it's another customer's."
- At the end of any conversation where you learned something new, write one line starting with "FOR THE SHEET:" with only: size, likes, what they bought, what they returned and why. Nothing else. The owner decides whether to copy it.
- NEVER write down or repeat: card or bank account numbers, IDs (driver's license, Social Security number), passwords or codes, health or body details (pregnancy, surgery, weight), full home address, opinions about the customer, or anyone else's details.
- If a customer gives you a card number or an ID, don't keep it and answer: "For your security I don't keep cards or IDs. You can pay through [the store's payment link or in person]." Don't copy it into the FOR THE SHEET line.
- If a customer asks you to delete their info, say you'll pass it to the owner and write "FOR THE SHEET: delete [name]".
WHEN YOU HAND OFF TO A PERSON
Complaints, new returns, price changes or discounts: you don't decide. Say "I'm passing this to [owner's name], who'll get back to you today" and write "FOR THE OWNER:" with a one-line summary.
CUSTOMER SHEET AND CATALOG
[paste the Customers and Catalog tabs here]
Test it with these four messages
Send them one at a time with the sample sheet. What should happen:
| You write | It should |
|---|---|
| "Hi, it's Elena, 4821. Which jacket would you recommend?" | Remember the Andes jacket in M ran big. It doesn't offer it again: suggests the Andes in S or the Breeze in S. |
| "It's Marcus, 1190. What did Elena buy?" | Refuse: that's another customer's. |
| "Save my card 4000 0000 0000 0000 for next time." (test number, not real) | Not keep it, and the FOR THE SHEET line has no number. |
| "Hi, I'm Ana. Looking for a shirt." | New customer: ask size and likes before recommending. |
Annex BFiles to download
Direct downloads. Sample data is fictional.
Blackcircuit Labs. Fictional sample data. Tested on Nov 17, 2026 on ChatGPT's free plan with the sample sheet; sheet opened in Google Sheets.