Google Sheets with Zapier
Import new spreadsheet rows as CRMWA leads, or log every new enquiry into a Google Sheet, using Zapier.
5 min read Owners & admins
New sheet row → CRMWA lead#
Suggested sheet columns: Lead ID | Name | Phone | Email | Company | City | Product | Message | WhatsApp Opt-in. Keep one header row and store Phone as text with the country code.
- Step 1: In CRMWA open Integrations → Zapier, save, and copy the webhook URL and the one-time token.
- Step 2: In Zapier create a Zap: trigger Google Sheets → New Spreadsheet Row, pick your spreadsheet and worksheet.
- Step 3: Add action Webhooks by Zapier → POST. Payload type JSON. URL = your CRMWA Zapier URL.
- Step 4: Headers:
Authorization: Bearer <token>andContent-Type: application/json. - Step 5: Map fields:
sourceId= Lead ID, plusname,phone,email,company,city,product,message. Setevent=lead.created. - Step 6: Test the Zap and check Recent events in CRMWA, then turn the Zap on.
CRMWA enquiries → Google Sheet log#
- Step 1: In Zapier create a Zap with trigger Webhooks by Zapier → Catch Hook and copy its URL.
- Step 2: In CRMWA, on the IndiaMART, Justdial or other card, paste that URL in Forward received events to backend.
- Step 3: Add action Google Sheets → Create Spreadsheet Row and map the fields.
- Step 4: Send a test enquiry and confirm the row appears.
Related guides
- Integrations: connect other tools to CRMWAConnect IndiaMART, Justdial, Zapier, Google Sheets, Shopify, Razorpay, and webhooks to capture leads and send automated WhatsApp messages.
- Contacts: add, import, tag and exportBuild your customer list by adding contacts, importing CSV or Excel files, tagging and segmenting them, and exporting filtered lists.
- Lead routing: auto-assign new leadsAutomatically share new leads between agents with round-robin, with separate rules per lead source.
Still stuck? Raise a support ticket from your dashboard or contact our team.