Google Apps Script CalendarApp and SpreadsheetApp Project

Name: Google Apps Script CalendarApp and SpreadsheetApp Project
Rating: 4.3 (54 reviews)

Create interactive application - connect Google Spreadsheet to track Calendar events and create Calendar events

Created byLaurence Svekis

Last updated 11/2024

English

What you'll 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

Course content

3 sections • 33 lectures • 1h 47m total length

Introduction to Google Calendar Script Project4:02
Introduction and setup of Google Script10:51

CalendarApp Setup - Google Apps Script Course5:51
Set up a bound Google Apps Script in a spreadsheet, build a custom UI with onOpen and getUi, and add menu items like add event and create sheet for calendar.
Google Script Source Code0:04
Add a sideBar and Dialog window - Google Apps Script Course3:00
Open a side bar and dialog in Google Apps Script to run functions, pass template and title parameters, and render templates like new event and form input in the sidebar.
Source Code Google Script0:05
HTML service Method setup template for dialog9:10
Learn to use the Google Apps Script HTML service to render dynamic pages, create and display templates from files, and switch between dialog and sidebar with client-server communication.
Code.gs Google Script Source0:11
CalendarApp Methods - Google Apps Script3:02
Learn to use the calendar app class in Google Apps Script to access the default calendar id and support multiple calendars, while connecting calendar and spreadsheet apps with permissions.
Source Code Google Script0:07
New Event Form HTML - using html templates8:43
Create a client-side new event form using HTML templates, featuring title, description, start and end times, and a calendar id, with default values and ISO date strings for easy prefill.
Source Code HTML0:35
JavaScript Form Submit Data5:16
Submit form data with JavaScript by selecting all inputs, building a holder object, and looping to capture names and values for server-side submission and upcoming Google script integration.
Google Script Run client side to server side3:20
Connect client side to server side using Google Apps Script run to pass form data, handle success, and create calendar events from the input form.
Source Code Google Script0:34
Create Calendar Event from Form5:51
Create calendar events from a spreadsheet form by selecting the calendar by id and using the create event method with title, start date/time, and description options.
Source Code Google Script0:14
Spreadsheet Tweaks for happy users - Google Apps Script2:15
Source Code Google Script0:13
Create Event Checker - adding calendar events4:33
Create a form input to search calendar events by calendar id, start and end dates, and keyword terms in titles, with a default today and 56 days ahead.
Client Side to Server Side data3:19
Link client-side form data to the server-side via a holder object, implement an event checker and get events function, fetch matching events, and display a toast while preparing a sheet.
Source Code Google Script0:18
Sheet Maker SpreadsheetApp working with Sheets5:11
Create a new spreadsheet with Google Apps Script, generate a unique sheet name, check for existing sheets, insert a new sheet, and append calendar event data with headers.
Source Code Google Script0:24
Get Event Data for Sheet ready data to use and apply7:37
Retrieve events from the calendar app by id, build a temporary events array, and write date objects, titles, locations, start times, descriptions, and guest lists to a Google Sheet.
Source Code Google Script0:32
Search Title Update and add events to Spreadsheet3:34
Source Code Google Script0:37
Creating your WebApp Option to add a URL4:24
Google App Code Review - Project Overview12:54
Explore how to build and manage calendar events with Google Apps Script, using a spreadsheet UI to add, search, and output entries across calendars with templates and dialogs.
Source Code Google Script0:40

Requirements

Google Account
Internet Access
JavaScript knowledge
HTML and CSS experience

Description

Explore how you can use Google Apps Script to develop interactive applications that can be used to improve business workflow and extend the functionality of the google suite of products. This course covers building a project which adds the ability within a Google Spreadsheet to search the users Google Calendar and track results within the spreadsheet. In Addition create an option to add items into the users calendar from the spreadsheet menu as well as from a web app url form.

JavaScript is a prerequisite to Google Script as its based on JavaScript coding. Many of the methods and code from JavaScript can be used to write Google Script. If you know JavaScript you know Google Script!!!!

Google provides classes and methods that can be applied within the code to connect various Google products together to create some REALLY REALLY amazing functionality that can save time. Power up your web development using the POWER of GOOGLE

So many amazing things can be done - if you have never used Google Script then prepare to be AMAZED - best of all its easy and you can do SOOOO MUCH with just a few lines of code.

Course Contents -

CalendarApp - selecting events
CalendarApp - creating events into your calendar
SpreadsheetApp - updating UI adding buttons
SpreadsheetApp - running functions from UI tool menu
SpreadsheetApp - Creating new sheet
SpreadsheetApp - Adding rows and content to spreadsheet
HTMLService -Use of html templates files for project output and popup windows
SpreadsheetApp - UI dialog window, toast, sidebar
Web App with URL to connect to Google Script methods
Sending data from client side to server side - return and response handling
JavaScript for checking if values exist in a string
JavaScript HTML and CSS for template used as dialog
Sending form data to Google Script to handle

Please note that this is a project based course covering step by step how to build and construct the project - source code is also included so you can try the code yourself.

Step by step learning with all steps included.

Beginner JavaScript knowledge is required. Also HTML and CSS knowledge is essential.

Along with friendly support in the Q&A to help you learn and answer any questions you may have.

Try it now you have nothing to lose, comes with a 30 day money back guarantee.

Create your own Google Script see what amazing things you can build with it.

Who this course is for:

JavaScript developers
Google Apps Script Coders
Anyone who wants to learn Google Script
Web developers
Application creators
Business process improvement developers

Google Apps Script CalendarApp and SpreadsheetApp Project

What you'll learn

Explore related topics

Course content

Introduction to using Google Apps Script and the project that will be built2 lectures • 15min

Interactive Calendar search and event creating application - spreadsheet tracker29 lectures • 1hr 33min

Resources and bonus content2 lectures • 1min

Requirements

Description

Who this course is for: