How to Run a Script on Google Sheets

PDF download Download Article
A guide to testing out code in Google's script editor
PDF download Download Article

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

Steps

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/3c\/Run-a-Script-on-Google-Sheets-Step-1.jpg\/v4-460px-Run-a-Script-on-Google-Sheets-Step-1.jpg","bigUrl":"\/images\/thumb\/3\/3c\/Run-a-Script-on-Google-Sheets-Step-1.jpg\/v4-728px-Run-a-Script-on-Google-Sheets-Step-1.jpg","smallWidth":460,"smallHeight":344,"bigWidth":728,"bigHeight":545,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    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. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/48\/Run-a-Script-on-Google-Sheets-Step-2.jpg\/v4-460px-Run-a-Script-on-Google-Sheets-Step-2.jpg","bigUrl":"\/images\/thumb\/4\/48\/Run-a-Script-on-Google-Sheets-Step-2.jpg\/v4-728px-Run-a-Script-on-Google-Sheets-Step-2.jpg","smallWidth":460,"smallHeight":347,"bigWidth":728,"bigHeight":549,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    Find the spreadsheet you want to run a script on, and open it.
    Advertisement
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/ba\/Run-a-Script-on-Google-Sheets-Step-3.jpg\/v4-460px-Run-a-Script-on-Google-Sheets-Step-3.jpg","bigUrl":"\/images\/thumb\/b\/ba\/Run-a-Script-on-Google-Sheets-Step-3.jpg\/v4-728px-Run-a-Script-on-Google-Sheets-Step-3.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":547,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    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. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/01\/Run-a-Script-on-Google-Sheets-Step-4.jpg\/v4-460px-Run-a-Script-on-Google-Sheets-Step-4.jpg","bigUrl":"\/images\/thumb\/0\/01\/Run-a-Script-on-Google-Sheets-Step-4.jpg\/v4-728px-Run-a-Script-on-Google-Sheets-Step-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    This will open the Google's browser-based script editor in a new tab.
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/04\/Run-a-Script-on-Google-Sheets-Step-5.jpg\/v4-460px-Run-a-Script-on-Google-Sheets-Step-5.jpg","bigUrl":"\/images\/thumb\/0\/04\/Run-a-Script-on-Google-Sheets-Step-5.jpg\/v4-728px-Run-a-Script-on-Google-Sheets-Step-5.jpg","smallWidth":460,"smallHeight":343,"bigWidth":728,"bigHeight":543,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    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. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/52\/Run-a-Script-on-Google-Sheets-Step-6.jpg\/v4-460px-Run-a-Script-on-Google-Sheets-Step-6.jpg","bigUrl":"\/images\/thumb\/5\/52\/Run-a-Script-on-Google-Sheets-Step-6.jpg\/v4-728px-Run-a-Script-on-Google-Sheets-Step-6.jpg","smallWidth":460,"smallHeight":343,"bigWidth":728,"bigHeight":543,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    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. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/84\/Run-a-Script-on-Google-Sheets-Step-7.jpg\/v4-460px-Run-a-Script-on-Google-Sheets-Step-7.jpg","bigUrl":"\/images\/thumb\/8\/84\/Run-a-Script-on-Google-Sheets-Step-7.jpg\/v4-728px-Run-a-Script-on-Google-Sheets-Step-7.jpg","smallWidth":460,"smallHeight":342,"bigWidth":728,"bigHeight":542,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    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

Expert Q&A

Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Tips

      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Submit
      Thanks for submitting a tip for review!

      You Might Also Like

      How to
      Sign Out of Your Google Account on All Devices at Once
      How to Delete Google Photos without Deleting Them on Your Phone
      How to Disable Google Safe Search
      How to Sign Up for a New Google Voice Phone Number
      2 Simple Ways to Unsync Google Photos
      How to Restore Google Authenticator if You Lost or Reset Your Phone
      How to Use Google Translate: Complete Beginner's Guide
      2 Easy Ways to Permanently Delete (or, Hide) Your YouTube Channel
      How to
      Fix the "Google Play Store Has Stopped" Error
      How to Use Dark Mode in Google Docs: Easy Steps for Desktop & Mobile
      Reverse Image Search in Google Lens: Android, iPhone, & Desktop
      How to Step Seeing Google Ads on PC or Mobile Devices
      How to Make a Free Website with Google Sites: Step-by-Step Guide
      Easy Ways to Find Backed Up Photos on Google: 3 Methods
      Advertisement

      About This Article

      Article Summary X

      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?
      In other languages
      Thanks to all authors for creating a page that has been read 79,041 times.

      Is this article up to date?

      Advertisement