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.

  1. Step 1: In CRMWA open Integrations → Zapier, save, and copy the webhook URL and the one-time token.
  2. Step 2: In Zapier create a Zap: trigger Google Sheets → New Spreadsheet Row, pick your spreadsheet and worksheet.
  3. Step 3: Add action Webhooks by Zapier → POST. Payload type JSON. URL = your CRMWA Zapier URL.
  4. Step 4: Headers: Authorization: Bearer <token> and Content-Type: application/json.
  5. Step 5: Map fields: sourceId = Lead ID, plus name, phone, email, company, city, product, message. Set event = lead.created.
  6. Step 6: Test the Zap and check Recent events in CRMWA, then turn the Zap on.

CRMWA enquiries → Google Sheet log#

  1. Step 1: In Zapier create a Zap with trigger Webhooks by Zapier → Catch Hook and copy its URL.
  2. Step 2: In CRMWA, on the IndiaMART, Justdial or other card, paste that URL in Forward received events to backend.
  3. Step 3: Add action Google Sheets → Create Spreadsheet Row and map the fields.
  4. Step 4: Send a test enquiry and confirm the row appears.

Still stuck? Raise a support ticket from your dashboard or contact our team.

Browse all guides