How to Run a Script on Google Sheets

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.

Steps

  1. Image titled Run a Script on Google Sheets Step 1
    1
    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.
  2. Image titled Run a Script on Google Sheets Step 2
    2
    Click a spreadsheet file. Find the spreadsheet you want to run a script on, and open it.
    Advertisement
  3. Image titled Run a Script on Google Sheets Step 3
    3
    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.
  4. Image titled Run a Script on Google Sheets Step 4
    4
    Tap Script editor on the Tools menu. This will open the Google's browser-based script editor in a new tab.
  5. Image titled Run a Script on Google Sheets Step 5
    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.
  6. Image titled Run a Script on Google Sheets Step 6
    6
    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.
  7. Image titled Run a Script on Google Sheets Step 7
    7
    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.
    8. Advertisement

You Might Also Like

Sign Out of Your Google Account on All Devices at Once
How to
Sign Out of Your Google Account on All Devices at Once
Turn Off Google Safesearch
How to
Turn Off Google Safesearch
Restore Google AuthenticatorHow to Restore Google Authenticator if You Lost or Reset Your Phone
Fix the "Google Play Store Has Stopped" Error
How to
Fix the "Google Play Store Has Stopped" Error
Write a Review on Google2 Ways to Write a Review on Google
Google Sheets How to Insert Time in Cell Automatically4 Easy Ways to Add the Time and Date Automatically in Sheets
Turn Off Google Ads
How to
Turn Off Google Ads
Get a Google Voice Phone NumberHow to Sign Up for a New Google Voice Phone Number
Search by Image on GoogleReverse Image Search in Google Lens: Android, iPhone, & Desktop
Make a Google Account5 Easy Steps to Create a Google Account on Any Device
Make a Time Slot Sign Up Sheet on Google FormsHow to Make a Sign Up Sheet with Time Slots in Google Forms
Do Google GravityHow to Do the Google Gravity Trick in Your Browser
Create a Website Using Google Sites
How to
Create a Website Using Google Sites
Use Google TranslateEasy Ways to Use Google Translate on Desktop and Mobile
Advertisement

About This Article

wikiHow Staff
Co-authored by:
wikiHow Staff
wikiHow Staff Writer
This article was co-authored by wikiHow Staff. Our trained team of editors and researchers validate articles for accuracy and comprehensiveness. wikiHow's Content Management Team carefully monitors the work from our editorial staff to ensure that each article is backed by trusted research and meets our high quality standards. This article has been viewed 68,933 times.
How helpful is this?
Co-authors: 1
Updated: May 15, 2018
Views: 68,933
Categories: Google Applications | Spreadsheets
Article SummaryX

1. Open Google Sheets.
2. Click a file.
3. Click the Tools tab.
4. Click Script editor.
5. Enter your script into the editor.
6. Click the Play/Run icon on the toolbar at the top.

Did this summary help you?
Advertisement