1. Home
  2. Docs
  3. Addons
  4. Google Sheets Connector

Google Sheets Connector

Using Quiz and Survey Master Google Sheets Connector Addon you can save the Quiz and Survey Master quizzes/survey results, user contact information, individual question points score, responder’s IP Address, and the corresponding user comments (if any) directly to the Google Spread Sheets. It is a very convenient way of saving and preserving data without manually copying and pasting it.

Google Sheets Connector – QSM

Once you set up the integration addon the data is automatically updated 24×7 as and when the quiz/survey is taken by the respondents.

Quiz and Survey Master - Google Sheets Connector Addon - Data saved in Google Sheets
Quiz and Survey Master – Google Sheets Connector Addon – Data saved in Google Sheets

Installation/Setup

Once you have purchased the addon, you will have access to download the addon. To install, upload the addon as a normal WordPress plugin. To do so, go to the Plugins page and click Add New. Then, click Upload.

From there, upload the zip file that you downloaded when downloading the addon. Once the addon has been uploaded, you should now have the plugin QSM – Google Sheet Connector listed in your list of plugins. Activate that plugin. Once activated, the addon will add a new tab in the Addon Settings labeled “Google Sheets”.

Settings/Configure

Quiz and Survey Master - Google Sheets Connector - Authorizing Google Access Code
Quiz and Survey Master – Google Sheets Connector – Authorizing Google Access Code

To configure the Addon First, enter your license key. Note that the addon won’t work without a valid license key. Enter your license key from your account into the “Addon License Key” field on the “Google Sheet Connector” tab of the “Addon Settings” in Installed Addons. You can add the License Key from Addon Settings and also from Addon Options inside the individual quizzes/surveys. Be sure to click “Save Changes”.

After, pasting the License Key you need the Google Access Code to link the Google Sheets Connector with the Google Sheets.

For this, you must first click the “Authorize” button and follow the said steps, by linking the Google account of your choice.

If all goes well you will get the below notification mentioning the success of the authorization.

Quiz and Survey Master - Google Sheets Connector -  Google Access Code Authorization Success
Quiz and Survey Master – Google Sheets Connector – Google Access Code Authorization Success

After this, head on to your Quiz/Survey and voila you will see a newly created tab with the name “Google Sheets”.

Once in, you will have access to all the Google Sheet Settings.

Google Sheet Settings

google sheet connector - QSM
Quiz and Survey Master – Google Sheets Connector – Configuring the Google Sheets Connector

Google Sheet ID: You now need to create a new Spread Sheet in Google Sheets and then copy the URL strings which is enclosed in between forward slashes.

Quiz and Survey Master - Google Sheets Connector - Copy the Google Sheets ID
Quiz and Survey Master – Google Sheets Connector – Copy the Google Sheets ID

For example, if the URL is like this https://docs.google.com/spreadsheets/d/155nWYcesaayQxu2LkwpkBQKrIwRJ2YdVvJ8NZpb145UVcw/edit#gid=0

Then copy the code which is like 155nWYcesaayQxu2LkwpkBQKrIwRJ2YdVvJ8NZpb145UVcw and paste it into the Google Sheet ID field.

Quiz and Survey Master - Google Sheets Connector - Copy the Google Sheet Tab Name
Quiz and Survey Master – Google Sheets Connector – Copy the Google Sheet Tab Name

And, in the Google Sheet Tab Name field enter the Sheet Tab Name which in this case is “Sheet1“.

If you want to save only the contact information select “Yes” else keep it as it is and hit the Save Settings button.

The addon now allows you to Save Custom Contact Fields, Save question comments, and Individual Question Scores:

  • Save Custom Contact Fields – Enabling this option will populate the content of the custom contact fields that you create onto the Google Sheet
  • Save Question’s Comment – Enabling this option will populate the comments for each question onto your Google Sheet. For this feature to work perfectly make sure you’ve enabled the Comment Box in each question along with the intended field type.
  • Save Individual Question Score – Enabling this option will populate the scores earned for individual questions in the quiz onto the Google Sheet. This option is perfect for graded quizzes and tests using the points/score grading system.

Including User Comments in Google Sheet

Google Sheet Connector addon now allows you to populate the user comments of each question in the connected Google Sheet. For this feature to work, make sure you have enabled Comment Box on questions in the “Questions Tab” and have included the %USER_COMMENTS% variable in the %QUESTIONS_ANSWERS% Text of the “Text Tab” as seen below.

Google Sheet Connector - Populate user comments

Go ahead and run the Quiz you will find the quiz data is being automatically stored in your set Google Sheet and saved for future reference.

Note: QSM Google Sheets Add-on may not function properly when combined with other plugins that require authorization of the same Google Sheet where QSM is already authorized.

If you have any trouble implementing the Google Sheets Connector Addon or have more questions about the process, please fill out a support ticket by going to the WordPress dashboard and selecting ‘help’ in the QSM plugin and our support guru will be able to help you.

How can we help?