Custom menu
onOpen adds a Better Sheets menu with Export CSV and Email Report actions your team clicks instead of remembering shortcuts.
What is Google Apps Script in Google Sheets?
Apps Script is Google's JavaScript platform for automating Sheets and other Workspace apps. From a spreadsheet you can open Extensions > Apps Script to write code that reads cells, sends email, builds menus, and runs on triggers. It goes beyond formulas when you need custom workflows tied to your file.
When to use it
Use Apps Script when formulas, filters, and pivot tables cannot deliver menus, scheduled jobs, external APIs, or multi-step approvals inside one workbook.
When to skip it
Stay in the grid when QUERY, ARRAYFORMULA, or built-in features solve the task. Scripting adds permissions, quotas, and maintenance every teammate must trust.
How it works
-
1
Open Extensions > Apps Script from the spreadsheet to create a bound script project.
-
2
Write functions in JavaScript using SpreadsheetApp to read and write ranges.
-
3
Run once from the editor or bind to simple triggers like onOpen and onEdit.
-
4
Add installable triggers for schedules, form submits, or broader permissions.
-
5
Authorize the script the first time it touches Gmail, UrlFetchApp, or other services.
-
6
Use the Apps Script hub for deeper tutorials, generators, and deployment patterns.
Examples in Google Sheets
Edit stamp
onEdit writes a last-updated timestamp in column F when someone changes status in column D.
Weekly digest
A time-driven trigger reads new rows each Monday and sends a MailApp summary to managers.
Build this without starting from a blank cell
Use a Better Sheets tool for Google Apps Script, then watch a walkthrough when you want the full pattern.
Better Sheets resources
Common mistakes
- Scripting a one-line task ARRAYFORMULA already handles, adding failure points for no gain.
- Long API calls inside onEdit, which slows every keystroke for editors.
- Skipping authorization prompts on shared files, so teammates think the script is broken.
- Hard-coding sheet names that change after clients rename tabs.
- Treating this glossary page as the full Apps Script curriculum instead of the linked hub.
Frequently asked questions
- Apps Script vs formulas?
- Formulas recalc in cells. Apps Script runs JavaScript procedures for menus, triggers, and services formulas cannot call.
- Where do I write code?
- Extensions > Apps Script opens the editor bound to the active spreadsheet file.
- Apps Script vs macros?
- Macros record UI steps into Apps Script. Hand-written scripts scale better for logic and APIs.
- Does Apps Script cost extra?
- It is included with Google Workspace subject to daily quotas on runtime and email sends.
- Can viewers run my script?
- Viewers cannot open the editor. They may still trigger onOpen menus if you expose buttons editors can use.
- Apps Script vs add-ons?
- Add-ons package scripts for distribution. Bound project code lives inside one spreadsheet file.
- What language is Apps Script?
- Modern Apps Script uses JavaScript syntax with Google service objects like SpreadsheetApp.
- Where should I learn more?
- Start here for the concept, then follow the Apps Script hub link for tutorials, triggers, and deployments.
Related Tutorials
Watch how Google Apps Script works
From Sheet to Script And Back Again - Learn to Code In Google Sheets Part 3
The First Thing I Do When Starting a Google Sheet
MAKE Your Google Sheets Add-on WORK
Automate Google Sheets With Zero Experience
Related blog posts
Guides that explain Google Apps Script in more depth.
What's Better Than Google Sheets?
Nothing is better than Google Sheets. You just need to learn more about the unlimited power of Google Sheets. Functions, Formulas, Apps Script and more.
Read post →Learn Google Sheets Apps Script
Learning Google Sheets coding and Apps Script can have several outcomes and results. Become more productive, more of an asset to your company. No matter if you work there or if you own the company.
Read post →Get Sheet Done: Start Your Business in Sheets
4 Ways Google Sheets Can Help You Start Up Create a list Curate Links Track Something Write Code
Read post →Related glossary terms
Script Editor
The Script Editor is the Apps Script workspace inside your spreadsheet where you write JavaScript that talks to Sheets, Gmail, and other Google services. You open it from Extensions > Apps Script. Every function you save can be run manually, bound to a trigger, or linked from a custom menu.
Read guide →Apps Script triggers
Triggers tell Apps Script when to run a function: on edit, on open, on a schedule, or when a form is submitted. Simple triggers use reserved names like onEdit. Installable triggers are created in the Apps Script Triggers page and can do more, including running as a specific user or on a timer.
Read guide →Google Sheets automation
Automation means work happens without repeating the same clicks every day: imports update, emails send, rows move, and dashboards refresh. In Sheets, automation usually stacks built-in features, Apps Script, and sometimes the Sheets API or add-ons. Start with the lightest tool that still solves the job.
Read guide →SpreadsheetApp
SpreadsheetApp is the main Apps Script service for talking to Google Sheets. It lets your script open the active spreadsheet, grab sheets by name, read cells, write values, and change formatting. Almost every Sheets automation starts with SpreadsheetApp.getActiveSpreadsheet().
Read guide →Done reading about Google Apps Script?
Membership unlocks 636+ tutorials, unlimited generators, and every template. Practical lessons. Zero fluff.
Need this once
Jump to a free tool or a single tutorial for this topic.
Learning Sheets for real
Unlock the full library, generators, and templates with membership.