Free CRM for Marketing Agencies from Google Sheets
Agencies have a strange CRM problem: half the pipeline isn't new business. It's existing clients — retainers coming up for renewal, upsells parked "for next quarter," a referral someone mentioned on a call. Classic sales CRMs treat all of that as an afterthought, which is why so many agencies quietly run everything from a Google Sheet with tabs named Prospects, Current Clients, and Renewals 2026.
The sheet isn't the problem. The problem is that it's invisible: follow-ups live in the account manager's head, renewals sneak up 30 days too late, and when a founder asks "what's in the pipeline?", someone builds a slide instead of clicking a link.
You can fix that without migrating anything. Here's how agencies build a CRM directly on their existing sheet using AI — free.
Step 1: Start With Your Client Sheet
Keep the structure you have. A typical agency sheet has one row per relationship:
| Column | Example |
|---|---|
| Client / prospect | Bloom Dental |
| Type | Retainer |
| Service | SEO + content |
| Monthly value | $3,500 |
| Stage | Proposal sent |
| Renewal date | Sep 1 |
| Account manager | Priya |
| Last touch | Jul 14 |
Prospects and active clients can live in the same sheet or different tabs — either works, because the sheet stays the source of truth.
Step 2: Create a Free Account
Head to lovespreadsheets.com and sign up. Building and running the CRM is free; logins for the whole team on a custom domain are the paid tier.
Step 3: Describe the Agency Motion
Pick the CRM template and write out how relationships actually move at your shop:
- "New business goes Lead → Discovery call → Proposal → Won. Proposals expire after 30 days."
- "Existing clients have a renewal date. I want anything renewing inside 60 days flagged, loudly."
- "Each account manager owns their book. Partners see everything."
Agency-specific things worth requesting:
- A renewals view sorted by date — the single screen that pays for the whole exercise
- Automatic emails internally when a proposal sits untouched for a week
- Per-AM views and permissions, so the team sees their accounts and leadership sees the roll-up
Upload the sheet and run it. Builds take about 15–20 minutes, sometimes with a clarifying question first.
Step 4: One Link Replaces the Status Meeting
The result is a live app: new-business pipeline on one board, renewals on another, every client clickable with history and notes. It reads and writes your Google Sheet in both directions, so the ops person who loves the spreadsheet keeps the spreadsheet — and everyone else finally stops asking them for updates.
Share the URL, make it private to the team, and put it on your own domain if you want it to feel like internal software.
Why This Fits Agencies
Retention is a first-class citizen. Renewals and upsells get the same pipeline treatment as new logos, because you designed the stages — not a CRM vendor who assumes you only hunt.
No seat math. Agencies grow by adding account managers. Sheet-based means your sixth AM costs the same as your first: nothing.
Proposal-to-project continuity. Because it's all one sheet, the deal you close doesn't vanish into a different tool — it becomes the client row your delivery team already reads.
Common Questions from Agencies
Can clients see any of this? No — this is internal. (If you want client-facing views, that's a client portal, which you can also build from a sheet.)
Can we track by service line? Yes. If it's a column — SEO, paid, web — it's a filter.
What about our existing history? It's already there. The CRM is your sheet with an interface, so every note and renewal date carries over instantly.
Build Yours
Open the client sheet, go to lovespreadsheets.com, and describe how business moves through your agency. In about 20 minutes, "what's in the pipeline?" becomes a link you send instead of a meeting you schedule.
The team turning other people's spreadsheets into software they actually trust — one sheet at a time.
