Getting Started With Google Apps Script
Explore and create : Creation lab
Dr. Wanda Terral
Ever wonder how Google Docs/Sheets/Slides/Forms add-ons work? This session is a beginner’s look at just that. Leave being familiar with the basics of Google Apps Script and how it allows interactions with G Suite applications. Even write your first simple add-on before you go!
|Audience:||Chief technology officers/superintendents/school board members, Technology coordinators/facilitators|
|Attendee devices:||Devices required|
|Attendee device specification:||Laptop: Chromebook, Mac, PC
|Participant accounts, software and other materials:||In order to write and run the scripts they create, attendees will need a computer (not a tablet) and access to a Google account with access to script.google.com. Additionally, they would need access to other Google services (Docs, Sheets, Slides, Mail) in order to run some of the sample scripts. Managed G Suite accounts may not have the needed access so attendees are encouraged to use a consumer Google account.|
|Topic:||Online tools, apps & resources|
|ISTE Standards:||For Coaches:
Content Knowledge and Professional Growth
Participants will learn how Google Apps Script works by writing their own scripts, running them, and seeing how they can be used to interact with various Google services. Most of the session is spent with participants in the Script Editor. While participants will be encouraged to actually type the sample scripts, templates of script snippets will be provided which could be copied/pasted/edited. Success will be immediately visible through the successful running of their code. Additionally, participants will brainstorm ideas for leveraging Google Apps Script to solve problems in their districts/schools.
- Google Apps Script: What is it & why use it?
- Google Sheet Macros
- Using the Script Editor
- Create, save, & run some scripts - This is where the bulk of the session is spent
- Developer Reference Guides
- Additional resources
- Closing Info
Google Apps Script - https://developers.google.com/apps-script
Apps Script Tutorials - https://developers.google.com/apps-script/articles/tutorials
Apps Script Blastoff course - https://www.benlcollins.com/apps-script-course/