
Create Google script solutions that pull calendar events and update calendars. Export to a spreadsheet, trigger hourly automation, and serve json via Ajax to embed in web pages.
Explore how Google Apps Script lets you read and write Google Calendar content and automate other apps like documents, spreadsheets, and Gmail from a cloud-based online editor.
Discover bound scripts that attach to Google Sheets and other documents, use Logger for debugging, and send emails with the email app, within the script editor.
Apply the spreadsheet service in Google Apps Script by binding to a spreadsheet, obtaining the active spreadsheet, logging its id, granting permissions, and creating a new spreadsheet called finances.
Write content to a spreadsheet with Google Apps Script by selecting a sheet and appending rows as arrays. Run the function to add new lines and see content appear.
Explore the calendar service in Google Apps Script to create and add events to the default calendar, manage permissions, and retrieve event ids.
Learn to populate your Google Calendar with multiple randomly generated events using Google Apps Script, including start and end times, for loops, and exporting a JSON file for web integration.
List calendar events within a time range using Google Apps Script, manage time zones, and extract event details such as title, start and end times, and location.
Update the list events function to pull start time, end time, date, title, id, location, and description, format the results, and output to a feed or spreadsheet.
Learn to add calendar events to a bound spreadsheet by selecting the active spreadsheet, using a feed sheet, clearing data, building event arrays, and appending rows via a trigger.
Create and manage time-driven triggers in Google Apps Script to run hourly, pulling calendar events into a spreadsheet and enabling a live feed to your website via updated data.
Publish a Google spreadsheet to the web to obtain a JSON data feed, using the spreadsheet ID and sheet number, and fetch updates into a web app.
Learn how to fetch json from a Google spreadsheet using JavaScript with fetch, parse the API response, and reconstruct readable data objects for display on a web page.
Output spreadsheet data to the web page by looping the data array and creating divs with title, start, end, and date for display.
Learn to build a Google script web app that outputs calendar data as json via doGet and content service, enabling fetch or Ajax integration with your website.
Output Google Calendar events to your spreadsheet by updating the list events function to return content and render a live web app feed.
Retrieve live calendar events via a Google Apps Script web app using fetch to obtain JSON data, then parse and sort by date for real-time display on your page.
Extract Google Calendar events with Apps Script, format them for a spreadsheet or JSON output, and publish live data via a web app and triggers.
Create a Google Apps Script function to delete calendar events within a 14-day window by looping through events and removing those that match your criteria, including an optional title filter.
Learn how to search Google Sheets with Google Apps Script, either across all data or a chosen range, using a finder prototype to return matching rows.
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.