Join Scott Simpson for an in-depth discussion in this video Reading information from a spreadsheet, part of Learning Google Apps Script (2013).
Here I've got a spreadsheet with some data…in it representing students in an art class.…I want to use the data in the spreadsheet for a script,…so I'm going to take advantage of Google App Script's Spreadsheet App Class.…As with a document App Class, I'm only going…to use a few of the many available features.…So be sure to explore the documentation to find out more.…The first thing I need to do is to tell my script what spreadsheet to use.…Luckily that's pretty easy.…I can just copy the key or ID from the address bar and set…up an object with the open by ID method.…
Let's find out a little bit about this spreadsheet using some…of the methods available on the…spreadsheet class and the Logger.log function.…The get num sheets method returns an integer…of how many sheets are in the spreadsheet.…And the get viewers method will tell us who the viewers are.…So let's run that, and go into the logs.…And we can see that there's one sheet in the spreadsheet.…And what do you know, there's one viewer.…So a spreadsheet is made up of other elements just like a document is.…
- What is Google Apps Script?
- Creating and editing files with Apps Services
- Storing data for your script
- Using events and triggers in containers
- Building custom spreadsheet functions
- Sharing your script as a web app
- Serving JSON or XML from your script
- Publishing your app in the Chrome Web Store