There’s not much else that needs to be said.  If you missed it – I know I certainly did – Google recently announced the ability to record Macros in Google Sheets.  Take a look at their article here, as well as a short example video from Google.