WhatsApp leads into Google Sheets or your CRM: what to capture in the chat, the export routine, and what an AI agent records for you
The leads are all in WhatsApp, which is where they are least useful: unsearchable, unsortable, and invisible to anyone who does not hold the phone. Getting them into a sheet or CRM used to mean retyping. It should mean capturing in the chat and exporting on a schedule.
Quick answer
Decide the lead fields you need (name, phone, what they want, budget, timeline, stage, source, next step), have an AI agent collect them naturally in conversation and store them against the contact, export the leads as CSV weekly, and import into Google Sheets or your CRM with phone number as the unique key to avoid duplicates. ReplyKit captures those fields automatically, keeps a stage per lead, and exports CSV from the Leads page; a weekly import takes two minutes.
The fields worth capturing
| Field | Captured how | Why |
|---|---|---|
| Name and phone | From the chat automatically | The key; phone is unique |
| What they want | Agent asks: service, product, interest | Routing and reporting |
| Budget range | Agent asks when relevant | Qualification |
| Timeline | Agent asks: when | Priority |
| Stage | New, engaged, qualified, booked, won, lost; moved by the agent and you | Pipeline |
| Source | The number they messaged or a tag | Which channel pays |
| Next step and date | Set by you in the lead's details | Follow-up discipline |
| Notes | Yours | Context the sheet cannot infer |
Fewer fields, filled consistently, beat many fields half empty. The qualification questions are in lead qualification questions.
Capturing in the chat
The agent asks the qualifying questions one at a time as part of the conversation and writes the answers to the contact's record. A lead who said "two bedroom, under 400k, moving in March" is stored as interest, budget and timeline without anyone typing. Stages move automatically (a booking moves the lead to Booked) and by hand for Won and Lost with a reason. The CRM behaviour is described in what a small business needs from a CRM.
The export routine
- Weekly, same day: Leads page, Export CSV.
- Google Sheets: File, Import, upload, "Append to current sheet" with a header row matched to your columns; or paste into a new tab and use a lookup against phone number to update existing rows.
- A CRM (HubSpot, Pipedrive, Zoho, Kommo): use its import, map phone to the unique identifier, and choose "update existing" so you do not create duplicates.
- Keep the stage and next-step columns in the export so the sheet reflects what happened in WhatsApp.
- Filter the sheet for leads with a next-step date this week; that is the Monday call list.
Avoiding duplicates
- Phone number is the key everywhere; normalise it with country code.
- Import with "update existing" or use a lookup; never plain append twice.
- If the same person messages two of your numbers, the export shows both with the same phone; the sheet merges them on import.
- Review Won and Lost monthly so the sheet does not fill with stale open leads; the routine is in the monthly audit.
If you need a live sync rather than a weekly export, that is an integration ReplyKit does not offer today; the weekly CSV covers most small businesses, and the Kommo comparison covers when a full CRM is the right home.
Frequently asked questions
Can I export WhatsApp leads to Google Sheets?
Yes. Export CSV from the Leads page and import into Sheets with phone number as the key.
Does the AI agent fill in the lead fields?
Yes. It asks qualifying questions in conversation and stores the answers against the contact, and moves the stage when a booking happens.
Is there a live sync to my CRM?
Not today. A weekly CSV export and import covers most small businesses.
How do I avoid duplicate rows?
Use phone number as the unique key and import with "update existing", never plain append.
Which fields should I capture?
Name, phone, what they want, budget, timeline, stage, source, next step. Fewer fields filled consistently beat many half-empty ones.
Leads captured in the chat, exported in two minutes
Qualification fields, stages and CSV export built in. 7-day free trial, no card.
Sources and further reading
- Harvard Business Review, The Short Life of Online Sales Leads (Oldroyd, McElheran, Elkington, 2011) · firms that responded within an hour were about seven times more likely to qualify the lead
- WhatsApp Business Messaging Policy · opt-in, opt-out and prohibited-use rules every business must follow
ReplyKit is an independent product and is not affiliated with or endorsed by Meta or WhatsApp. This article is general guidance for running a small business, not legal, financial or regulatory advice.