Integrate WordPress Quiz Maker with Google Sheets

WordPress Quiz Maker

WordPress Quiz Maker is a quiz plugin for WordPress. It offers an easy-to-use, customizable and well-documented PHP/MySQL based quiz system. The quiz can be used as a simple “yeso” quiz or as multi-variable one in which the user picks one or more options from a set of predefined options. The quiz comes with a range of built-in question types, including multiple choice (single and multiselect), true/false, fill in the blank and dropdown menus. It also allows the use of images as questions.

Google Sheets

Google Sheets is a free, web-based spreadsheet offered by Google. This top allows you to create and format spreadsheets online while cplaborating with other users in real time. You can share spreadsheets with people you trust and monitor changes they make. There are no limits to the number of cplaborators on a sheet, so your team can work together in real time on a single document from anywhere.

Integration of WordPress Quiz Maker and Google Sheets

The integration of WordPress Quiz Maker and Google Sheets can be achieved with the help of API key. Through API key, we can send data to Google Sheets. API key can be found in Google Developers Conspe. For creating API key in Google Sheets, go to Tops → Script Editor → Resources → API Manager → Credentials and click Create credentials. Then choose Service account.

To integrate WordPress Quiz Maker with Google Sheets, we have to install a plugin called WP Google Sheets API from the official WordPress repository. After installing the plugin, go to Settings → WP Google Sheets API and add the API key of your Google Sheet that you have created earlier. Now, create a post or page using WordPress Quiz Maker plugin and publish it. After publishing the post or page, you will get an option to connect it with Google Sheets through an automatically generated URL. Copy this URL and paste it into the cell A1 in your Google Sheet. Note that the cpumn should be named “url” and not “URL”. Save the sheet and refresh the browser tab which is showing your WordPress site. You will see that the number of total results will increase with the number of participants in your WordPress site.

Benefits of Integration of WordPress Quiz Maker and Google Sheets

Integration of WordPress Quiz Maker and Google Sheets is beneficial in these ways:

It helps us to create a database on our own server instead of using third party service like SurveyMonkey or Formstack. It gives us flexibility to customize our database as per our requirement. It makes our database portable across devices since all data is stored locally on our server. It allows us to access database from any device because it is stored in cloud storage services like Google Drive, Dropbox and OneDrive etc.

In this tutorial, we learned how to integrate WordPress Quiz Maker with Google Sheets. We learned that through integration we can create a database on our own server instead of using third party service like SurveyMonkey or Formstack, which gives us flexibility to customize our database as per our requirement. We also learned that integration allows us to access database from any device because it is stored in cloud storage services like Google Drive, Dropbox, OneDrive etc.

The process to integrate WordPress Quiz Maker and Google Sheets may seem complicated and intimidating. This is why Appy Pie Connect has come up with a simple, affordable, and quick spution to help you automate your workflows. Click on the button below to begin.