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.
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.
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
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.
After this, head on to your Quiz/Survey and voila you would see a newly created tab with the name “Google Sheets”.
You now need to create a new Spread Sheet in Google Sheets and then copy the URL which is enclosed in between forward slashes.
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.
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.