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

Google Sheets Connector

Documentation for 7.0 version of plugins is available at QSM 7.0 Documentation

Google Sheets Connector is used to save the QSM quizzes/surveys results to the Google Spread 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

To configure the Addon first add the Addon License Key which you have received while purchasing this addon.

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.