Google Apps Script

3 snippets you can copy right now.

Browsing as a guest. These 3 are free to copy — log in to unlock all 448.

Custom Menu - 1 Function

Click to copy

function onOpen() {
  var ui = SpreadsheetApp.getUi();
  ui.createMenu('Custom Menu')
      .addItem('Automate', 'automation')
      .addToUi();
}

Custom Menu - 2 functions

Click to copy

function onOpen() {
  var ui = SpreadsheetApp.getUi()
  ui.createMenu('Custom Menu')
      .addItem('First item', 'menuItem1')
      .addItem('Second item', 'menuItem2')
      .addToUi()
}

Custom Menu - 1 function

Click to copy

function onOpen() {
  var ui = SpreadsheetApp.getUi()
  ui.createMenu('Custom Menu')
      .addItem('User Readable Name', 'functionName')
      .addToUi()
}

445 more with membership

Same format: full file, copy button.

Use Random Quote API in Google Sheets

function getQuote(category){
  if (category == 'famous' || category == 'movies'){

Use Random Quote API in Google Sheets
```
{
  "timeZone": "Asia/Makassar",
```

Ultimate Prompt Writer and Prompt Rater

function GPT(prompt) {
  var apikey = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("apikey").getRange("A1").getValue();

Uncheck Every Checkbox in Google Sheets

function uncheck() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet()

Unlock code to copy