How to Run a Script on Google Sheets

A guide to testing out code in Google's script editor

Co-authored by wikiHow Staff

This wikiHow teaches you how to access Google's script editor in a desktop internet browser, and run code in the editor for testing purposes.

Things You Should Know

Open Google Sheets in your internet browser. Type sheets.google.com in your browser's address bar, and hit ↵ Enter or ⏎ Return on your keyboard.
Find the spreadsheet you want to run a script on, and open it.

Advertisement
This button is on a tabs bar below the file name in the upper-left corner of your spreadsheet. It will open a drop-down menu.
This will open the Google's browser-based script editor in a new tab.
5
Create your script in the script editor. You can type your script here, or delete everything on the page and paste code from your clipboard.
- If you're looking for some useful scripts, Google offers a few basic suggestions in their developer guides .
Click the "Untitled project" heading in the upper-left corner of your window, and enter a title for your new script project in the "Edit Project Name" window.
7
Click the

icon to run your script. This button is on a toolbar below the file name and tabs bar in the upper-left corner of your window. It will save and run the code in the script editor.
- If you're prompted to authorize script testing, click the Review Permissions button, and Allow script testing in your account settings.