Skip to main content

How to Connect Your Quiz to Google Sheets with Zapier

Connect Interact to Zapier and use a Google Sheets action to add a new row to your spreadsheet every time someone opts in through your quiz.

Written by Mia Fitzpatrick
Updated this week

Before you start

Make sure you have the following:

  • An active Interact account

  • An active Zapier account

  • At least one created quiz in Interact

  • Lead Generation enabled on your quiz (opt-in form turned on)

  • A Google Sheet ready to receive your leads (with columns for the fields you want to collect)

Note: This feature is only available in the latest Interact user dashboard at app.tryinteract.com. Log in there to access it.


Step 1. Create your Google Sheet

Before you build your Zap, create the spreadsheet that will store your quiz leads.

  1. Go to Google Sheets and create a new Blank sheet.

  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.


Step 2. Enable Lead Generation and select Zapier

Before Zapier can receive quiz leads, you need to enable Lead Generation on the quiz you want to connect.

  1. Log in to Interact.

  2. From your dashboard, go to Quizzes.

  3. Click Edit to open the quiz builder.

  4. Under Integration, find Zapier and click Connect.

⚠️ Only the default Opt-In Form fields are supported when connecting your quiz to Zapier. Custom fields added to your quiz opt-in form cannot be sent through the Zapier integration.


Step 3. Get your Interact API Key

You’ll use your Interact API Key to connect your Interact account to Zapier.

  1. In the integration setup flow, go to the API Key step and locate your Interact API Key.

  2. Click to copy the API key.

⚠️ Keep your API key secure. Access to this key could lead to unauthorized access of your quiz leads.


Step 4. Connect Zapier integration

Next, create a Zap in Zapier and connect it to your Interact account using the API key you copied.

  1. Log in to Zapier.

  2. Click + Create, then select Zaps.

  3. Select Trigger.

  4. Search for and select Interact.

  5. For Trigger event, select New Lead.

  6. Under Account, click Sign in.

  7. Paste your Interact API Key, then select Yes, Continue to Interact.

  8. Click Continue.


Step 5. Configure the New Lead trigger in Zapier

When a new lead is collected from your Interact quiz, this trigger will fire in Zapier.

  1. In Zapier, in the Configure step for the trigger, select the Quiz you want to connect.

  2. Click Continue.

  3. In the Test step, click Test trigger.

  4. Select a sample Lead B record, then click Continue with selected record.

⚠️ Only the following fields can be collected from your quiz and sent through Zapier:

  • Email Address

  • Quiz Result Tag

  • First Name

  • Last Name

  • Company

  • Phone Number

  • Zip Code

Quiz answers cannot be collected through Zapier. They can be viewed in your Quiz Analytics instead.


Step 6. Set up your Google Sheets action

After your Interact trigger is working, add a Google Sheets action to send lead data into your spreadsheet.

  1. For Action, search for and select Google Sheets.

  2. For Action Event, select Create Spreadsheet Row.

  3. Add your Google account, then click Continue.

  4. Under Configure, set the following:

    • Drive: select My Google Drive

    • Spreadsheet: select the spreadsheet you created for the quiz

    • Worksheet: select Sheet1

  5. Scroll down and map fields to your sheet columns:

    • Click the + icon and map Email and First Name to the matching columns

    • Click the + icon and select the Interact quiz result field for Quiz Result

  6. Click Continue.

  7. Click Test step, then Publish the Zap.

    How the example data will appear in your Google Form:


Step 7. Send a test lead

Before relying on your Zap, confirm the full flow works end-to-end.

  1. In Interact, return to your quiz and click Activate Connection under the API Key section in Lead Generation.

  2. In Interact, select Test Integration to test your integration to Zapier.

  3. Verify the lead arrived in your Google Sheet.


Step 8. Publish your quiz

Any Lead Generation or integration changes you make won’t be live until your quiz is published.

Before sharing your quiz:

  1. Click Publish in the top-right corner of the quiz editor.

  2. Confirm your changes by clicking Publish changes.

Once published, your Zapier connection can send new quiz leads from the live version of your quiz.

Your Leads will appear like the example below:


FAQs

Check the following:

  • Your Zap is published (and turned on) in Zapier.

  • You clicked Activate Connection in Interact after publishing your Zap.

  • Your quiz changes are published in Interact.

  • The Zap’s trigger is connected to the same quiz you’re using live.

  • You’re submitting an email through the opt-in form (Lead Generation must be on).


Disable Zapier integration for your quiz

If you want to stop sending leads from a specific quiz to Zapier, you can disable the integration without removing your Zapier setup.

  1. Go to Lead Generation > Integrations.

  2. Navigate to the Connect step.

  3. Click Disable.

⚠️ Remember: After making changes to your integration or opt-in form, publish all changes to update your live quiz.

Once disabled, new quiz submissions from this quiz will no longer be sent to Zapier. Your other quizzes are unaffected.

Important: After disconnecting an integration from your quiz, your opt-in form will remain disabled until a new or existing integration is connected. Select .csv File Download to keep your opt-in form enabled with no integration connected.


Disconnect your Zapier account

Disconnecting your Zapier connection removes the authentication between Interact and Zapier for your account connection.

  1. Log in to your Interact dashboard.

  2. Click on Integrations

  3. Find Zapier, then click Disconnect, and confirm by hitting Disconnect again.

Important: After disconnecting Zapier, the following effects occur:

  • Your Zapier connection will stop working for any quizzes that rely on it.

  • No new quiz leads will be sent to Zapier until you reconnect and re-activate the connection.

Did this answer your question?