Create custom functions and macros in Google Sheets with Google Apps Script.


Create a custom function

  1. In Google Drive, open the spreadsheet for your custom function.
  2. At the top of the spreadsheet, click Tools > Script editor. If you see a welcome screen, click Blank Project.
  3. Add the code for your custom function or macros.
  4. Click File > Save and enter a new project name.
  5. Click OK.
  6. In Sheets, refresh the spreadsheet that contains your custom function to see your changes.

See sample Sheets functions you can use.