Skip to Content
Google Apps Script for Beginners
on-demand course

Google Apps Script for Beginners

with Bruce Mcpherson
September 2016
Intermediate to advanced
7h 29m
English
Infinite Skills

Overview

Google Apps Script is a scripting language used in conjunction with Google web-based applications (Google Docs, Google Sheets, Google Forms, Gmail, etc.) and external APIs. In this course, you’ll see how Google Apps Script can integrate the functions of multiple Google services with an externally located data source to create a new custom app. For example, you’ll see how Google Apps Script pulled data from a Google Sheet and an external source, and then combined and formatted the data into a Google Doc.

The key to using Google Apps Script is understanding its underlying language – JavaScript. The course teaches you enough of the concepts and syntax of JavaScript that you’ll come away with the ability to confidently code Google Apps Script tasks on your own.

  • See how Google Apps Scripts combine Google services and external APIs to create new apps
  • Review the functionality of core Google services like Sheets, Forms, Docs, and Gmail
  • Understand advanced Google services like Cache, Properties, UrlFetch, and HTML
  • Learn the basics of JavaScript – the language of Google Apps Script
  • Become confident in your ability to use JavaScript to code Google Apps Script tasks
  • Gain the ability to create Google Apps Script based applications on your own
Bruce McPherson is a GDE (Google Developer Expert) who is passionate about helping problem solvers everywhere, to combine Google services and cloud based APIs into innovative solutions. A former CIO and Chief Architect for companies like Motorola and Lucent, Bruce runs Pepada Consulting, hosts the Google Apps Script and JavaScript Community on Google+, and is author of the O'Reilly titles "Going Gas: from VBA to Apps Script" and "Google Apps Script for Developers".
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Watch now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

Google Apps Script for Beginners

Google Apps Script for Beginners

Serge Gabet
Learning Google Apps Script

Learning Google Apps Script

Ramalingam Ganapathy

Publisher Resources

ISBN: 9781491967416