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 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 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 from your account into the “Addon License Key” field on the “Google Sheet Connector” tab of the “Addon Settings”. 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 would see a newly created tab with the name “Google Sheets”.

Quiz and Survey Master - Google Sheets Connector -  Configuring the Google Sheets Connector
Quiz and Survey Master – Google Sheets Connector – Configuring the Google Sheets Connector

You now need to create a new Spread Sheet in Google Sheets and then copy the URL 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 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 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.

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

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.