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

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.