Every new WhatsApp lead, in your Google Sheet
Connect a sheet once and Mywa adds a row for each new lead: who they are, which ad or campaign brought them and how they're tagged. Your team works the list in the spreadsheet they already use.
Updated October 2026
From WhatsApp chat to spreadsheet row
- 1
A lead arrives
Someone messages you from a click-to-WhatsApp ad, or replies to one of your campaigns.
- 2
Mywa records it
The contact is created or updated, tagged, and the lead is attributed to the ad or campaign that brought it.
- 3
A row appears in your sheet
Mywa sends the lead to your sheet's Apps Script web app, which appends it to the tab you chose, with your selected columns.
- 4
Your team works the list
Filter, assign and follow up in Google Sheets, or share the sheet with sales; the chat itself stays in Mywa's inbox.
Lead fields you can send to the sheet
Choose any of these as columns, in any order.
| Column | What it holds |
|---|---|
| Lead time | When the lead arrived |
| Name | The contact's WhatsApp profile name, or the name you saved |
| Phone | Their WhatsApp number |
| If you've collected it | |
| Campaign / Ad | The campaign name, or the Instagram or Facebook ad headline |
| Lead source | Ad or campaign |
| Source | Where the lead came from |
| Tags | The contact's tags in Mywa |
| Conversation ID | Links the row back to the chat |
| Contact ID | Links the row back to the contact |
Connect a sheet in a few minutes
- 1
Open your Google Sheet
Create a tab for leads, such as “Leads”.
- 2
Add the Apps Script
In Extensions → Apps Script, paste the script Mywa gives you and deploy it as a web app.
- 3
Paste the web app URL into Mywa
In Settings → Integrations → Google Sheets, paste the URL, name the tab and pick your columns.
- 4
Send a test
Mywa sends a test row so you can see it land before real leads arrive.
Add rows from any automation
Lead export is automatic, but automations can also write to a sheet with the “Add a spreadsheet row” step, using headers and values you define.
- 1
A restaurant logs every booking request a customer sends on WhatsApp.
- 2
A clinic records each “Reschedule” tap with the patient's name and number.
- 3
A store lists customers who asked about a product that's out of stock.
Frequently asked questions
Yes. Connect a sheet in Mywa and every new lead, from a click-to-WhatsApp ad or a campaign reply, is added as a row with the columns you chose.
No. Mywa writes to your sheet directly through a Google Apps Script web app on your own sheet. You can still use Zapier or Make through Mywa's webhook if you prefer.
No. The sheet gets the lead's details and IDs that link back to the conversation; the chat itself stays in Mywa's shared inbox.
No. The Google Sheets integration is included in Mywa's $14.99/month plan (₹999 in India).
Grow on WhatsApp,
without the chaos.
Bring your team into one inbox, launch your first campaign, and let the follow-ups run themselves.