Use Zapier to send Quiz Submissions to Google Sheets

If you prefer, you can follow along with a video tutorial of the steps we show below.

To do this you will need to have set up the Zapier Integration and have a Google Sheet prepared that already has column names for the data that you want to populate.

From your Zapier dashboard, click +Create and select Zaps:

Select the Trigger option which is the event stat that will start the workflow and from the list of available triggers use the search bar to find the Lantern app.

From the right-hand side menu, you’ll be able to configure the event, add the account, set up the trigger, and test.

Under the App & event tab, select the completed select the Event Quiz Completion.

Continue to the Account tab and connect your Shopify store by clicking the Choose.

Continue to the Trigger tab and select the quiz ID from the drop-down menu. This will already be populated with a list of all the quizzes in your store for an easy selection.

Once this is done choose if you want the Zap to be triggered only when email addresses are provided in the quiz. In this demo, we have an email column in our Google Sheet and we only want the rest of the data to populate when an email is provided so we will select True.

The final step is to continue and Test your trigger.

Under the Completion table you will find a list of all properties and information available about a customer including their country, device information, the time they started the quiz, the time it was submitted, answers selected (with their index position), products recommended (including URLs, product titles, product IDs and image URLs) and customer email and name(if captured in the quiz).

All of this data can be used to dynamically populate the Google Sheet you’ll be connecting next.

Go to Action and select Google Sheets from the available apps

From the right-hand side menu, you’ll be able to configure the event, add the account, set up the trigger, and test.

Under the App & event tab, select the completed select the Event Create Spreadsheet Row.

Next, continue to Accounts and connect your Google Drive. If this is not already added from previous Zaps, you can connect your drive by clicking +Connect a new account

Once done, continue to Action and connect your Google Sheet. Remember, you should already have the Column names inside the Google Sheet. In this example our columns are Email, Pillow Filling (the property ID we’ve given to the answer of the first question in the quiz) and Product Recommendations. You can of course create a Google Sheet with columns for all the available quiz information.

TOP TIP: To easily add each of your answers to its own separate column in the Spreadsheet we recommend giving each question in your quiz a unique property ID as using this as the column name inside your spreadsheet.

In this next step, you’ll be ask to select the correct Google Drive account, the correct Google Sheet document and the worksheet inside the document.

Once your Google Sheet is connected you can automatically see the column names. Next we’re going to assign the correct quiz properties to each of these columns: Email, Pillow Filling and Product title.

As you can see you already have a preview of the values that will be added to each column in your worksheet. The next and final step is to test your connection.

Once done, give your zap a more appropriate name and don’t forget to Publish it.

If you have any questions please don't hesitate to contact our support team using the in-app chat toggle or by e-mail at [email protected]