This automated functionality How to create a macro When you record a macro, Google Sheets automatically creates what is called an Apps Script function that replicates the macro steps.

You can create multiple macros in the same Google Sheets document to automate boring, repetitive tasks. So, what are you waiting for? Back to work, you productivity wizard!

How to use Google Sheets to create, work with, and collaborate on spreadsheets — and how Gemini, Google’s AI assistant, can give you a head start.