Google Sheets can do a lot—but with Apps Script, it does everything. I’d been using Sheets for years without touching this feature.

How to add scripts to Google apps If you’re comfortable with JavaScript, you can write your own original programs. Just open Docs or Sheets and go to Extensions, then click on Apps Script.

Google Apps Script is a JavaScript-based language used for the creation of add-ons and extensions for applications in the Google ecosystem, including Docs, Sheets, Slides, and Forms.