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.

Learn how to use IF & nested IF statement in Google Sheets. & highlight a row using conditional formatting, set up multiple conditional formatting rules.

Whether you are looking to generate custom reports, create functional tables, custom functions, or integrate Sheets with other Google services, Google Apps Script can help you achieve it.

And to do that, you need to add the function script in the Google Sheets script editor. Not sure how to use it? I covered how to use the Google Sheets script editor in more detail.

Instead they can run the automation directly from within Google Sheets. The example I will show you is for a Sheets custom function that returns the Lighthouse score for a URL like in this gif: ...

What is a Named function in Google Sheets? Named functions are similar to Google Sheets' built-in functions. The difference is that you create them and define what they do.