How to Build a Personal CRM

I ran into a neighbor at the grocery store. His kid plays with my kid. I could not remember his name. Or his kid's name. Or which house was his. I smiled, made small talk, and felt like a terrible person for 3 minutes.

This happens to me constantly. I meet people at school events, kid birthday parties, work, and the neighborhood. I have good conversations. And then their name drops out of my brain within 48 hours.

A personal CRM fixed this. CRM stands for Customer Relationship Management, but forget the business term. It's just a spreadsheet of the people in your life with the details you keep forgetting. Names, birthdays, their kids' names, the last time you talked, and what you talked about.

It takes 2 minutes to update after meeting someone. It saves you from being the dad who can't remember anyone.

---

---

What goes in the CRM

Name. Obviously. But also their spouse/partner's name and their kids' names. This is the information you forget fastest and feel worst about forgetting.

How you know them. "Neighbor on Elm St." "Jake's soccer team parent." "Met at Dave's BBQ." "Former coworker at TechCorp." This jogs your memory when you see the name and think "who is this person?"

Birthday / important dates. Their birthday. Their kid's birthday if your kids are friends. Anniversary if you're close. The spreadsheet can highlight upcoming dates so you never miss them.

Last contact. The date you last talked, texted, or hung out. This is the feature that changes your relationships. When you see that you haven't talked to a friend in 4 months, you text them. Not because the spreadsheet told you to, but because seeing the date makes you realize you've been meaning to reach out and keep not doing it.

Notes. Whatever matters. "His mom is sick." "Starting a new job in January." "Loves bourbon." "Allergic to dogs." "Mentioned wanting to learn guitar." These details turn you from "that guy I met at the party" into "the guy who actually remembered what I told him." People notice when you remember things. It builds trust faster than almost anything else.

The categories

The template has four tabs:

Inner circle. Family and close friends. The 10-15 people you want to be in regular contact with. If "last contact" goes past 2 weeks for anyone on this list, reach out.

Extended network. Friends you see occasionally. Old colleagues. College friends. People you like but don't see often. Check-in target: every 2-3 months.

Work contacts. Clients, prospects, collaborators, mentors. Essential if you have a side hustle. Track what you're working on together and when you last followed up.

Neighborhood / school. Parents from your kid's class. Neighbors. People from the community. This is the tab that saves you from the grocery store shame spiral.

The weekly habit

Every Sunday during your weekly review, glance at the CRM. Who haven't you talked to in a while? Pick 1-2 people and send a quick text. "Hey, been a while. How's the new job going?" "Saw something that reminded me of you." "We should grab a beer soon."

That's 2 minutes a week. Over a year, that's 100+ intentional touchpoints with people in your life. Relationships compound just like money. Small, consistent deposits build something real over time.

This is not weird

I know what you're thinking. "Keeping a spreadsheet about my friends is weird." Salespeople have been doing this for decades. Politicians do it. Community leaders do it. The difference between "networking" and "being a good friend" is just intent. If you're tracking people to extract value from them, that's manipulative. If you're tracking people because you genuinely want to remember their lives and stay in touch, that's thoughtful.

My wife found my CRM and said, "This is the most organized thing you've ever done." She was not weirded out. She was impressed. Then she asked me to add her sister's husband's birthday because she keeps forgetting it too.