WhatConverts
Browse Help Center
Browse Help Center
Related Integrations
Help Center Integrations
Send Leads into Google Sheets

1Go to Google Sheets and create a new spreadsheet to import your leads into.
2Rename your spreadsheet to an easily recognizable name and fill out first row with the Lead Details you wish to import. In the example below, I have used the following (you can create as many as you would like):
WhatConverts Spreadsheet in Google Drive

    Lead ID
    Date/Time
    Lead Type
    Source
    Medium
    Caller Number

3Go to Zapier and click "Create Zap".
4Select "WhatConverts" as your Trigger App and "New Lead" as your Trigger Event. Click "Continue".

Connect your WhatConverts account (if you need instructions on how to connect your WhatConverts account see: Connect to Zapier). Click "Continue".

On the Set up trigger page, select "Yes" for all of the lead types you would like to send to your Google Sheets spreadsheet. Click "Continue".

Important: For Phone calls and/or Chats, make sure to select "Yes" for only one of the Phone Call options to eliminate duplicates from being sent into your CRM.

  • Phone Call (Completed): Sends the lead to the CRM once the Phone Call has finished
  • Phone Call (Modified): Sends the lead to the CRM when a phone call is in progress and the lead in WhatConverts is modified.
  • Phone Call (In Progress): Sends the lead to the CRM when a phone call has begun. This is the option to use if you would like your agents to update the CRM while they are on the phone with the caller.

Select "Test trigger". Select a lead from the drop-down and click "Continue".

Note: If no lead is found, submit a test lead and re-test this step of your Zap.

5Select "Google Sheets" as your Action App and "Create Spreadsheet Row" as your Action Event. Click "Continue".

Connect your Google Sheets Account your spreadsheet was created in. Click "Continue".

On the Set up Google Sheets Spreadsheet Row page, select your "Spreadsheet" and "Worksheet" from their respective drop down menus. Match the additional fields to the WhatConverts lead selected in the Trigger Step of the Zap.

Matching Data points Google Sheets

Click "Continue". Click "Test & Continue". Check your Google Sheet and make sure the data is in the correct column. Turn your Zap "On".

If you have any questions, please contact us here: Contact WhatConverts Support or email support@whatconverts.com

You can push your WhatConverts leads using Zapier into Google Sheets to instantly update your existing Google Sheets document with new, incoming leads.

1Go to Google Sheets and create a new spreadsheet to import your leads into.
2Rename your spreadsheet to an easily recognizable name and fill out first row with the Lead Details you wish to import. In the example below, I have used the following (you can create as many as you would like):
WhatConverts Spreadsheet in Google Drive

  • Lead ID
  • Date/Time
  • Lead Type
  • Source
  • Medium
  • Caller Number

3Go to Zapier and click "Make a Zap".
4Select "WhatConverts" as your Trigger App and "New Lead" as your Trigger. Click "Save + Continue".

Connect your WhatConverts account (if you need instructions on how to connect your WhatConverts account see: Connect to Zapier). Click "Continue".

To set up your WhatConverts Lead, select "Yes" for all of the lead types you would like to send to your Google Sheets spreadsheet. Click "Save + Continue".

    Note: Make sure to select "No" for Phone Calls (In Progress) or Phone Calls (Completed). This will make sure that the phone calls aren't duplicated on your Google Sheets Spreadsheet.

On the Pick A Sample To Set Up Your Zap page, click "Get Samples" to get a sample lead from your WhatConverts account. Select the sample lead you would like to set up your spreadsheet with and click "Continue".

5Click "+ Add a Step" and select "Action/Search". Select "Google Sheets" as your Action App and "Create Spreadsheet Row" as your Action. Click "Save + Continue".

Connect your Google Sheets Account your spreadsheet was created in. Click "Save + Continue".

On the Set up Google Sheets Spreadsheet Row page, select your "Spreadsheet" and "Worksheet" from their respective drop down menus. Match the additional fields to the WhatConverts lead selected in the Trigger Step of the Zap.

Set up Google Sheets Spreadsheet Row

Get a FREE presentation of WhatConverts

One of our marketing experts will give you a full presentation of how WhatConverts can help you grow your business.

Schedule a Demo
Whatconverts Features for your Business
Related Integrations
ready to get marketing clarity?

Grow your business with WhatConverts

14 days free trial Easy setup Dedicated support
G2 Users Love Us Badge
G2 High Performer Badge
G2 High Performer Small Business Badge
G2 Momentum Leader Badge
G2 High Performer Europe Badge