For its Google Sheets online spreadsheet, the Alphabet affiliate has announced that you can now save macros that replicate a specific set of user interface interactions that you define. “Suppose you need to import new data that you want to put in the same format, or you want to create the same graph on several quarterly spreadsheets. Manual repetition of the same steps can take hours, but the Sheets macro recorder allows you to record these actions and read them without having to write any code, “says Google as an example to remind them importance of macros. Once you have saved a macro, you can link it to a keyboard shortcut in the form Ctrl + Alt + Shift + Number. You can use this shortcut to quickly execute the exact macro steps, usually in a different location or on different data. You can also enable the macro from the Google Sheets> Macros Tools menu. When you save a macro, Google Sheets will automatically create an Apps Script function (the macro function) that replicates the macro steps. The macro function is added to an Apps Script project linked to the sheet in a file called macros.gs. In case there is already a project file linked to the sheet with this name, the macro function is added to it. Google Sheets also automatically updates the script project manifest, saving the name and keyboard shortcut assigned to the macro. As each recorded macro is fully defined in Apps Script, you can edit them directly in the Apps Script Editor. You can even write macros from scratch in Apps Script, or take functions that you have already written and turn them into macros.