- Explore Google Apps Script G Suite integration with Sheets, setup of Triggers and creating client side JavaScript
- Free tutorial
- Rating: 4.4 out of 54.4 (11 ratings)
- 3,168 students
- 36min of on-demand video
- Created by Laurence Svekis
- English
What you’ll learn
- How to apply Google Apps Script
- How to connect Google Apps Script with Sheets
- On Open function and triggers
Requirements
- JavaScript
- Prior Coding Experience
Description
Explore using Google Apps Script to connect to onOpen script functions, setup UI modal, add UI menu buttons and create Client side JavaScript. Apps Script OnOpen Trigger new Web URL Project G Suite
This course idea was a result of several students requests on this topic, I enjoy Google apps script and always happy to provide interesting solutions to coding challenges.
JavaScript and Google Apps Script are prerequisites to this course – DO NOT TAKE this course without prior coding experience.
- Setup a UI modal
- Setup Triggers to run functions on Open of Sheets
- Bound script to sheets
- Client Side HTML handling and request of value from Google Script
- Run JavaScript code on sheet open
- Setup of triggers.
Source Code is included.
Taught by an instructor with many years of web development experience. Google Developer Expert for G Suite. Ready to help you learn more about Google Apps Script. With fast and friendly support within the Q&A section.
Are you ready to build you own version of the app, make it even better, do more…. What are you waiting for see what you can do with Google Apps Script! Join NOW.
Who this course is for:
- Application developers
- JavaScript Coders
- Anyone who codes Google Apps Script
- Anyone with a G Suite account
Show less
Course content
2 sections • 17 lectures • 38m total lengthCollapse all sections
Introduction16 lectures • 38min
- Project Introduction Apps Script UI04:28
- Setup Google Apps Script Project.02:01
- Create PopUp HTML.04:36
- Source Code00:02
- Spreadsheet App UI button02:44
- Source Code00:05
- HTML and JavaScript in client Side02:59
- Source Code00:05
- On Failure to Run Callback.02:27
- Source Code00:15
- Open Page with JavaScript01:43
- Source Code00:09
- Setup Project Trigger.04:04
- Source Code00:08
- Project Code Review and Conclusion11:27
- Source code and Resources00:49
Google Apps Script Code Examples1 lecture • 1min
- Google Apps Script Coding Examples Guide00:14
