Somewhere in your Google Drive is a sheet called Leads 2026 FINAL (2). It was updated enthusiastically for nine days. We're not here to mock it — we're here to fix the actual problem: a sheet updated by hand is a diary, not a CRM. The moment rows write themselves and follow-ups fire themselves, the same free sheet becomes a genuinely capable CRM for a few thousand contacts.
The column structure that works
| Column | Example | Why |
|---|---|---|
| Timestamp | 12-Aug 11:42 | Auto-filled; response-time truth |
| Name / Business | Rahul, Gupta Sweets | Personalised messages need it |
| Phone (10-digit) | 98xxxxxx21 | WhatsApp key — keep format clean |
| Source | IndiaMART / Website / Meta ad | Tells you which channel earns |
| Enquiry | SS pipes, 50 units | Context for follow-up |
| Status | NEW → CONTACTED → QUOTED → WON/LOST | One word, one owner |
| Next follow-up | 14-Aug | What tomorrow's automation reads |
Seven columns. Resist adding twenty — every extra column is a reason nobody fills it.
Automation 1 — rows write themselves
Every lead source lands in the sheet without a human: website form → webhook → new row; IndiaMART push → new row; Meta lead ad → new row. Each arrival also fires the instant WhatsApp greeting and pings your salesperson. From day one, your response time and source data are real, because no one "forgot to enter" anything.
Automation 2 — follow-ups fire from rows
Each morning, the automation reads the sheet: every row where Next follow-up = today and Status ≠ WON/LOST gets its follow-up — a WhatsApp nudge referencing the original enquiry (templates 3 and 4 here), and the row's date advances. Silent leads stop slipping through because "sheet dekhna bhool gaya".
Automation 3 — campaigns from a filter
Diwali offer to every LOST lead from the last 90 days? That's a read-rows → for-each loop → template send, straight off the sheet. Two cautions that separate professionals from spammers: opt-outs must be honoured automatically (a STOP reply blocks future sends), and message pacing matters — a burst of hundreds of identical marketing messages is how numbers get flagged. Volume campaigns really belong on the official API with proper broadcast tooling.
When to graduate off Sheets
- Three people editing at once and overwriting each other,
- You need a per-contact timeline (every message, order, note in one place),
- Segments, opt-out enforcement and dedupe need to be guaranteed, not hoped for.
That's the point where the sheet stays as a report and the system of record moves to contacts with segments, notes and timelines — which Yantra includes built-in, alongside the same Google Sheets connector for everything above. Same flows, sturdier foundation.
Make your sheet work the night shift
"Naya lead aaye toh WhatsApp bhejo aur sheet me daalo" — describe it, it runs. Start free, 1,000 runs.
Start free