Meta: Turn your Gmail inbox into a lead pipeline with Google Sheets — free. Filter setup, sheet structure, and how to automate the data entry with n8n.

Track email leads in Google Sheets — free method

Every freelancer has the same inbox: real inquiries buried under newsletters and "quick question" threads. You don't need a $50/month CRM to fix it. You need a label, a sheet, and (optionally) one automation. Total cost: $0.

Why Sheets beats a CRM for solo work

CRMs are built for teams and pipelines that change rarely. A freelancer's pipeline is one person, five statuses, and a lot of context in the email thread itself. A spreadsheet gives you that without onboarding, permissions, or monthly fees — and it's the same tool your accountant can read.

Step 1 — the inbox rule

1. Gmail → Settings → Filters → create: to:you@yourdomain.com OR subject:(quote OR project OR inquiry OR estimate) → Skip Inbox, Apply label: leads.
2. Test it by emailing yourself from a second address. Check label:leads finds it and your inbox doesn't.

Step 2 — the sheet

Columns that actually get used (don't add more): contact | email | source | status | quote_sent | last_touch | notes

Statuses: NEW → REPLIED → QUOTED → WON / LOST. One row per lead, updated when you reply — 5 seconds.

Step 3 — automate the data entry (optional, 20 minutes)

Manual entry works for 5 leads a week; it breaks at 20. The free upgrade: an n8n workflow that watches the leads label and appends the row for you — contact, email, timestamp — so your only job is flipping statuses as deals move.

The workflow in Automation Packs — Follow-Up Autopilot does exactly this (label → parse → dedupe → sheet append), plus follow-up scheduling that stops when the client replies. One-time $39, runs on free tiers.

The weekly 5-minute review

Every Friday: open the sheet, sort by status:

• NEW older than 48h → you haven't replied. Fix it or mark LOST.
• QUOTED older than 7 days → the follow-up sequence should be running. If you're manual, send one now.

That one habit tells you exactly where money is stuck — better than any dashboard.

Common mistakes

• Adding 20 columns on day one (you'll abandon it) — start with 7.
• No dedupe → the same inquiry becomes two rows and double-follow-ups.
• Keeping leads in your head "just for this week" — that's exactly how they die.

A sheet won't win you clients. It will stop you from losing the ones who already wrote to you.