Introduction

Integrating your Quizell quizzes with Google Sheets allows you to automatically export quiz leads and data to a spreadsheet for easy management and analysis. This setup requires some advanced technical knowledge, as it involves configuring Google Cloud Console and linking your quiz with the spreadsheet. Follow this guide for a step-by-step walkthrough.

Step-by-step Setup Guide

Step 1: Add the Google Sheets Integration

Open the Quizell dashboard and navigate to the Integrations section.

Find Google Sheets and click “View Integration.”



On the Integration Detail page, click the “Connect” button



Click Authorize to Google Sheets to proceed.

Step 2: Setup Your Google Cloud Console

A. Create a New Project in Google Cloud Console.

Visit Google Cloud Console.

Create a New Project:

· Click on the project dropdown at the top of the page.

· Select New Project.

· Enter a name for your project and click Create.

B. Enable Google Sheets and Google Drive APIs

Go to APIs & Services > Library from the left sidebar.



Search for Google Sheets API, click on it, and then click Enable.



Repeat the process for the Google Drive API.

C. Create Service Account Credentials

Navigate to APIs & Services > Credentials.

Click Create Credentials and select Service Account.



Fill in the service account details:

· Enter a name (e.g., “sheets-access-account”).

· Optionally, provide a description.

· Click Create and Continue.



Skip assigning roles and user access by clicking Continue and then Done.

D. Generate and Download the JSON Key File

In your list of credentials, click on the service account you just created.



Go to the Keys tab and click Add Key > Create New Key.



Set the key type to JSON and click Create.



Download the JSON file containing your service account credentials. Make a note of where it is saved, as you will need it later.

E. Share Your Google Sheet with the Service Account

Open the Google Sheet you want to connect.

Click the Share button in the top-right corner.



Copy the email address of your service account (e.g., SERVICE_ACCOUNT_NAME@PROJECT_ID.iam.gserviceaccount.com).



Share the spreadsheet with this email address, set the permission to Editor, and click Send.

Step 3: Finalize the Google Sheet Integration Setup

Open the JSON file you downloaded and copy its contents.



Return to the Quizell dashboard:

· Navigate to the Google Sheets Integration page.

· Paste the JSON code into the dedicated field and click Save.



Select the quiz(zes) you want to connect to your spreadsheet and click Save.



On the Integration Detail page, click Modify Google Sheets.



Select a Google Sheet, choose a tab, and map your Lead Inputs with the Sheet Column Headers.

Tip: Ensure the Lead Inputs in your quiz match the column headers in your spreadsheet.



Click Save to confirm.

Step 4: Test the Integration

Complete your quiz to ensure data flows into your connected Google Sheet.

Verify that the lead inputs appear correctly in the spreadsheet.

Congrats! You’ve successfully connected your quiz to Google Sheets. With this integration, your lead data is automatically organized, giving you more time to focus on what matters most - engaging with your audience and converting leads. 🎉

Updated on: 15/01/2025