Google Apps Script

You are browsing a library of real Apps Script from Better Sheets tutorials and projects. See how someone else coded a trigger, menu, or API call. Copy what you need into the Script Editor. Compare different uses of the same functions when you are not sure which approach fits your sheet.

Some snippets are open to copy

A few snippets are available to copy without joining. Look for Open in the list. Copy the code and paste it into the Script Editor. The rest of the library needs Better Sheets membership.

Unlock snippets

Custom Menu - 1 Function Open One menu function
SpreadsheetApp .getUi() .createMenu() .addItem() .addToUi()
Custom Menu - 2 functions Open Create a custom menu with 2 functions
SpreadsheetApp .getUi() .createMenu() .addItem() .addToUi()
Custom Menu - 1 function Open Create a custom menu with only 1 function
SpreadsheetApp .getUi() .createMenu() .addItem() .addToUi()
Close Form After Certain Number of Responses Members only Close Form After Certain Number of Responses snippet preview

FormApp Logger SpreadsheetApp .getResponses() .log() .getActiveSpreadsheet() .openByUrl()
Close Form After Certain Number of Responses Members only Close Form After Certain Number of Responses snippet preview
Create an Automated Task List Members only Create an Automated Task List snippet preview

GmailApp Logger ScriptApp SpreadsheetApp Utilities .sendEmail() .log() .deleteTrigger() .getProjectTriggers() .newTrigger() .addItem() .addToUi() .appendRow() .create() .createMenu() .getActiveSheet() .getActiveSpreadsheet() .getColumn() .getRange() .getRow() .getSheetByName() .getUi() .getValues() .setValue() .formatDate()
Can I get alerted when a tab name is changed? Members only Can I get alerted when a tab name is changed? snippet preview

GmailApp Logger SpreadsheetApp .sendEmail() .log() .getActive() .getActiveSpreadsheet() .toast()
Can I get alerted when a tab name is changed? Members only Can I get alerted when a tab name is changed? snippet preview
Create an Automated Task List Members only Create an Automated Task List snippet preview
Count Merged Rows Members only Count Merged Rows snippet preview

SpreadsheetApp .addItem() .addToUi() .createMenu() .getActive() .getNumRows() .getUi() .toast()
Count Merged Rows Members only Count Merged Rows snippet preview
Create an Internal Google Sheets Add-on Members only Create an Internal Google Sheets Add-on snippet preview

SpreadsheetApp .addItem() .addToUi() .getActiveSheet() .getMaxColumns() .getRange() .getUi() .setBackground() .setFontColor() .setFontWeight()
Create an Internal Google Sheets Add-on Members only Create an Internal Google Sheets Add-on snippet preview
Convert Google Sheets into a REST API Members only Convert Google Sheets into a REST API snippet preview

ContentService SpreadsheetApp .createTextOutput() .getActiveSpreadsheet() .getRange() .getSheetByName() .getValue() .setValue()
Celebrate Your Completed Checklists Members only Celebrate Your Completed Checklists snippet preview

Logger SpreadsheetApp .log() .getActiveSheet() .getActiveSpreadsheet() .getColumn() .getRange() .getSheetByName() .getValues() .setValue()
Celebrate Your Completed Checklists Members only Celebrate Your Completed Checklists snippet preview
Convert Google Sheets into a REST API Members only Convert Google Sheets into a REST API snippet preview
Create a ChatGPT Cheat Sheet Spreadsheet Members only Create a ChatGPT Cheat Sheet Spreadsheet snippet preview

SpreadsheetApp UrlFetchApp .getActiveSpreadsheet() .getRange() .getSheetByName() .getValue() .fetch() .getContentText()
Create a ChatGPT Cheat Sheet Spreadsheet Members only Create a ChatGPT Cheat Sheet Spreadsheet snippet preview
ChatGPT Clone in Google Sheets Part 2 Members only ChatGPT Clone in Google Sheets Part 2 snippet preview

DocumentApp FormApp SpreadsheetApp UrlFetchApp .activate() .addItem() .addToUi() .clearContent() .copyTo() .createMenu() .getActiveSpreadsheet() .getMaxRows() .getRange() .getSheetByName() .getUi() .getValue() .setValue() .fetch() .getContentText()
ChatGPT Clone in Google Sheets Part 2 Members only ChatGPT Clone in Google Sheets Part 2 snippet preview
ChatGPT Clone in Google Sheets Part 1 Members only ChatGPT Clone in Google Sheets Part 1 snippet preview

DocumentApp FormApp SpreadsheetApp UrlFetchApp .addItem() .addToUi() .clearContent() .createMenu() .getActiveSpreadsheet() .getRange() .getSheetByName() .getUi() .getValue() .setValue() .fetch() .getContentText()
ChatGPT Clone in Google Sheets Part 1 Members only ChatGPT Clone in Google Sheets Part 1 snippet preview
Capture Emails from Website Form to a Google Sheet (Without Zapier) Members only Capture Emails from Website Form to a Google Sheet (Without Zapier) snippet preview
Capture Emails from Website Form to a Google Sheet (Without Zapier) Members only Capture Emails from Website Form to a Google Sheet (Without Zapier) snippet preview

ContentService SpreadsheetApp .createTextOutput() .getActiveSpreadsheet() .getRange() .getSheetByName() .setValue()

More help across Better Sheets

Spreadsheet Automation 101

Start here if you are new to code. Learn loops, triggers, MailApp, and API calls in Google Sheets.

Explained

Plain-language guides for Apps Script terms, sheet features, and formula errors you will see in real code.

SpreadsheetApp

Browse methods, tutorials, and snippets built on SpreadsheetApp. The core API behind most sheet automations.

Apps Script hub

Videos, quizzes, tools, and the full automation path when you want more than copy-paste code.

Also explore the API directory, Apps Script Explainer to document pasted code, and UrlFetchApp when snippets pull data from the web.