Apps Script in Google Sheets: Where to Find It

In Google Sheets on a computer, open your spreadsheet and choose Extensions > Apps Script. The Apps Script editor opens in a browser tab, where you can create or edit code connected to that spreadsheet.

Find Apps Script in the Sheets menu

The current menu path is in the top menu bar of the Google Sheets web interface. Open the sheet you want to work with, then select Extensions and choose Apps Script. The editor normally opens in a separate browser tab, while the spreadsheet remains open in its original tab. If your browser blocks pop-ups or new tabs, check whether it prevented the editor from opening.

For a first visit, the editor may show an automatically created project associated with the spreadsheet. It can have a default project name and a starter function. You can rename the project and replace or add code there. If you already made a script for that file, the same menu path takes you to its project.

Open the spreadsheet in Google Sheets using a desktop web browser.
Choose Extensions > Apps Script.
Wait for the Apps Script editor to open, then check the project name and code before making changes.

Some older instructions say to use Tools > Script editor. That is a legacy menu path, not the current route in Google Sheets. If you are following an older tutorial, look under Extensions instead.

What opens in the Apps Script editor

Apps Script is Google’s browser-based environment for writing small programs and automations that work with Google services. Its code is based on JavaScript, with Google-provided services for tasks such as reading and changing spreadsheet cells, creating menus, and working with other Google Workspace products.

The editor has a code area for files in the project, controls for saving and running functions, and tools for viewing execution details. The interface can change over time, but the basic workflow remains: edit code, save the project, select a function, and run it when appropriate. The editor is separate from the spreadsheet grid; opening it does not itself change any cell values.

A script can be as simple as a function that writes a greeting into a cell, or it can automate a multi-step process. For example, a script might add a custom menu to a sheet, format a newly added row, or copy selected information to another spreadsheet. The script only performs actions specified by its code and permitted by the account’s access and authorization.

How spreadsheet scripts are connected

When you open Apps Script from a spreadsheet, you are generally working with a container-bound project: a script associated with that particular Google Sheets file. This is convenient when the code is meant to serve one spreadsheet. It can refer to its parent file and, with suitable code and permissions, respond to spreadsheet events or add a custom menu to that file.

A standalone Apps Script project is not attached to a particular spreadsheet. You can create one from the Apps Script home page at script.google.com. A standalone project can still work with a spreadsheet if its code opens or otherwise accesses the file and the account has permission. Starting at script.google.com is useful for a general automation, but it is not the fastest way to locate the script already linked to a specific sheet.

To return to a spreadsheet’s bound project, go back to that spreadsheet and use Extensions > Apps Script again. Opening a separate project from the Apps Script home page does not automatically attach it to the currently open sheet.

What you can do with it

Apps Script is useful when a spreadsheet needs repeatable behavior that ordinary formulas or built-in features do not provide. A script can read ranges, update values, format cells, and add interface elements. It can also interact with other Google services when the code and permissions allow. It is not required for everyday spreadsheet work, and many common tasks are easier to manage with formulas, filters, conditional formatting, or built-in automation features.

Custom actions: add a menu such as Create report that runs a function for the spreadsheet.
Repeated updates: apply a consistent format or move selected data using a defined process.
Event-based behavior: run code in response to supported events, such as an edit, when an appropriate trigger is set up.
Connections: work with other Google services where the script’s design and the user’s permissions support it.

For instance, a team could use a script to create a timestamped summary from a sheet after a user chooses a custom menu item. The script would need to identify the right source cells, handle blank or unexpected values, and write to an intended destination. A small example can be useful, but real workbooks deserve testing on a copy before code changes important data.

Access, sharing, and authorization

You generally need permission to edit a spreadsheet to work with its attached script. A person with view-only or comment-only access should ask the owner for the required access rather than expecting to edit the project through the menu. In organizations, a Google Workspace administrator may also restrict Apps Script or related services, so an unavailable option can be an account policy issue rather than a problem with the sheet.

Opening, saving, or running a script are separate actions. When code tries to use Google services or access data, Google may ask the user to authorize the requested permissions. Read the authorization prompt and make sure the project is one you trust before granting access. A script may be able to make changes or access information within the permissions granted to its user, so do not run unfamiliar code just because it is attached to a spreadsheet you received.

Sharing a spreadsheet does not make every script safe or guarantee that every collaborator can run it successfully. Users may have different access to files and services, and some trigger types have distinct execution behavior. If a script is important to a team workflow, its owner should explain what it does, who maintains it, and which permissions or triggers it relies on.

Can you find it in the mobile app?

The Google Sheets apps for Android and iOS do not provide the full Apps Script editor and the same Extensions menu available in Sheets on the web. You can view and edit spreadsheet data on a phone, but for creating or maintaining script code, use a computer and open the file in a desktop web browser.

Although a mobile browser may offer a desktop-site option, the editor is designed for a larger screen and may be awkward to use on a phone. For a practical workflow, open the spreadsheet on a laptop or desktop, select Extensions > Apps Script, and make code changes there. You can then return to the mobile app to view the spreadsheet results, if the script and file permissions allow.

Why the menu may be missing

If you cannot see Apps Script, check the file, account, and access before assuming the feature has moved. These are common causes:

You are not in Google Sheets: a downloaded spreadsheet or a file open in another application will not show the same Google Sheets menu.
The file is still an Excel workbook: an .xlsx file opened in Sheets compatibility mode may not offer the same script features. If appropriate, use File > Save as Google Sheets to create a Google Sheets copy, then check its Extensions menu.
You have limited access: ask the file owner for edit access, or confirm whether your organization permits Apps Script.
You are on a phone or tablet: use Sheets in a desktop browser for the full editor.
The editor tab did not open: check the browser’s pop-up or new-tab behavior and retry the menu command.

Converting an Excel file creates a Google Sheets version; it does not guarantee that every Excel feature will convert identically. Keep the original file if you need it, and confirm that the converted sheet has the data and formatting you expect before building automation around it.

Work safely before running code

A script can make changes quickly, which is useful but also means a mistake can affect many cells. Before running code that edits data, make a copy of the spreadsheet or test with a small sample. Check which spreadsheet and ranges the code targets, and look for operations that clear, overwrite, or move content. The editor’s execution information can help you diagnose an error, but it does not replace reviewing the code’s effects.

Be cautious with code copied from a website, email, or shared file. Read what it does, especially if it asks for broad permissions or sends information outside the spreadsheet. Do not paste passwords, secret keys, or private data into code that other editors can see. If you are unsure whether a script is appropriate for work data, ask the file owner or your organization’s administrator before authorizing it.

When another tool is a better fit

Apps Script is not the only way to automate a Google Sheet. Start with the least complex tool that meets the need. Built-in formulas can calculate results as data changes, while filters and conditional formatting can make information easier to review without code. Google Sheets also has built-in features for recording or managing certain repetitive tasks, depending on what you need to automate.

Choose Apps Script when the task requires custom behavior, a repeatable sequence of actions, or a connection to services that a formula cannot provide. If a task only involves a calculation, a formula is usually easier for collaborators to inspect and maintain. If it involves a larger workflow, consider who will own the code, how errors will be handled, and whether the script needs to run manually or through a trigger. A script is a small software project, not simply another spreadsheet setting.

Frequently Asked Questions

Where is Apps Script in Google Sheets?
Open the spreadsheet in a desktop browser and choose Extensions > Apps Script. The editor opens in a browser tab. If you cannot see the menu, check your access level, file type, and whether you are using the mobile app.

Is Apps Script free to use?
Apps Script is available through Google accounts, but service limits and features can depend on the account and Google’s current quotas or Workspace policies. Check Google’s current Apps Script documentation for the limits that apply to your account and project.

Why does my sheet say Script editor under Tools?
That wording comes from older instructions or an earlier interface. In the current Google Sheets web menu, use Extensions > Apps Script to open the editor for the spreadsheet.

Can I use Apps Script on my phone?
The Sheets mobile apps do not offer the full Apps Script editor. Use Google Sheets in a desktop browser to create or edit code, then use the mobile app to work with the spreadsheet itself as needed.

Do I need to know JavaScript to use Apps Script?
Apps Script uses JavaScript-based code, so programming knowledge helps when creating or adapting scripts. You can begin with a small example, but you should understand what code does and what permissions it requests before running it on important data.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.