Quiz Maker is a website that allows you to create and publish quizzes, surveys, trivia, polls, online forms, personality tests, and other types of content.
Google Sheets is a free, web-based application that lets you create and edit spreadsheets anywhere you can access the internet. Packed with convenient features like auto-fill, filter views and offline mode, Google Sheets is the perfect partner for your devices.Google Sheets Integrations
WordPress Quiz Maker + Google SheetsCreate Spreadsheet Row to Google Sheets from New Quiz in WordPress Quiz Maker Read More...
WordPress Quiz Maker + Google SheetsUpdate Spreadsheet Row in Google Sheets when New Quiz is created in WordPress Quiz Maker Read More...
WordPress Quiz Maker + Google SheetsShare Sheet in Google Sheets when New Quiz is created in WordPress Quiz Maker Read More...
WordPress Quiz Maker + Google SheetsCreate Spreadsheet Row to Google Sheets from New Question in WordPress Quiz Maker Read More...
WordPress Quiz Maker + Google SheetsUpdate Spreadsheet Row in Google Sheets when New Question is created in WordPress Quiz Maker Read More...
It's easy to connect WordPress Quiz Maker + Google Sheets without coding knowledge. Start creating your own business flow.
Triggers when a new question is created
Triggers when a new quiz is created
Triggers once a new spreadsheet is created.
Triggered when a new row is added to the bottom of a spreadsheet.
Trigger when a new row is added or modified in a spreadsheet.
Delete a Quiz
Insert a new row in the specified spreadsheet.
Create a new spreadsheet row or Update an existing row.
Share Google Sheet.
Update a row in a specified spreadsheet.
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 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.
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.
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.