Art gallery CRM

Art Gallery CRM: Why Spreadsheets Stop Working (and What to Use Instead)

Every gallery starts the same way: a spreadsheet with collector names, a phone, an email, and a column for "interests." It works, right up until it doesn't — and the moment it stops working is rarely dramatic. It's a follow-up that never happens, a collector who gets pitched the same work twice, a sale that almost fell through because nobody could find the last email thread.

What a spreadsheet gets right

To be fair to the spreadsheet: it's free, it's flexible, and it requires no onboarding. For a one-person operation with a few dozen collectors, it can genuinely be enough. The problem isn't the tool — it's what happens as the number of relationships, the number of people managing them, and the complexity of each relationship all grow at once.

The three places spreadsheets break down

1. There's no link between a client and the work. A spreadsheet can tell you a collector is interested in "large-scale abstract" — but not that three matching works just came into inventory, or that she was shown a similar piece eight months ago and didn't buy. That connection lives in someone's memory, and memory doesn't scale past one person.
2. There's no shared state. The moment two people touch client information, spreadsheets fracture into versions. Someone's working off a stale copy, an update gets overwritten, and nobody notices until a collector gets contacted twice about the same piece — or not at all.
3. There's no follow-up system. A spreadsheet stores facts; it doesn't prompt action. It won't tell you an enquiry has gone quiet for three weeks. In a business built on relationships, the follow-up is often the entire sale.

What a dedicated gallery CRM actually adds

• Clients linked to inventory. Every collector record sits next to the works they've enquired about, viewed, or purchased, so a new acquisition can be matched to the right people instead of from memory.
• One shared, current view. Everyone on the team works from the same live record, not a copy that's already out of date by the time it's opened.
• Visible follow-up state. Open enquiries, expiring consignments, unpaid invoices — surfaced as things to act on, not buried in a column nobody scans.

Signs it's time to move

• You've caught yourself asking "wait, did we already show them this?"
• More than one person updates the client list, and versions have drifted before
• You can't say, right now, how many open enquiries you have without checking
• A consignment or loan deadline has slipped because nobody was tracking it

Any one of these, on its own, is a sign the spreadsheet has quietly become more expensive than the switch would be.

What to actually look for

• Inventory and client data in one workspace — not two systems kept in sync manually
• A visible "needs attention" view: expiring consignments, unpaid invoices, stale follow-ups
• Consignment and status tracking, since artist relationships matter as much as collector ones
• Data you can export, so switching tools later never means losing your history

Aurelian's workspace was built around exactly this — inventory, collectors, and consignments in one place, with open enquiries and expiring deadlines surfaced instead of buried in a spreadsheet tab. The Gallery plan is built for working galleries and dealers.

FAQ