Google Sheets allows you to automate tasks using Google Apps Script, a JavaScript-based language. Create a Script: Go to Extensions > Apps Script to open the script editor.

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.

Learn how to use and get the most from Google Docs, Sheets, Slides, Meet, Keep, Forms, Gmail, and other apps in Google’s Workspace productivity suite.