Module 02 / 15

Entering the Workshop

Every master builder needs a workshop. Today, we find yours.

In this module, we will learn how to find the "Hidden Door" inside Google Sheets that leads to the Apps Script Editor.

What You Will Learn
  • How to launch the Script Editor from a Google Sheet.
  • Understanding the "Save", "Run", and "Log" buttons.
  • How to authorize your script (The Secret Handshake).
Who Is This For?

This is for everyone who has ever wondered, "What does that Extensions button do?" If you have a Google account, you already have the key to this workshop!

Real Life Connection

Imagine you are playing Minecraft. You can play the game normally, OR you can open the command console to change the weather or give yourself diamonds.

The Script Editor is the Command Console for your Google life. It lets you go beyond the normal "buttons" and create your own rules.

The Editor: Your Control Room

The Script Editor is just a website where you write code. It has three main parts:

  1. The File List: On the left (usually named Code.gs).
  2. The Code Area: The big space in the middle where you type.
  3. The Toolbar: At the top with the Save and Run buttons.
The "Opening" Workflow
1. Open Sheets
➜
2. Click Extensions
➜
3. Click Apps Script
➜
4. Code Appears!
Your Very First Script

Once the editor opens, you will see some text like function myFunction() { }. We are going to replace it with something cooler.

Step 1: Select all the text and delete it.
Step 2: Type the code below exactly as you see it.

function testDrive() {
  // This is our first real test
  Logger.log("Engine Started! 🚀");
}
Copy and Paste This:
function testDrive() { // We are telling Google to log a message Logger.log("Hello from the Editor!"); }
The "Permission" Moment

This is where most beginners get stuck, but not you! When you click Run, Google will ask for permission.

Follow these steps:
1. Click Review Permissions.
2. Choose your Google Account.
3. If it says "Google hasn't verified this app," click Advanced (bottom left).
4. Click Go to [Your Project Name] (unsafe). (Don't worry, it's safe because YOU wrote it!)
5. Click Allow.

Now, look at the bottom. You will see: Hello from the Editor!

Wait! It didn't work!
Help! I see an error message!

"Function not found": Make sure you clicked the "Save" icon (the floppy disk) before clicking Run.

"Missing ;": Check if you forgot to close the brackets } or the parentheses ).

Your Challenge

Try changing the text inside the Logger.log to your favorite food. Save it, run it, and check the log!

Real World Use

System Administrators use this "First Run" process to set up massive automated systems that handle school enrollments or hospital records. Even the biggest apps started with a single Logger.log!

Module Summary

You’ve done it! You found the workshop, opened the console, and survived the permissions popup. You are now officially a Script Developer.

Status: Editor Master 🛠️ | Level: Junior Builder 🧱

Type NEXT to unlock the next module 🚀