Google Apps Script - CalendarApp & SpreadsheetApp Project

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

Show more