# Google Apps Script

> Code that runs on Google's servers. It works with Gmail, Sheets and Docs.

**Field:** Software Development  
**Category:** Integration & Automation  
**Also known as:** Apps Script, Google Script

## Think of it like

Think of it like a helper who lives in your Google files. You leave it a note, and it does the chores.

## Definition

Google Apps Script lets you write JavaScript that runs on Google's servers. It can work with Gmail, Sheets, Docs, Drive and Calendar. You write the script in a browser editor, and it is saved to your Drive. A script can run on a timer, when a sheet changes, or from a menu you add. It is code, but you never set up a server.

## Example

Lucy writes a short Apps Script for her sheet. Every morning it emails her the rows marked late.

## Example code

```javascript
function emailLateRows() {
  const rows = SpreadsheetApp.getActiveSheet().getDataRange().getValues();
  const late = rows.filter(r => r[2] === "late");
  MailApp.sendEmail("lucy@example.com", "Late rows", late.join("\n"));
}
```

The script reads the sheet, keeps the late rows and emails them.

## Why it matters

It can do more in Google apps than menus can. And there is no server to run.

## Common mistake

Giving a copied script full access without reading it. It can read and send your email.

## Three principles

- **JavaScript.** You write normal JavaScript.
- **No server.** It runs on Google's machines.
- **Lives in Drive.** Scripts sit beside your files.

## Related terms

- [JavaScript](https://learn.benibix.com/term/development/javascript)
- [Low-Code Development](https://learn.benibix.com/term/development/low-code)
- [Workflow Automation](https://learn.benibix.com/term/development/workflow-automation)
- [Automation Trigger](https://learn.benibix.com/term/development/automation-trigger)

![A scale from left to right with three boxes. No-code: drag blocks and fill in forms, anyone can build. Low-code, lit up: blocks plus a little code where blocks run out. Full code: write every line, any shape is possible. An arrow under the scale says more code means more control and more skill needed.](https://learn.benibix.com/diagrams/dev3-code-levels.svg)

---

Source: https://learn.benibix.com/term/development/google-apps-script
Author: Behnia Zarei (a developer in Vienna, Austria, who builds and teaches data, AI and business intelligence at BENIBIX)
Publisher: BENIBIX Learn (https://learn.benibix.com/)
Last updated: 2026-11-17
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
