Recipe 07Track B: Go AI-native
How do I make my business data usable by AI?
Clean up the two or three spreadsheets that actually run your business: one row per thing, one column per fact, no merged cells, one date format. Add a tab that explains each column. Then AI can answer questions about your business in one prompt instead of you digging for an hour.
- For
- businesses where the truth lives in a messy Google Sheet
- Setup
- half a day
- Cost
- $0
Ingredients
- Google Sheets (or Excel)
- Claude or ChatGPT, with file upload
Steps
0 of 5 done- Pick the sheets that matter. Usually customers, orders or projects, and money.
- Fix the shape: one header row, one row per customer or order, no blank rows, no merged cells, no color-only meaning.
- Use one date format (YYYY-MM-DD) and keep amounts in USD in their own column.
- Add a “README” tab: one line per column saying what it means.
- Export as CSV and upload to AI with the prompt below.
Copy this prompt
This is my business data. The README tab explains each column.
Answer using only this data. Show the rows you used. If the data can't answer it, say so.
Question: [e.g. who are my top 10 customers by revenue this year, and who hasn't ordered in 60 days?]Human check
ask AI to show the rows behind every number. Spot-check two.
Done when
you get an answer about your own business in one prompt, with the rows to prove it.
Free-tier details checked 29 Oct 2026