AI Decoded

EP09 — Build Your CRM From Scratch: Free Tools, Real System


Listen Later

The professionals who grow steadily over time — versus those who do the same amount of work for the same results year after year — are almost never the ones with better marketing. They are the ones who never let a warm lead go cold.

EP09 of AI Decoded is a practical build session: how to construct a functional client database from scratch using free tools, with Claude handling the communication work that makes the system worth maintaining.


Topics covered:

- The exact column structure for a Google Sheets CRM that captures what matters without creating busywork — including the field most professionals skip that separates relationship-builders from transaction-processors

- How to use Claude to draft follow-up messages calibrated to a specific person's situation, prepare for sales calls, and write payment requests that are professional without being awkward

- Payment tracking: why most professionals handle it poorly, and how adding a few columns to your existing spreadsheet makes overdue invoices impossible to ignore


The database does not generate relationships — only human interaction does. But it creates the conditions where relationships can be maintained systematically, at a scale memory alone cannot support.


(0:00) Introduction — The system that separates steady growth from the hamster wheel

(2:26) Why Google Sheets is the right starting tool

(4:35) The nine-to-twelve column structure — every field earns its place

(7:56) Stage labels and color coding as a visual pipeline

(10:04) The "personal notes" column and why it matters most

(11:36) Using Claude to design your CRM structure

(13:26) Populating the database — start imperfect, start today

(15:15) Claude as a follow-up writing assistant

(17:23) The Marcus problem: what to say after silence

(19:32) Payment tracking: adding financial visibility to the same sheet

(21:58) Writing payment requests with Claude

...more
View all episodesView all episodes
Download on the App Store

AI DecodedBy Upsilon AI