WorkluneHow to Build a Simple Client CRM in Google Sheets
You do not need a complex CRM to keep client relationships organized. For many freelancers and consultants, a well-structured Google Sheet is enough to track contacts, follow-ups, onboarding and active work in one familiar place.
Decide what your CRM actually needs to do
A freelancer CRM does not need every feature found in enterprise sales software. Start with the questions you need to answer regularly: Who is this client? What are we working on? What is the next action? When did we last speak? Is there an outstanding payment or onboarding step?
If a field does not support a decision or recurring workflow, you probably do not need it.
Create one clean client table
Use one row per client. Useful columns include client ID, company or client name, contact person, email, phone, service, status, last contact date, next follow-up date and notes.
A unique client ID makes it easier to connect this table to projects, onboarding steps and payment records later.
Use clear client statuses
Statuses should reflect where the relationship is, not every possible detail. For example: Lead, Onboarding, Active, Paused and Past Client. These labels are enough to filter your database and understand your current workload.
If you need sales pipeline stages, keep them separate from delivery status so “proposal sent” does not get confused with “active client.”
Make follow-ups visible
A CRM is only useful if it helps you remember what happens next. Add a next-action field and a follow-up date. Conditional formatting can highlight overdue follow-ups or clients who have not been contacted recently.
This is especially useful when work is busy, because relationship management is usually the first thing to disappear from memory.
Connect the CRM to onboarding and projects
The real value appears when your client database connects to the rest of your operation. A client ID can feed an onboarding tracker, project register, communication log or billing sheet. That way, the client record becomes the anchor for everything related to that relationship.
Avoid copying the same contact information into every tab. Store it once, then reference it where needed.
Keep the system light enough to maintain
Set aside a few minutes each week to clean old follow-up dates, update statuses and add notes from important conversations. If the CRM takes too much effort to maintain, remove fields before adding more automation.
The best CRM is the one you still trust six months later.