Importing points earned in Google Forms (Quizzes)

  • 17 May 2020
  • 2 replies

I have created quizzes for my students using google forms. When I export the responses to a google spreadsheet it populates the fields with the answers selected instead of the points earned. Example of a multiple choice question: Which color is the bear's hat? Blue, Red, Green. The answer is red - earning a student 1 point. But when I export the data to a sheet the fields are populated with the answers (blue, blue, red, green, red, etc.). I would like it to populate with points earned (0, 0, 1, 0, 1, etc.) to better understand the quiz results. I have not found an add-on (or option within google) that would allow for this. I am trying to create a zap that could do this but I am unable to get it to pull that data - it only pulls the quiz total. Does anyone have any advice? 

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Userlevel 7
Badge +8

Hi @edwardstx ,

Thanks for reaching out! 

To help us better assist could you share a screenshot of your configuration (minus any personal information)? I’m hoping we can help you achieve your workflow by adjusting the mapping!

Will be on the lookout for your response!

Userlevel 7
Badge +11

Hi @edwardstx!

I wanted to check in with you on this one, since we didn't hear back after our last message. Did you still need help here or were you able to resolve things? Please let us know :)