I am pleased to inform you that Google has finally begun offering macros in Google Sheets.
In Google Help, "Automate tasks in Google Sheets, You can save time by automating repetitive tasks with macros." .
https://support.google.com/docs/answer/7665004?co=GENIE.Platform%3DDesktop&hl=en
As mentioned in this help, taking advantage of the macro features is very useful if you need to work over and over again. In other words, you can automate the recording of a single task (macro recording), and then reuse the recorded function in the next iteration. Macro recording automatically creates and saves the script program automatically from inside. You can modify this script later.
For example, if you need to have a Sales Report every quarter, and you apply the same job to the report sheet every quarter, you can simply use the macro to play back the macro recordings from the next quarter without repetition. See YouTube below ..