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 253.

Free to copy

Custom Menu - 1 function

Click to copy

function onOpen() {
  var ui = SpreadsheetApp.getUi()
  ui.createMenu('Custom Menu')
      .addItem('User Readable Name', 'functionName')
      .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('Automate', 'automation')
      .addToUi();
}

Most popular

Send Daily Email Updates
```
function basicEmail() {
```
LinkTree in a Google Sheet
```
function doGet(e) {
```

Add Click Tracking To Your Google Sheets | Bitly in a Google Sheet

// watch the loom video: https://www.loom.com/share/f054b6ae697f4dbdb4eb50ed76a3c37a

How to Trigger Macros Daily
```
/** @OnlyCurrentDoc
 * TODO's here
```

Deep Inside Dark Habits Google Script

function onEdit(e){
var range = e.range;

Better Domain Portfolio Template
```
function myFunction() {
```

250 more with membership

Same format: full file, copy button.

Use Random Quote API in Google Sheets

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

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()

Ultimate Prompt Writer and Prompt Rater

function chat() {
  var chat = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("chat")

Unlock code to copy