How to Integrate Google Sheets with Quiz Maker


Google Sheets and ProProfs Quiz Maker integration allows you to seamlessly collect key data of your quiz takers and analyze them better. The integration lets you auto-populate the spreadsheet and quickly shortlist data by applying filters.

Here’s how the quiz data will appear after successful integration.


Google Sheet preview with Quiz Taker's Data


By integrating with Google Sheets, you can:


  • Collect quiz taker’s data automatically in a spreadsheet
  • Quickly sort and filter data based on your preferences
  • Use the data to improve quiz quality


To integrate with Google Sheets:


1. Go to quiz Settings.



2. Switch to the Integrations tab and activate the Google Sheets integration by toggling to Yes.



3. A prompt window will open to link your Google account with ProProfs Quiz Maker. Click Login with Google > Choose your account > Allow permission. 


Log in to your Google Account in the Prompt screen


4. After successfully linking your account, you will be prompted to create a new spreadsheet for collecting the information via your quiz. Enter the sheet name and click Continue.



Next up, you can open the sheet using the action button.


Confirmation of a New spreadhseet in Google Sheets


Now, whenever somebody takes your quiz, the system automatically updates the data associated with them to the sheet. 


Here’s how the data collected in real-time will look like:


Collected data of the quiz taker's auto-populated in the Google Sheet


And that's it! If you encounter any issues or have any questions, don't hesitate to reach out to our support team


© 2005 - 2024 ProProfs
add chat to your website