A while back, I wrote about a new Google Sheets response system I created for use in class. I suggest you go back and read that first if you haven't read it yet.
First, I uploaded the template in to the gallery. That's the best place to download and use the spreadsheet because everything copies over correctly.
The biggest update is in the setup process. Rather than posting a URL on your board, it will now create a QR code automatically for your students to scan.
Notice the tab at the bottom wasn't there before clicking the button - it adds the code to a new sheet. You only need to do this once because the other functions (outlined in the first post) clear out responses in the template with each question.