🔗Google Apps Script
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
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"));
}Common mistake
Key takeaways
- 1JavaScript. You write normal JavaScript.
- 2No server. It runs on Google's machines.
- 3Lives in Drive. Scripts sit beside your files.