How to Run a Script on Google Sheets

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.

Click a spreadsheet file. Find the spreadsheet you want to run a script on, and open it.

Click the Tools tab. 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.

Tap Script editor on the Tools menu. This will open the Google's browser-based script editor in a new tab.

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.

Name your script project. 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.

Click the Android 7 Play 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.