Google Apps Script fundamentals codelabs overview

  • The Fundamentals of Apps Script with Google Sheets codelab playlist teaches the basics of Apps Script through guided tutorials using Google Sheets.

  • This playlist focuses on using the Spreadsheet service, one of the most popular built-in services in Apps Script.

  • The codelabs cover various Apps Script concepts, including using the editor, creating macros and custom functions, importing and formatting data, and more.

  • No prior Apps Script knowledge is required, but basic familiarity with Google Sheets and A1 notation is assumed, and a basic understanding of JavaScript is helpful.

  • The entire playlist is completed in your browser and should be followed in the provided order.

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 Sheets. The Spreadsheet service is one of the largest and most popular built-in services in Apps Script, and this playlist familiarizes 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 Sheets macros.
  • Creating Sheets custom functions.
  • Importing data into Sheets.
  • Adding, editing, and formatting 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 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 Sheets and A1 notation.

It's also helpful to have a basic understanding of JavaScript, upon which Apps Script is based. If you're new to JavaScript, Codecademy offers several JavaScript courses. (Note: Google did not develop these courses.)

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

Getting started

Follow the steps in each codelab to learn the fundamentals of Apps Script.

Here's the Apps Script Fundamentals playlist:

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