> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.tevello.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 Automatically Add New Quiz Completions To a Google Sheet

${youtube}[How To Automatically Add New Quiz Completions To a Google Sheet](wiEBGoMM5Y4)

### Overview:
Streamline the process of capturing quiz answers directly into Google Sheets using Shopify Flow and Google Sheets integration for easy tracking and analysis.

**Prerequisites:**
1. Access to Shopify Flow app. If not already installed, download it from the Shopify App Store. [CLICK HERE](https://apps.shopify.com/flow?search_id=58421745-b016-4a10-a489-d14e1089a91a&surface_detail=flow&surface_inter_position=1&surface_intra_position=5&surface_type=search)
2. Template provided for automating course completion tags. [LINK to Template](https://shopify.com/admin/apps/flow/editor/templates/01909cf1-66fa-7d6b-937b-04c55ee17f7c)
3. Google Sheets for Shopify connector.

**Steps:**
****
1. Navigate to Shopify Flow in your Shopify admin. If you haven't installed Shopify Flow, download and install it from the Shopify App Store.
| Access to Shopify Flow app. If not already installed, download it from the Shopify App Store. [CLICK HERE](https://shopify.com/admin/apps/flow/editor/templates/01955d8c-4815-7da1-ad27-6204fa28d67b)

2. **Install Template**: Open the template link [HERE](https://shopify.com/admin/apps/flow/editor/templates/01909cf1-66fa-7d6b-937b-04c55ee17f7c)

What the template looks like. 
![](https://storage.crisp.chat/users/helpdesk/website/e916a79d3dced000/01-template_10ng33q.png)

3. Click **"Install"** at the top right corner.
![](https://storage.crisp.chat/users/helpdesk/website/e916a79d3dced000/01-install_1m2fubm.png)

4. Then **"Install"** again to confirm.
![](https://storage.crisp.chat/users/helpdesk/website/e916a79d3dced000/02-verify-install_x3n862.png)
| IMPORTANT: Ensure you are logged into the correct Shopify store when installing the template.

5. **Integrating Google Sheets** : Click Add row to spreadsheet
![](https://storage.crisp.chat/users/helpdesk/website/e916a79d3dced000/02-add-row-to-template_164gess.png)

6. Install the Google Sheets for Shopify connector by clicking the **installation button**.
![](https://storage.crisp.chat/users/helpdesk/website/e916a79d3dced000/03-install_k7u5pl.png)

7. **Configuring the Spreadsheet**  Create a new Google Spreadsheet and customize it to capture the desired quiz data (e.g., Email, Name, Lesson Link, Answers). Then **Copy and paste the spreadsheet's URL** into the Shopify Flow template configuration to link them.
![](https://storage.crisp.chat/users/helpdesk/website/e916a79d3dced000/04-add-spreadsheet-link_1umbc4c.png)

8. Properly set up column headers in your Google Spreadsheet to match the data being captured (e.g., Email, Name, Lesson Link, Answer 1).
![](https://storage.crisp.chat/users/helpdesk/website/e916a79d3dced000/setting-up-kamilles-demo-store_1w1e2wi.png)

9. **Activate the Workflow:** If the pre-configured settings meet your needs, activate the workflow by clicking **Turn on Workflow.**
![](https://storage.crisp.chat/users/helpdesk/website/e916a79d3dced000/03-turn-on_rr07bi.png)

10. Verify activation by cliking **Turn on again**
![](https://storage.crisp.chat/users/helpdesk/website/e916a79d3dced000/04-turn-on_1xgfjbm.png)

| Test and verify the integration by completing a quiz within the configured course to ensure that responses are correctly captured and appear in the Google Sheet.
| Also check for any delays or errors in data transmission between Shopify Flow and Google Sheets. Adjust settings as necessary to resolve any issues.