Skip to content
BENIBIX Learn

Google Apps Script

Development🔗 Integration & AutomationAutomation Platforms

Also known as Apps Script, Google Script

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

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.

Example

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

Why it matters

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

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 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.
Apps Script sits toward the code end, but needs no server.

Common mistake

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

Key takeaways

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