Share Description
In this course, you will learn :
- Appply Google Apps Script to create projects.
- Build SpreadsheetApp and CalendarApp applciations.
- Explore using JavaScript for client side interaction with Google Script.
- Develop and deploy web app with Google Script.
- Add interactive functions into Google Spreadsheet.
Syllabus :
1. Introduction to using Google Apps Script and the project that will be built2 lectures • 15min
- Introduction to Google Calendar Script Project
- Preview04:02
- Introduction and setup of Google Script
- 10:51
2. Interactive Calendar search and event creating application - spreadsheet tracker
- CalendarApp Setup - Google Apps Script Course
- Google Script Source Code
- Add a sideBar and Dialog window - Google Apps Script Course
- HTML service Method setup template for dialog
- Code.gs Google Script Source
- CalendarApp Methods - Google Apps Script
- New Event Form HTML - using html templates
- JavaScript Form Submit Data
- Google Script Run client side to server side
- Create Calendar Event from Form
- Spreadsheet Tweaks for happy users - Google Apps Script
- Create Event Checker - adding calendar events
- Client Side to Server Side data
- Sheet Maker SpreadsheetApp working with Sheets
- Get Event Data for Sheet ready data to use and apply
- Search Title Update and add events to Spreadsheet
- Creating your WebApp Option to add a URL
- Google App Code Review - Project Overview
