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

Google Sheets Connector

With the QSM Google Sheets Connector Addon, you can effortlessly save quiz and survey results, user contact details, individual question scores, responder IP addresses, and any accompanying comments directly to Google Spreadsheets. This provides a convenient and efficient way to store and manage data without the need for manual copying and pasting.

Google Sheets Connector – QSM

Once you set up the integration add-on, 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 from the Plugins page.

From there, upload the zip file that you downloaded. Once the addon has been uploaded, you should have the plugin Google Sheet Connector listed in your list of plugins. Once activated, the addon will add a new tab in the Add-ons tab in a quiz labeled “Google Sheets”.

You can refer to this documentation for a detailed guide on how to install the QSM add-ons.

Settings/Configure

To configure the Addon, first enter your license key. Enter your license key from your QSM account into the “Manage License Key” section on the “Google Sheet Connector” settings in the Installed Add-ons under the Extensions tab in the QSM option from the side-panel.

add-license-key

Note that the addon won’t work without a valid license key. You can add the License Key from Addon Settings and also from Addon Options inside the individual quizzes/surveys.

Once the license key is validated, you need to Authorize the Google Sheet Connector so that the Google Sheets is connected with the QSM.

authorize-google-access-code

For this, you must first click the “Authorize” button besides the Google Access Code and allow the access for QSM to use Google Sheets, linking the Google account of your choice.

access google sheets qsm

Once the authorization process is completed, you’ll be redirected back to the QSM page. And you’ll see the “success” confirmation message dialogue box.

google-sheets-connected-with-qsm

After this, head on to your Quiz/Survey, edit one of the quiz or survey and navigate to the Add-ons > Google Sheets.

Google Sheet Settings

google-sheets-settings
Quiz and Survey Master – Google Sheets Connector – Configuring the Google Sheets Connector

1. Google Sheet ID: You now need to create a new spreadsheet 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

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

    3. Save only the contact information – If you want to save only the contact info in the Google Sheets, select “Yes,” else keep it as default that is – “No.”

    4. Save Custom Contact Fields – Enabling this option will populate the content of the custom contact fields that you create onto the Google Sheet

    5. 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.

    6. 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.

    7. Time Taken – Enable this option to automatically record the time users spend completing the quiz or survey in your connected Google Sheet. For this option to work, make sure the timer is enabled in the quiz or survey.

    8. Category Points – Enable this option to track and export the points earned in each category of your quiz or survey to your Google Sheet. For this option to work, make sure you have assigned proper categories for the questions or sections

    9. Category Score – Enable this option to automatically populate your Google Sheet with the scores for each category in the quiz or survey. For this option to work, make sure you have assigned proper categories for the questions or sections

    Including User Comments in Google Sheets

    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.

    Educators & Professional Web Developers, Try QSM!

    4.9 / 5
    Over 1 million downloads

    Subscribe to Our Newsletter

    Get weekly updates, no spam guaranteed we promise ✌️