Sunday, August 4, 2013

Organizing Data Collected From a Google Form Using the DocAppender Script

When collecting paragraph text data from a google form, it can be really challenging to read. If the answers are long, sometimes you can't scroll to see the whole response.  And the data is incomplete and hard to read in the summary of responses.

Wouldn't it be nice to have all the data in a nice table or bulleted list on a google doc?  There is a solution!  The script, DocAppender, by Andrew Stillman, allows you to do just this.  Here is a sample document which has form submissions appended in a table to the bottom of the document.

I have created a screencast with step by step instructions on how to setup and run this script. 

This script will be a great tool when students are brainstorming ideas and I want to post them at the front of the room for all to see.  You can also use it to collect feedback or ideas at professional development workshops.  Andrew Stillman explains how he uses it for classroom observations in his video.  If you have other ideas on how to use this script, please leave a comment. 


  1. I was really excited to use this, but google gadgets has been eliminated from documents. I'm getting lost in the code trying to do this without the easy insert feature. Any ideas?

  2. I just actually set one up today. Are you using the new version of google sheets? Scripts don't work with the new version. You can switch it back to the old version of sheets by following the instructions here:

    1. Open Google Drive at
    2. Click the gear menu in the top right corner of the screen and select Settings.
    3. Click the Editing tab.
    4. Uncheck the box next to "Try the new Google Sheets."

    Let me know if this works for you. :)


  3. I've been using it to leave students feedback on their essays. It's an excellent tool!