Join Scott Simpson for an in-depth discussion in this video Accessing and editing a spreadsheet, part of Learning Google Apps Script.
- I work very extensively with Google Sheets,…and luckily Apps Script allows me to work with…an extendum programmatically.…The documentation has detailed information…about all kinds of things you can do with Sheets.…But I want to take a look at just a few…of the basic aspects here to get you started.…I'll go to the IDE,…and for this I'll create a new script file.…I'll call it 'Spreadsheet',…but you can call it anything you like.…To create a spreadsheet,…we'll use the Spreadsheetapp.create method.…
I'll call my spreadsheet 'My spreadsheet'.…This spreadsheet object, which I've called SS for short,…has a lot of the same methods that a doc has,…or any other object in Google Apps.…You can modify the editors, the viewers,…and you can get the ID,…just like we did in the previous movie.…But for now, I'll just run this to create a spreadsheet.…I'll authorize it, if need be,…switch to my drive, and here's my spreadsheet.…
I'll open it up and go to the URL bar to copy the unique ID.…Remember, that's in between D slash and slash edit.…
First, learn how to use simple scripts to edit documents and spreadsheets, work with files in Drive, and find and send messages in Gmail. Then find out how to add custom functionality to your spreadsheets, and build user interface elements for your scripts, using menus, alerts, and dialogs. Finally, Scott shows how to share your work with others by publishing scripts as web apps.
- What is Google Apps Script?
- Understanding script types
- Logging and debugging your scripts
- Scripting common tasks
- Building custom spreadsheet functions
- Creating add-on functionality such as dialogs and sidebars
- Sharing your script as a web app