EPISODE · May 12, 2026 · 21 MIN
EP09 — Build Your CRM From Scratch: Free Tools, Real System
from AI Decoded · host Upsilon AI
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 ignoreThe 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
What this episode covers
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 ignoreThe 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
NOW PLAYING
EP09 — Build Your CRM From Scratch: Free Tools, Real System
No transcript for this episode yet