Tracking Your Outreach Efforts

1. Why Google Sheets? The "Commando" Approach to CRMs

Before we build, it's important to understand why we're choosing a spreadsheet over a dedicated CRM like HubSpot or Salesforce. For a solo consultant focused on high-value clients, traditional CRMs are overkill. They're expensive, slow to set up, and bloated with features you don't need. Our philosophy is speed and efficiency.

A Google Sheets CRM offers several key advantages for our purposes.

As the article highlights, a spreadsheet gives you:

• Zero Cost: It's free. Every dollar saved is a dollar earned.
• Immediate Usability: You already know how it works. There is no learning curve.
• Total Control: You define the process. The tool adapts to you, not the other way around.

This approach keeps you agile and focused on what matters: closing deals.

2. Building Your Client Acquisition Tracker

Now, let's build the tracker. We'll set up the essential columns and add simple functions to make it a dynamic tool that tells you exactly what to do each day.

To see how this comes together in practice, the following video provides a great visual walkthrough of building a simple CRM from scratch.

Core Structure

Your tracker will have the following columns. This structure is designed specifically for your outreach process.

3. Adding "Intelligence" to Your Tracker

A static list is not enough. We need the tracker to actively guide your daily actions. We'll use two key features: Data Validation for the Status column and Conditional Formatting for the Next Follow-up date.

A. The Status Pipeline (Data Validation)

Instead of typing a status, you'll select it from a predefined list. This ensures consistency. Your statuses represent the entire journey from a cold lead to a paying client.

Status Options:

• To Contact
• Contacted (Initial outreach sent)
• Replied - Positive
• Replied - Negative
• Meeting Booked
• Proposal Sent
• Closed - Won
• Closed - Lost
• Nurture (Not now, but maybe later)

B. The Daily Action Trigger (Conditional Formatting)

This feature makes it impossible to miss a follow-up. We'll make the Next Follow-up cell change color based on its date.

We'll set up these rules for the Next Follow-up column:

• If the date is in the past, the cell turns RED. (Overdue!)
• If the date is today, the cell turns GREEN. (Do it now!)
• If the date is in the future, the cell remains the default color.

Your Deliverable: Build Your Personal Outreach CRM

Now it's time to build this asset. This is not a theoretical exercise; you will use this sheet every day to manage your path to $5k/month.

Task (25 minutes):

1. Create the Sheet: Open Google Sheets and create a new file named [Your Name] - Client Acquisition Tracker.
2. Build the Structure: Create the 11 columns listed in the "Core Structure" table above.
3. Implement the Status Dropdown:
   • Select the entire Status column (click the column letter, e.g., 'G').
   • Go to Data > Data validation.
   • Click + Add rule.
   • For Criteria, choose Dropdown.
   • Enter the Status Options from the list above, one by one.
   • Click Done.
4. Implement Conditional Formatting:
   • Select the entire Next Follow-up column.
   • Go to Format > Conditional formatting.
   • Rule 1 (Overdue):
     • Under "Format rules," choose Date is before and select today.
     • Set the formatting style to a light red fill.
     • Click Done.
   • Rule 2 (Today):
     • Click Add another rule.
     • Choose Date is and select today.
     • Set the formatting style to a light green fill.
     • Click Done.
5. Populate with Initial Targets:
   • Add the 20 ideal prospects you identified in the previous module to your tracker. Fill in their Name, Title, Company, LinkedIn URL, and Email.
   • Set the Status for all of them to To Contact.
   • For the first 5 prospects, simulate that you've sent your initial outreach today. Change their Status to Contacted, set Last Contact to today's date, and set Next Follow-up for 3 days from now.

You now have a living, breathing command center for your client acquisition.

Conclusion

You have successfully built the operational backbone of your client acquisition engine. This isn't just a spreadsheet; it's a system for ensuring that no opportunity is ever lost due to disorganization. Your outreach sequences generate the opportunities, and this tracker ensures you capitalize on every single one.

Key Takeaways:

• System Over Memory: Don't rely on your memory to track dozens of conversations. A simple system is infinitely more reliable.
• The Follow-up is Everything: Your tracker's main job is to tell you who to follow up with and when. The red/green conditional formatting is your daily task list.
• A Daily Habit: This system only works if you use it. Make it the first thing you open in the morning and the last thing you update at the end of the day.

Preview of the Next Lesson:

Your outreach engine is running, and your tracking system is in place. The inevitable result is that you will start booking meetings. The next crucial step is to know exactly what to say and do on that first call.

In our next lesson, "The Sales Call: Scripts & Objection Handling," you will get the battle-tested scripts and frameworks needed to run a discovery call, confidently ask for the client's budget, and handle objections like "it's too expensive," turning a promising conversation into a signed contract.