Google Calendar Live feed to your website Google Apps Script
5.0 (6 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,895 students enrolled

Google Calendar Live feed to your website Google Apps Script

Explore how you can create a live feed of your Google Calendar entries using Google Apps Script - Add data Spreadsheets
5.0 (6 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,895 students enrolled
Created by Laurence Svekis
Last updated 11/2019
English
English [Auto-generated]
Current price: $129.99 Original price: $199.99 Discount: 35% off
12 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1.5 hours on-demand video
  • 17 articles
  • 2 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • How to apply Google Apps Script for mini projects
  • Useful code to start writing and explore what can be done with Google Apps Script
  • Google Calendar data as spreadsheet data and as JSON feed
Course content
Expand all 36 lectures 01:40:04
+ Connecting Google Apps Script with Spreadsheet Calendar and creating a web app.
28 lectures 01:18:07
Add Content to Sheet
02:06
Source Code
00:02
Calendar Service
04:21
Source Code
00:05
Populate Calendar
07:05
Source Code
00:08
List Calendar Events.
07:48
Source Code
00:09
List Events Function.
04:25
Source Code
00:17
Add Events to Spreadsheet
04:24
Source Code
00:11
Create a Trigger.
03:41
Source Code
00:01
Spreadsheet as JSON
04:48
Source Code
00:00
JavaScript Fetch JSON
10:43
Source Code
00:10
Spreadsheet on WebPage.
03:58
Source Code
00:14
Google Script WebApp
08:24
List Events in Web App.
02:21
Source Code
00:02
Get JSON Data
03:37
Source Code
00:18
Google Calendar Events
06:11
Delete Events
02:28
Source Code
00:06
Requirements
  • JavaScript, HTML and CSS
  • Prior programming knowledge
  • Solid understanding of JavaScript
Description

Perfect course to learn more about how to apply Google Apps Script to help automate and use Google Suite as a source for data.  No Databases just Google Script - output your Calendar to a JSON feed.

BONUS - Free 20+ page downloadable course guide with resources and source code.

Step by step learning!

Please note that JavaScript experience is essential to this course, Google Apps Script is JavaScript cloud based Language which uses pre-built methods to provide really powerful functionality. If you can write JavaScript Apps script is really easy to start using right away ... because its JavaScript in the cloud.

Complete course demonstrate how to write Google Apps Script code, how to create and access the cloud based IDE.   Course scope is to create a starter project and illustrate how Google Script can be used to create applications.

Course covers

  • How to create stand alone script and bound script

  • How to create Documents with Google Apps Script

  • Using Logger log for debugging

  • Bound script getting active spreadsheet as a usable object

  • Adding data to spreadsheet rows.

  • Adding events to Google Calendar

  • Listing events updating timezone from events

  • Adding event data to a spreadsheet

  • Creating trigger to automate scripts

  • Outputting Spreadsheet as JSON

  • Using AJAX to request spreadsheet data and pulling it into client side page

  • Setting up Google Script WebApp

  • Deploy WebApp from IDE and select dev vs exec versions

  • Using doGet to output JSON content

  • Sending Calendar data as JSON data

  • AJAX request to get webapp api data

Source code is included to try the code for yourself

Create a starter project which you can use extend and do some really amazing things with.

Course is taught by a web developer with over 18 years experience and 4+ years working with Google Apps Script.

Fast and friendly support is provided in the Q&A section.

See what you can do - you have nothing to lose make your own Google Apps Script project today.

Who this course is for:
  • Web developers
  • Application developers
  • Anyone who wants to learn more about Google Apps Script
  • JavaScript coders
  • Anyone who wants to automate Google Suite