Client Pipeline Tracker | CRM Google Sheets Template for Freelancers, Virtual Assistants and Service Providers

The Client Pipeline Tracker is a Google Sheets CRM template designed for freelancers, virtual assistants, coaches, consultants, and service-based business owners who need a simple, organized system for tracking potential clients from first contact to signed contract. Compatible with Microsoft Excel.

Stop losing leads. Stop forgetting follow-ups. Stop wondering where you left off with that warm prospect from three weeks ago. This tracker keeps your entire client pipeline organized, visible, and actionable; without complicated software, monthly subscriptions, or a steep learning curve.

————————————————————————

WHAT IS INSIDE — 7 CONNECTED TABS

————————————————————————

Pipeline — Your main view. One row per potential client. 10 color-coded pipeline stages auto-color each row so you can see where every lead stands without reading a single cell. Track potential monthly value, fit score, follow-up dates, referral source, and more.

Dashboard — Automatically updates from your Pipeline with no manual input required. Shows total leads, active pipeline count, signed clients, total pipeline value, stage breakdown, and top lead sources.

Contact Info — Store every contact detail in one place: personal and business email, phone, website, LinkedIn, Instagram, TikTok, preferred contact method, time zone, and how you first connected.

Outreach Log — Log every message, DM, email, or call. One row per touchpoint. Track the channel, attempt number, response, and sentiment so you always know exactly where you left off.

Discovery Calls — Full call notes including pain points, services discussed, budget, proposed retainer, overall vibe, red flags, and outcome.

Archive — For leads who are not ready yet. Set a Revisit After date and the row highlights automatically when it is time to reach back out. A no becomes a not yet.

Start Here — A complete instruction guide built into the first tab of the spreadsheet.

————————————————————————

KEY FEATURES

————————————————————————

• 10 color-coded pipeline stages with automatic row coloring

• Dropdown menus throughout — no blank fields to stare at

• Auto-updating dashboard with no manual calculations

• Overdue follow-up alerts that highlight in amber

• Fit Score column to prioritize your highest-potential prospects

• Revisit Later stage so warm leads are never truly lost

• Auto-calculated row numbers and days in pipeline

• 200 rows of capacity across every tab

• Sample data pre-filled so you can see how it works immediately

• Works with Google Sheets (free) and Microsoft Excel

————————————————————————

WHAT YOU RECEIVE

————————————————————————

• Instant PDF download with your Google Sheets access link

• Complete step-by-step instruction guide covering every tab and column

• Tips for finding clients across social media, LinkedIn, networking events, and more

• FAQ section covering common questions

• Excel version available: File > Download > Microsoft Excel directly from Google Sheets

————————————————————————

WHO THIS IS FOR

————————————————————————

This tracker was built for anyone who provides a service and needs clients: virtual assistants building their client base, freelancers in any industry, coaches and consultants, social media managers, content creators, and small business owners managing their own outreach. It pairs especially well with the How to Start Your Virtual Assistant Business From Scratch ebook and workbook, also available in the LiaMedia Solutions shop.

————————————————————————

LICENSE AND TERMS

————————————————————————

One-time purchase. Personal use only. This product may not be resold, redistributed, or shared. All sales are final. For questions, contact liamediasolutions@gmail.com or visit the LiaMedia Solutions YouTube channel.

© 2026 LiaMedia Solutions | Aaliyah M. Gibbs. All Rights Reserved.