Google is committed to advancing racial equity for Black communities. See how.

Codelabs: Apps Script Fundamentals

If you're new to Apps Script, you can learn the basics using our Fundamentals of Apps Script with Google Sheets codelab playlist.

This playlist consists of a set of sequential codelabs. Each codelab is a guided tutorial that gives you step-by-step instructions on how to build an example script application. If you need to take a break, you can pick up the codelab later, right where you left off.

The codelabs in this playlist focus on using Apps Script with Google Sheets. The Spreadsheet service is one of the largest and most popular built-in services in Apps Script, and this playlist will familiarize you with its content and use.

The playlist covers many Apps Script concepts, including the following:

  • Using the Apps Script in-browser editor.
  • Creating and editing Google Sheets macros.
  • Creating Google Sheets custom functions.
  • Importing data into Google Sheets.
  • Adding, editing, and formatting Google Sheets data with Apps Script.
  • Creating charts and exporting them to Google Slides.
  • Fetching data from third-party API services.
  • Creating menus and dialog windows in Google Sheets.

Before you start

You don't need any previous knowledge about Apps Script to complete this playlist. However, the playlist does assume you have some basic familiarity with Google Sheets and A1 notation.

It is also helpful to have some basic understanding of JavaScript, upon which Apps Script is based. If you're new to JavaScript, Codecademy offers a number of JavaScript courses. (Note: these courses weren't developed by Google.)

Every part of these codelabs are conducted inside your browser, so you don't need any special software to finish them.

Getting started

You can start the playlist with the links given below. Each codelab provides step-by-step instructions that guide you through the lesson. Once you finish a codelab, you can move on to the next one in the list. Start with the first codelab, "Fundamentals of Apps Script with Google Sheets #1: Macros & Custom Functions".

Here is the Apps Script Fundamentals playlist:

  1. Fundamentals of Apps Script with Google Sheets #1: Macros & Custom Functions
  2. Fundamentals of Apps Script with Google Sheets #2: Spreadsheets, Sheets, and Ranges
  3. Fundamentals of Apps Script with Google Sheets #3: Working with Data
  4. Fundamentals of Apps Script with Google Sheets #4: Data Formatting
  5. Fundamentals of Apps Script with Google Sheets #5: Chart and Present Data in Slides

What's next?

Once you've finished the playlist, you can continue to explore what Apps Script has to offer. There are many resources available to help you learn, depending on your interests:

Interest
Additional tutorial examples

You can try one of the available quickstarts:

You can also find other learning resources on the Apps Script samples page.

More details about Apps Script concepts The Apps Script guide documentation covers everything you need to know about Apps Script. Just expand and explore the links in the left navigation to learn about different topics!
More details about Apps Script services The Apps Script reference documentation describes each built-in Apps Script service in detail, usually including example code. The reference documentation also includes descriptions of Apps Script advanced services.
Building add-ons The Add-ons documentation includes an overview of concepts, samples, and other details that you can use to build and publish your own add-ons.