Start Coding with Google Apps Script you own this product

Use Google Apps Script Code to Interact with Google Workspace Apps
Laurence Svekis
  • Course duration: 9h 2m
Included with a Manning Online subscription
watch now

pro $24.99 per month

  • access to all Manning books, MEAPs, liveVideos, liveProjects, and audiobooks!
  • choose one free eBook per month to keep
  • exclusive 50% discount on all purchases

lite $19.99 per month

  • access to all Manning books, including MEAPs!

team

5, 10 or 20 seats+ for your team - learn more

Look inside

Google Apps Script is a coding language based on JavaScript that runs in the cloud. You can do really amazing things with Apps Script, using just a few lines of code. It allows you to supercharge your Google Workspace apps, save time, and do a lot more. This course is designed as follows:

  • Google Apps Script is by far one of the best coding languages to get started with, because it allows you to access the power of all the Google Services that simply work so incredibly well within the script.
  • Includes three PDFs loaded with exercises and source code, with coding tips for learning Google Apps Script!
  • Each lesson is designed to demonstrate a particular aspect of Google Apps Script coding, with exercises to challenge you!
  • The lessons are designed based on common questions and coding challenges that students have asked the instructor.

There is a lot that can be done with apps script, including publishing web apps; creating custom functions in Sheets; adding menus and dialogs to Docs, Sheets, and Forms; interacting with other Google Services like Maps, Drive, Gmail, and Calendar; and much more. You can also build and publish add-ons to the Google Workspace Marketplace.

You will need a Google Account in order to write Google Apps Script. Google Apps Script can be created directly within a web browser; the IDE for writing the code is online, and code is saved within your Google Drive.

Apps Script code is written in modern JavaScript. In addition, there are built-in libraries that can be accessed within the Google Workspace products such as Sheets, Docs, Gmail, Calendar, Drive, and more.

 

Distributed by Manning Publications

 

This course was created independently by Laurence Svekis and is distributed by Manning through our exclusive liveVideo platform.

about the subject

Google Apps Script allows you to interact with the Google Workspace products and create customized functionality within those products. To get started with Google Apps Script and begin creating coding apps, all you need is an internet connection and a Google account. Google Apps Script is based on JavaScript so there are many resources and code samples available for your use. Start coding and create amazing applications that can do A LOT!

prerequisites

  • Prior coding experience with any language, preferably JavaScript.

what you will learn

⦁ Explore how to open the script editor, create projects, write code, and modify code.

⦁ Learn how to interact with Google Services using Apps Script and bring your Google Workspace to the next level.

⦁ Expand your Google Workspace knowledge with exercises and challenges.

⦁ Deploy a web app—a URL that runs front-end code and can be shared with the world.

⦁ Use Google Workspace Services to create a bound script that powers up your Workspace.

⦁ Create bound applications that allow you to use the Google Workspace container and create customized interactions.

⦁ Learn what you can do with apps scripts by creating standalone applications that connect to the Google Workspace and Google Services.

⦁ Create a WebApp URL for sharing and deploying scripts with Google Apps Script.

⦁ Create custom macros, adding advanced functions to your spreadsheet with Google Apps Script.

⦁ Learn to connect your code to a Google Workspace document.

⦁ Get data from your spreadsheet and use it within your code with script.

⦁ Learn about the UI menu and how to add custom functions for users within spreadsheets.

⦁ Interact with Google Workspace services and see examples using classes in Workspace services and how to access class methods.

about the instructor

Laurence Svekis is an experienced web application developer who worked on multiple enterprise level applications, hundreds of websites and business solutions, and many unique and innovative web applications. He created his first computer application in 1990 and first website in 1998. Laurence has been providing web development courses and digital marketing strategy courses since 2002, teaching countless learners how to bring amazing things to life online.
what's a liveVideo?
  • Quality lessons from expert programmers.
  • Rich, interactive transcripts for navigation.
  • Exercise driven learning.
Find out more

related titles

choose your plan

pro

monthly
annual
$24.99
$249.99
only $20.83 per month
  • access to all Manning books, MEAPs, liveVideos, liveProjects, and audiobooks!
  • choose another free product every time you renew
  • choose twelve free products per year
  • exclusive 50% discount on all purchases
  • Start Coding with Google Apps Script liveVideo for free

team

monthly
annual
$49.99
$499.99
only $41.67 per month
  • five seats for your team
  • access to all Manning books, MEAPs, liveVideos, liveProjects, and audiobooks!
  • choose another free product every time you renew
  • choose twelve free products per year
  • exclusive 50% discount on all purchases
  • Start Coding with Google Apps Script liveVideo for free