Send your leads to a Google Spreadsheet (using Zapier)

Lisa Fockens Updated by Lisa Fockens

Notes: 

  • Zapier is a Freemium service. Above a certain limit of emails, you might have to upgrade your account.

Follow these steps to send your new emails to a Google Spreadsheet through Zapier.

Part 1: Prepare your Google Spreadsheet

Step 1: log in your Google Drive account and create a new spreadsheet.
Step 2: input in the first row the name of the elements you would like to collect from your WisePop. For example, if you want to sync emails and creation date, you should input:

You will be the only one seeing these elements. So feel free to pick the wording which works best for you.

Part 2: Activate the Zap

Step 1: Log in to your Wisepops account.

Step 2: Open or create a popup with a sign-up form.

Step 3: Click your sign-up form.

Step 4: In the left menu, click "Sync"

Step 5: Select the Zapier logo

Step 6: Copy the API key under the Zapier logo

Step 7: Create an account on Zapier or log in to your existing account.

Step 8: In the upper menu, click "MAKE A ZAP"

Step 9: in the "Choose a Trigger App" section, look for Wisepops

Step 10: On the following page, click "Save + Continue"

Step 11: in the pop-up window, paste your API key and click "Yes, continue"

Step 12: Click "Test" to try the connection. If "Success" is displayed, click "Save + continue" and continue with the instructions. Otherwise, check what's wrong with your API key (or contact us).

Step 13: Select the popup you want to sync in the list and click "Continue"

Step 14: On the following page, click "Fetch & continue". If the test is successful, click "Continue".

Step 15: In the "Choose an Action App" search, look for Google Sheets and select it.


Step 16: Select "Create Spreadsheet Row" and click "Save + continue"


Step 17: Click "Connect an Account" and log in your Google account.

Step 18: Select your spreadsheet and worksheet and match the elements with their Wisepops equivalent. And click "Continue"

Step 19: Click "Create & continue". If the test is successful, click Finish

Step 20: Name your Zap and activate it.

How did we do?

How can I take advantage of the Zapier integration?

Contact