Google Apps Scripts

Bulk Operations with Google Spreadsheets and Google Apps Script

Bulk Operations with Google Spreadsheets and Google Apps Script

For a current project I need to aggregate student and staff information from many Google Spreadsheets into a Cloud SQL database. The database is the back end for a web application that securely serves this information to the schools in the New Visions for Public Schools network. Opening each spreadsheet, locating the data of interest, copying and pasting the data into a master spreadsheet, downloading the master spreadsheet as a CSV and then uploading it to the database would take too long to make this project feasible especially considering that the process just described would have to be repeated many times throughout the school year as the data frequently changes. As a result of this need and others like it, the New Visions Systems Team uses bulk operation techniques to make a new kind of data and systems driven network support model possible at the scale of 80 district public high schools in New York City serving over 50,000 students.