How to Run a Script on Google Sheets: 7 Steps

Table of contents:

How to Run a Script on Google Sheets: 7 Steps
How to Run a Script on Google Sheets: 7 Steps
Anonim

This article shows you how to access the Google script editor using a desktop browser and run code within it for the purpose of testing.

Steps

Run a Script on Google Sheets Step 1
Run a Script on Google Sheets Step 1

Step 1. Open Google Sheets using a browser

Type sheets.google.com in the browser address bar and press Enter on your keyboard.

Run a Script on Google Sheets Step 2
Run a Script on Google Sheets Step 2

Step 2. Click on a spreadsheet

Find the spreadsheet in which you want to run a script and open it.

Run a Script on Google Sheets Step 3
Run a Script on Google Sheets Step 3

Step 3. Click on the Tools tab

This button is located in the tab bar, under the file title (in the upper left corner). A drop-down menu will open.

Run a Script on Google Sheets Step 4
Run a Script on Google Sheets Step 4

Step 4. Click on Script Editor in the "Tools" menu

The Google Script Editor for Browser will open in a new tab.

Run a Script on Google Sheets Step 5
Run a Script on Google Sheets Step 5

Step 5. Create the script in the editor

You can write it directly into the window or delete everything on the page and paste the code from the clipboard.

If you're on the hunt for useful scripts, Google offers some basic tips in its developer guides

Run a Script on Google Sheets Step 6
Run a Script on Google Sheets Step 6

Step 6. Give the project a title

Click on the "Untitled Project" section in the upper left corner and give the new project a name in the "Edit Project Name" window.

Run a Script on Google Sheets Step 7
Run a Script on Google Sheets Step 7

Step 7. Click on the icon

Android7play
Android7play

to run the script.

This button is located in the upper left corner of the toolbar, under the file name and tab bar. The code will be saved and executed in the script editor.

Recommended: