Google Apps Script Tutorial for Beginners

4.8
stars
20 ratings
Offered By
Coursera Project Network
In this Free Guided Tutorial, 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.

Showcase this hands-on experience in an interview

Clock2 hours
BeginnerBeginner-friendly
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 tutorial, 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 tutorial works best for learners who are based in the North America region. We’re currently working on providing the same experience in other regions.

Requirements

No background skills required.

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 Tutorials 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

Reviews

TOP REVIEWS FROM GOOGLE APPS SCRIPT TUTORIAL FOR BEGINNERS

View all reviews

Frequently asked questions

Frequently Asked Questions

More questions? Visit the Learner Help Center.