Getting Started With Google Apps Script

Offered By
Coursera Project Network
In this Guided Project, you will:

Open Google Sheets and set up a workbook.

Create and execute a custom function in Google App Script.

Test and finalize the program created in Google Apps Script that will send weekly updates.

Clock2 hours
BeginnerBeginner
CloudNo download needed
VideoSplit-screen video
Comment DotsEnglish
LaptopDesktop only

With an ever-increasing reliance on the productivity GSuite tools (like Google Docs and Google Sheets), there is a need more than ever to create efficiency where possible. By using Google Apps Script, users can create tools to automate tasks that could be monotonous and time-consuming. For example, a user can send emails from a Google Sheet or insert a Google Map into a Google Doc. Upon completing this project, learners will be able to create a custom Google Apps Script that will automate sending a weekly email update to a contact list. Note: This course works best for learners who are based in the North America region. We’re currently working on providing the same experience in other regions.

Skills you will develop

Google SheetsEmailGoogle Apps ScriptJavaScriptComputer Programming

Learn step-by-step

In a video that plays in a split-screen with your work area, your instructor will walk you through these steps:

  1. The learner will set up and sign into a free Google account.

  2. Open Google Sheets and set up a workbook.

  3. The learner will create and execute a simple function in Google App Script.

  4. The learner will create and execute a custom function in Google App Script.

  5. Test and finalize the program created in Google Apps Script that will send weekly updates.

How Guided Projects work

Your workspace is a cloud desktop right in your browser, no download required

In a split-screen video, your instructor guides you step-by-step

Frequently asked questions

Frequently Asked Questions

More questions? Visit the Learner Help Center.