Google Apps Script is a scripting language used with various Google web-based apps such as Google Docs, Google Sheets, Google Forms, and Gmail. This course aims to teach you how to combine the functions of multiple Google services with external data sources to create custom apps. For instance, you will learn how to pull data from a Google Sheet and format it into a Google Doc using Google Apps Script. Understanding JavaScript, which underlies Google Apps Script, is essential for coding tasks confidently. The course covers JavaScript concepts and syntax to help you become proficient in using Google Apps Script.
Google Apps Script allows you to integrate Google services with external APIs, enabling the creation of new apps. You will explore the core functionality of Google services like Sheets, Forms, and Docs, as well as additional features such as Properties, Cache, UrlFetch, and HTML. By mastering JavaScript, you will gain the ability to code tasks for Google Apps Script effectively.
The course is led by Bruce McPherson, a Google Developer Expert (GDE) who is passionate about problem-solving using Google services and cloud-based APIs. With experience as a Chief Architect and CIO for companies like Motorola and Lucent, Bruce McPherson founded Pepada Consulting. He also hosts the Google Apps Script Community and JavaScript Community on Google+ and has authored the O'Reilly title "Going Gas: From VBA to Apps Script."
In summary, this course on Google Apps Script provides comprehensive instruction on utilizing its capabilities to create custom apps that integrate with various Google services and external APIs. By mastering JavaScript and understanding the underlying principles of Google Apps Script, you will be able to confidently code tasks for automating processes within these web-based apps.
