Summer Savings! Enjoy 20% OFF on All QSM Bundles. Upgrade Today!

Google Sheet Connector

Google sheet connector

With QSM’s Google Sheet Connector, you can seamlessly connect your Quiz and Survey Master quizzes and surveys to Google Sheets, allowing you to automatically populate your spreadsheets with data as it is collected. This eliminates the need for manual data entry, saving you time and hassle.

Automate the process of sending form responses in real-time by using this addon. Responses are synced automatically to your preferred Google Sheet in real-time. Process the data, and preserve it for later reference or use it to your benefit.

Within the WordPress admin panel, we have an excellent interface for collecting user inputs such as email, name, quiz, and survey data. However, there are times when we need to export user input data to a live sheet that we can share with coworkers.

Automatically sync your quiz results with Google Sheets (Google Spreadsheets).

Top Features

  • Simple & Easy to Configure Google Sheets Addon
  • Access form data anytime without logging into WordPress
  • Eliminates the tiring task of copying & pasting responses
  • Data transfer happens in real-time
  • Data can be preserved & further utilized with Google Sheets

Minimum Setup, Maximum Impact

To begin, enter your account’s license key into the “Addon License Key” field on the “Google Sheet Connector” tab of the “Addon Settings.”

Now you’ll need the Google Access Code to connect the Google Sheets Connector to Google Sheets. To do so, first, click the “Authorize” button and then follow the on-screen instructions to link the Google account of your choice. You will receive a success notification.

Navigate to QSM > Addons > Google Sheets. Now, you must create a new Spread Sheet in Google Sheets and copy the URL enclosed between the forward slashes. Copy the Google ID code from the URL and paste it into the Google Sheet ID field.

And, in the Tab Name field, type “Sheet1” for the Sheet Tab Name. If you only want to save the contact information, select “Yes,” otherwise leave it alone and click the Save Settings button.

License Terms & Documentation

All add-ons can be used indefinitely once purchased. Add-ons include 1 year of support and updates.

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.

Screenshots

Similar Addons

Discover the universe within our addons.

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 ✌️
Changelog

2.5.1 (October 07, 2024)

  • Bug: Fixed issue with question points

2.5.0 (September 17, 2024)

  • Feature: Added option to export category scores and points

2.4.0 (September 03, 2024)

  • Feature: Added option to export time taken

2.3.0 (August 27, 2024)

  • Feature: Added option to export label points

2.2.0 (July 8 2024)

  • Bug: Fixed disable re-authorize notice for new users
  • Enhancement: Improved exception handle, in case google sheet connection fails.

2.1.9 (March 05, 2024)

  • Bug: Fixed issue with file links

2.1.8 (September 13, 2023)

  • Bug: Fixed issue while exporting special characters

2.1.7 (September 01, 2023)

  • Feature: Added option to export question points

2.1.6 (July 06, 2023)

  • Feature: Added option to enable/disable export question comments

2.1.5 (June 21, 2023)

  • Feature: Added option to export question comments

2.1.4 (November 09, 2022)

  • Bug: Added backward compatibility

2.1.3 (August 01, 2022)

  • Bug: Fixed duplicate contact fields issue.
  • Bug: Fixed issue with update notifications while saving settings.

2.1.2 (April 19, 2022)

  • Feature: Added IP address to Google sheets.

2.1.1 (March 17, 2022)

  • Bug : Fixed issue with license key

2.1.0 (October 11, 2021)

  • Bug: Fixed the issue of timestamp format.

2.0.9 (September 10, 2021)

  • Bug: Fixed the issue of Illegal string offset error.
  • Enhancement: Added translation support.

2.0.8 (July 15, 2021)

  • Enhancement: Added translation support.
  • Bug: Fixed issue custom contact field not importing in google sheets.

2.0.7 (October 27, 2020)

  • Bug: Fixed questions with the same description missing in google sheet.

2.0.6 (September 16, 2020)

  • Bug: Fixed issues while recording score with new grading options.

2.0.5 (August 27, 2020)

  • Bug: Hidden questions issue fixed.

2.0.4 (August 03, 2020)

  • Feature: Added send URL parameters to Google sheets.
  • Feature: Added timestamp to Google sheets.

2.0.3 (July 21, 2020)

  • Enhancement: Added QSM CORE 7.0.0 support.

2.0.2 (May 29, 2020)

  • Bug: Fix Google client library.

2.0.1 (May 26, 2020)

  • Bug: Fix Google token not refreshing after expiration.

2.0.0 (May 18, 2020)

  • Updated to latest Google Library
  • Bug: Fix Quiz results not showing issue
  • Bug: Fix Quiz results not saving into google sheet

1.0.1

  • Bug: Fixed Fatal Error
  • Bug: Fix Quiz submit issue
  • Feature: Added contact details with result in Google spreadsheets
  • Feature: Added option to save only contact details in Google spreadsheets

1.0.0

  • Initial Release