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?
Log in to the Community
Use your Zapier credentialsLog in with Zapier
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.