Google Apps Script for Sheets: Automate with Custom Scripts (basics)

Описание: In this video, you'll learn how to use Google Apps Script to automate tasks in Google Sheets — even if you're just getting started. Whether you're a JavaScript enthusiast or a beginner curious about adding custom functionality to spreadsheets, this step-by-step tutorial will guide you through the basics of Apps Script.

We’ll begin by exploring the Apps Script interface — including the Editor, Overview, Triggers, Executions, and Project Settings tabs — so you can understand how the platform is structured. You'll learn what a container-bound script is, how deployments work, and how to track script performance.

Next, we’ll build a simple yet powerful automation: a custom function that reads a list of sheet names from column A and creates new sheets automatically.

Timeline:
0:00 Introduction to Apps Script
1:24 Opening the Apps Script Interface
1:55 Overview Tab & Deployments
4:42 Editor Tab & Writing Code
6:25 Triggers, Executions & Settings
7:06 Creating Sheets from a List
9:47 Adding a Custom Menu
10:24 Authorizing and Running Script
11:27 Script Completed Successfully
11:43 Final