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.

Google has rolled out updates to Sheets, including the ability to record macros – part of the company’s plan to appeal to more business users with it G Suite cloud product portfolio.