Articles on: Members

How To Automatically Add New Quiz Completions To a Google Sheet


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
  2. Template provided for automating course completion tags. LINK to Template
  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


  1. Install Template: Open the template link HERE


What the template looks like.


  1. Click "Install" at the top right corner.


  1. Then "Install" again to confirm.

IMPORTANT: Ensure you are logged into the correct Shopify store when installing the template.


  1. Integrating Google Sheets : Click Add row to spreadsheet


  1. Install the Google Sheets for Shopify connector by clicking the installation button.


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


  1. Properly set up column headers in your Google Spreadsheet to match the data being captured (e.g., Email, Name, Lesson Link, Answer 1).


  1. Activate the Workflow: If the pre-configured settings meet your needs, activate the workflow by clicking Turn on Workflow.


  1. Verify activation by cliking Turn on again


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.

Updated on: 05/03/2025

Was this article helpful?

Share your feedback

Cancel

Thank you!