1. Home
  2. Knowledge Base
  3. The Digioh Platform
  4. How to Upload your Products in the Qwizard with a GSheet CSV

How to Upload your Products in the Qwizard with a GSheet CSV

Using the Qwizard, it is simple to add your products in order to build your quiz!

To start, your products will need to be in a GSheet with the following format:

  • The first row is set with column headers, including:
    • PRQ:ID
    • PRQ:Name
    • PRQ:Any other columns of information you may need to add for each product (ex: PRQ:SKU, PRQ:Description, etc)
  • Each product is in its own row
  • The first column of each row includes an id number for the product (this makes weighing the quiz much simpler)
  • The second column of each row includes the product name

 

Next, you will need ensure that the GSheet is shared properly.  Under the “Sharing” settings, be sure it is set to “Anyone with the link” and “Viewer”:

Then, update the URL of your GSheet using the following ending page path: /export?format=csv&gid=0

For example, this URL of a product GSheet CSV:

would be updated to:

Once that path is on the end of the URL, copy the URL to your clipboard.

Then, head to the QWizard

  • Enter The Quiz Name
  • Enter your Store Type (example will use “Other”)
  • Enter the GSheet URL in the Input when prompted
  • Complete the Integration Step
  • Complete the Google Analytics step
  • Choose whether to have an Email Collection page
  • Choose your first page layout
  • See your products in the weighing inputs!

 

You are now set up to build your quiz in the QWizard!

Please see our other documentation to help you in quiz creation:

If you have any further questions or would like to set up a Product Recommendation Quiz, please contact us.

Updated on February 13, 2025
Was this article helpful?

Related Articles

Need Support?
Can't find the answer you're looking for?
Contact Support