> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.quizell.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# How to Connect Your Quiz to Google Sheets


### 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

1. Open the **Quizell dashboard** and navigate to the **Integrations** section.

2. Find **Google Sheets** and click **“View Integration.”**

![Find google sheets at the integration section](https://storage.crisp.chat/users/helpdesk/website/-/9/c/4/e/9c4e823823ced00/screenshot-1028-114535-am_ciwnge.jpg)

3. On the **Integration Detail** page, click the **“Connect”** button

![](https://storage.crisp.chat/users/helpdesk/website/-/9/c/4/e/9c4e823823ced00/screenshot-1028-114719-am_17keqsj.jpg)
# Step 2: Setup Your Google Cloud Console in a new tab

### A.  Create a New Project in Google Cloud Console.

1. Visit [Google Cloud Console](https://console.cloud.google.com/).

2. 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**.

![](https://storage.crisp.chat/users/helpdesk/website/9c4e823823ced00/capture-decran-2025-01-15-a-17_1e4hfl0.png =1000x239)
**
### B. Enable Google Sheets and Google Drive APIs

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

![](https://storage.crisp.chat/users/helpdesk/website/9c4e823823ced00/capture-decran-2025-01-15-a-17_6q4kem.png =1000x574)

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

![](https://storage.crisp.chat/users/helpdesk/website/9c4e823823ced00/capture-decran-2025-01-15-a-17_1fok187.png =600x376)

3. Repeat the process for the **Google Drive API**.

![](https://storage.crisp.chat/users/helpdesk/website/9c4e823823ced00/capture-decran-2025-01-15-a-17_a815nh.png =600x397)

### C. Create Service Account Credentials

1. Navigate to **APIs & Services > Credentials**.

2. Click **Create Credentials** and select **Service Account**.

![](https://storage.crisp.chat/users/helpdesk/website/9c4e823823ced00/capture-decran-2025-01-15-a-17_ju7sup.png =1000x348)

3. Fill in the service account details:

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

·      Optionally, provide a description.

·      Click **Create and Continue**.

![](https://storage.crisp.chat/users/helpdesk/website/9c4e823823ced00/capture-decran-2025-01-15-a-17_1057ntc.png =600x686)

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

### D. Generate and Download the JSON Key File

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

![](https://storage.crisp.chat/users/helpdesk/website/9c4e823823ced00/capture-decran-2025-01-15-a-17_g1auip.png =1000x358)

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

![](https://storage.crisp.chat/users/helpdesk/website/9c4e823823ced00/capture-decran-2025-01-15-a-17_r7thuf.png =1000x348)

3. Set the key type to **JSON** and click **Create**.

![](https://storage.crisp.chat/users/helpdesk/website/9c4e823823ced00/capture-decran-2025-01-15-a-17_5o9f0z.png =1000x670)

4. Download the JSON file containing your service account credentials. Make a note of where it is saved, as you will need it later.
| Make sure to copy the full json content from the file, it may be long text, but it's working :)  

### E. Share Your Google Sheet with the Service Account

1. Open the Google Sheet you want to connect.

2. Click the **Share** button in the top right corner.

![](https://storage.crisp.chat/users/helpdesk/website/9c4e823823ced00/capture-decran-2025-01-15-a-17_13h17ns.png =1000x573)

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

![](https://storage.crisp.chat/users/helpdesk/website/9c4e823823ced00/capture-decran-2025-01-15-a-17_1ff55i3.png =1000x351)

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

![](https://storage.crisp.chat/users/helpdesk/website/9c4e823823ced00/capture-decran-2025-01-15-a-17_8chy39.png =1000x574)

# Step 3: Finalize the Google Sheet Integration Setup

1. Open the JSON file you downloaded and copy its contents.

2. Return to the Quizell dashboard:

·      Navigate to the **Google Sheets Integration** page.

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

![](https://storage.crisp.chat/users/helpdesk/website/-/9/c/4/e/9c4e823823ced00/screenshot-1028-115013-am_rbpv47.jpg)

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

5. On the Integration Detail page, click **Modify Google Sheets**.

![](https://storage.crisp.chat/users/helpdesk/website/-/9/c/4/e/9c4e823823ced00/screenshot-2810-115144-lfnhts_hjrpl3.jpg)

6. 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.

![](https://storage.crisp.chat/users/helpdesk/website/-/9/c/4/e/9c4e823823ced00/screenshot-2025-10-28-at-11533_8j4qkb.png)

7. Click **Save** to confirm.

# Step 4: Test the Integration

1. Complete your quiz to ensure data flows into your connected Google Sheet.
2. 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. 🎉