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](https://developers.google.com/apps-script/reference/spreadsheet)
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](https://developers.google.com/sheets/api/guides/concepts#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](https://www.codecademy.com/catalog/language/javascript).
(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.

> [!NOTE]
> **Note:** Make sure to complete the codelabs in order. As you progress through the playlist, you'll use what you learn in each codelab to complete the ones that follow.

Here's the **Apps Script Fundamentals** playlist:

1. [Fundamentals of Apps Script with Sheets #1: Macros \& Custom Functions](https://codelabs.developers.google.com/codelabs/apps-script-fundamentals-1)
2. [Fundamentals of Apps Script with Sheets #2: Spreadsheets, Sheets, and Ranges](https://codelabs.developers.google.com/codelabs/apps-script-fundamentals-2)
3. [Fundamentals of Apps Script with Sheets #3: Working with Data](https://codelabs.developers.google.com/codelabs/apps-script-fundamentals-3)
4. [Fundamentals of Apps Script with Sheets #4: Data Formatting](https://codelabs.developers.google.com/codelabs/apps-script-fundamentals-4)
5. [Fundamentals of Apps Script with Sheets #5: Chart and Present Data in Slides](https://codelabs.developers.google.com/codelabs/apps-script-fundamentals-5)