Skip to main content
All CollectionsIntegrationsZapier
How to Connect Your Quiz to Google Sheets with Zapier
How to Connect Your Quiz to Google Sheets with Zapier

Use Zapier to send new quiz leads to a Google Sheets

Mia Fitzpatrick avatar
Written by Mia Fitzpatrick
Updated over a month ago

In Google Sheets:

Step 1: Go to Google Sheets and make a new Sheet.

Step 2: Name the Google Sheet the same title as the Quiz that you will be collecting leads from

  • Then add a column for each of the Contact Fields you will be collecting from your Quiz's Opt-in Form

  • Lastly, add a column for Quiz Result


Connect Zapier to your Interact Quiz:

Step 1: Turn on "Lead Generation" on the Interact app builder's left sidebar.

  • To create your Opt-In Form, select the Contact Field information you would like to collect from your quiz takers. Scroll down and click "Save & Continue."

Step 2: Under Connect your email list, choose Zapier from the list of integrations.

Step 3: Here you will see your Interact API Key. Copy the API key, this is required for the next setup steps. You'll be pasting this API Key during your Zap set up.


Setup Zapier with Interact:

Step 1: Log in to your Zapier account and click Create and then Zaps.

Step 2: Choose Interact as the Trigger App.

Step 3: Select New Lead as the Interact Trigger.

Step 4: Under Account, select your Interact Account.

  • To connect your Interact Account to Zapier, select "+ Connect a new account"

  • Here you will Paste your Interact API Key and select "Yes, Continue to Interact"

Step 5: After selecting Interact as the App, selecting New Lead for Trigger Event and adding your Interact Account, then hit "Continue."

Step 6: Under Configure, select the quiz you would like to connect to and then hit Continue.

Step 7: Under Test, select "Test Trigger"

  • Select Lead A and hit "Continue with selected record."

Step 8: Now for Action, search and select Google Sheets

Step 9: After selecting Click Funnels as the App:

  • Select "Create Spreadsheet Row" for Action Event

  • Then Add your Google Account

  • Finally hit "Continue."

Step 10: Under Configure:

  • Select "My Google Drive" under Drive

  • Select the Spreadsheet you created for the quiz under Spreadsheet

  • Under Worksheet, select Sheet1

  • Under Quiz Result, hit the + sign and select "Tag: Interact Quiz Result 2"

  • Finally hit Continue

Step 11: Hit Test Step and then Publish the Zap


Interact Dshboard:

Step 1: Go back to your Interact Quiz and hit "Activate Connection" under API Key in Lead Generation.

Step 2: Test your Integration and then hit Publish on your quiz.


Google Sheets:

Your Leads will appear like the example below:

Did this answer your question?