Just open Docs or Sheets and go to Extensions ... when you record your actions to create a macro, Google Sheets is actually generating a script to perform the demonstrated tasks.