How to Combine Aryel CRM with Google Form

Have you ever wanted to transform your Google Form surveys into engaging and fascinating experiences for your audience, all while retaining the reporting capabilities? With Aryel CRM suite, you can! Our platform offers the variables feature, allowing seamless communication between Google Forms and Aryel, making the integration easy and efficient.

In this article, we'll guide you through the process of converting a multiple-choice quiz from Google Form into an AR quiz controlled by facial gestures.

Part 1: Setting Up Your Aryel Campaign

Let's assume you've created a Google Form with a set of questions.
The first step is to replicate the same question structure in Aryel. You can either use one of our templates and customize it or start from scratch to design it according to your preferences. Ensure that users can advance to the next question by flipping their heads left or right.
Next, you'll need to create the variables for each question in your quiz. Here's how:

• Access the 'Variables' settings.

• Create variables using the 'Create variable' button. Ensure to fill in all the required fields, including Name (in curly brackets), Type (select 'text'), and Starting value (can be 'null' or a blank space).

  

• Once the variables are set up, you'll need to assign values to them based on the user's answers. Create interactions for each answer that set the corresponding variable to the answer value. For this example, the interaction will have the following values:

  • Starting event: tilt head left/right

  • Result of interaction: set variable Qx = the+answer+to+this+question - where Qx is the name of the variable you need to set and the text of the answer is exactly the same as included in Google Form, but the spaces are replaced by the '+' symbol.

  

• Finally, set up the submission of answers by adding a 'go to link' interaction on the final question's answers. The link should be a slightly revised pre-filled form link from Google Form with variables replacing the values.
  The one in use in our example is:
  https://docs.google.com/forms/d/e/1FAIpQLSfHfJft1JWmbgLVEjeI24g8eh1VgWUdxdamhh2D4izuu5YWrQ/formResponse?usp=pp_url&entry.61647477={Q1}&entry.165207568={Q2}&entry.1617385571={Q3}&entry.1698127594={Q4}&entry.701805998={Q5}&submit=Submit

How to Get the Submission Link from Google Form

1. Get a pre-filled link in Google Form.

   • Open your Google Form and access the kebab menu on the top right.

   • Select 'Get pre-filled link'.
     

   • Fill out the form with sample answers, then click 'Get link' and 'Copy Link'.
     

   • The copied link will look like this:
     https://docs.google.com/forms/d/e/1FAIpQLSfHfJft1JWmbgLVEjeI24g8eh1VgWUdxdamhh2D4izuu5YWrQ/viewform?usp=pp_url&entry.61647477=2020+-+during+the+pandemic&entry.165207568=Milan,+Italy&entry.1617385571=Innovation&entry.1698127594=For+fun+pointless+AR+experiences&entry.701805998=44

2. Analyze the link to understand the changes you will make.

   • https://docs.google.com/forms/d/e/1FAIpQLSfHfJft1JWmbgLVEjeI24g8eh1VgWUdxdamhh2D4izuu5YWrQ/viewform -> the first part of the link is the one that identifies the form and will open the it in a visualization mode, ready to be filled.

   • ?usp=pp_url&entry.61647477=2020+-+during+the+pandemic&entry.165207568=Milan,+Italy&entry.1617385571=Innovation&entry.1698127594=For+fun+pointless+AR+experiences&entry.701805998=44 -> the second part is made of the query parameters that pre-fill the form. Each 'entry.xxxxxx' is the identification value of the question and is followed by the value we used to pre-fill the form (e.g. '=Milan,+Italy').

3. Replace the values with the corresponding variables' names.

   • To get the form be filled out with the answers given in the AR campaign, you'll simply replace in the second part of the link these values with the corresponding variable. So we end up having: https://docs.google.com/forms/d/e/1FAIpQLSfHfJft1JWmbgLVEjeI24g8eh1VgWUdxdamhh2D4izuu5YWrQ/viewform?usp=pp_url&entry.61647477={Q1}&entry.165207568={Q2}&entry.1617385571={Q3}&entry.1698127594={Q4}&entry.701805998={Q5}

4. Change this link to the submission one.

   • To do so, change 'viewform' to 'formResponse' and add '&submit=Submit' at the end of the URL.
     https://docs.google.com/forms/d/e/1FAIpQLSfHfJft1JWmbgLVEjeI24g8eh1VgWUdxdamhh2D4izuu5YWrQ/formResponse?usp=pp_url&entry.61647477={Q1}&entry.165207568={Q2}&entry.1617385571={Q3}&entry.1698127594={Q4}&entry.701805998={Q5}&submit=Submit

Voila! Now, all responses to your quiz will be collected in Google Form seamlessly through your AR campaign.

Let the creativity flow and enjoy transforming your surveys into captivating AR quizzes with Aryel!