Using Google Scripts to Move Data Like a Bulldozer - Forms to Documents
As we gather more data using Google Forms and Spreadsheets there are a lot of questions out there about how we can reformat and share this data in a more consumable understandable way. In the last couple of months the Maine 207 technology team of Mark Ordonez and Janice Cacciatore and Hank Thiele have tackled this issue on several projects and as a result have created a reproducible Google Script that takes the information off a spreadsheet and ultimately creates a unique document that can be shared with anyone. Our initial purpose of attempting this was not that exciting of a project, however it proved a concept that we believe will make gathering and sharing data in Google Docs a more powerful, dynamic, and interactive process. What we initially set out to do was take a spreadsheet with information about school payments and create letters that would be mailed out to individual families. This has developed into this repeatable process: To make this easier to replicate we