Google Apps Script

A library of real Apps Script from Better Sheets tutorials and projects.

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.

Source code is for members

You can browse titles and topics here. Snippet pages are for members only. Join or log in to read and copy code.

Unlock snippets

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.

Automatic Screenshots in Apps Script Members only Automatic Screenshots in Apps Script snippet preview

DriveApp SpreadsheetApp UrlFetchApp .createFile() .createFolder() .getBlob() .getFoldersByName() .getUrl() .appendRow() .getActiveSpreadsheet() .getSheetByName() .fetch() .getContentText()
Automatic Screenshots in Apps Script Members only Automatic Screenshots in Apps Script snippet preview
Automatically Copy Spreadsheet Tab to New File with Values Only, No Formulas Members only Automatically Copy Spreadsheet Tab to New File with Values Only, No Formulas snippet preview

DocumentApp FormApp SpreadsheetApp .create() .openById() .create() .openById() .addItem() .addToUi() .copyTo() .create() .createMenu() .deleteSheet() .getActiveSpreadsheet() .getMaxColumns() .getMaxRows() .getRange() .getSheetByName() .getUi() .openById() .openByUrl() .setValue()
Automatically Copy Spreadsheet Tab to New File with Values Only, No Formulas Members only Automatically Copy Spreadsheet Tab to New File with Values Only, No Formulas snippet preview
Automatically Uncheck A Daily Checklist Members only Automatically Uncheck A Daily Checklist snippet preview

SpreadsheetApp .getActiveSpreadsheet() .getRange() .getSheetByName()
Automatically Delete All Sheets If Not Listed Name Members only Automatically Delete All Sheets If Not Listed Name snippet preview

SpreadsheetApp .deleteSheet() .getActiveSpreadsheet() .getSheetByName() .getSheets()
Automatically Uncheck A Daily Checklist Members only Automatically Uncheck A Daily Checklist snippet preview
Automatically Delete All Sheets If Not Listed Name Members only Automatically Delete All Sheets If Not Listed Name snippet preview
Basic CRM - Add a Powerful Script To Move Row Based on Status Members only Basic CRM - Add a Powerful Script To Move Row Based on Status snippet preview

Logger SpreadsheetApp .log() .appendRow() .copyTo() .deleteRow() .getActiveSheet() .getActiveSpreadsheet() .getColumn() .getLastRow() .getRange() .getRow() .getSheetByName()
Automatic Weekly Backup of Google Sheets Members only Automatic Weekly Backup of Google Sheets snippet preview

DriveApp SpreadsheetApp .getFileById() .getFolderById() .makeCopy() .getActiveSpreadsheet()
Basic CRM - Add a Powerful Script To Move Row Based on Status Members only Basic CRM - Add a Powerful Script To Move Row Based on Status snippet preview
Automatic Weekly Backup of Google Sheets Members only Automatic Weekly Backup of Google Sheets snippet preview
Automatically Check Past Stages Members only Automatically Check Past Stages snippet preview

SpreadsheetApp .getActiveSheet() .getActiveSpreadsheet() .getColumn() .getRange() .getRow() .getSheetByName()
Automatically Check Past Stages Members only Automatically Check Past Stages snippet preview
Automate Move Blank Rows Members only Automate Move Blank Rows snippet preview

DocumentApp FormApp SpreadsheetApp .addItem() .addToUi() .copyTo() .createMenu() .deleteRow() .getActiveSpreadsheet() .getLastRow() .getRange() .getSheetByName() .getUi() .getValues()
Automatically Align Top Members only Automatically Align Top snippet preview

DocumentApp FormApp SpreadsheetApp .addItem() .addToUi() .createMenu() .getActiveSheet() .getMaxColumns() .getMaxRows() .getRange() .getUi() .setVerticalAlignment()
Automate Move Blank Rows Members only Automate Move Blank Rows snippet preview
Automatically Backup a Spreadsheet Members only Automatically Backup a Spreadsheet snippet preview

Logger SpreadsheetApp Utilities .log() .copyTo() .getActiveSpreadsheet() .getSheetByName() .formatDate()
Automatically Align Top Members only Automatically Align Top snippet preview
Automatically Backup a Spreadsheet Members only Automatically Backup a Spreadsheet snippet preview
Automatically Clear Content | Refresh Reuse Recycle Templates Members only Automatically Clear Content | Refresh Reuse Recycle Templates snippet preview

DocumentApp FormApp SlidesApp SpreadsheetApp .addItem() .addSeparator() .addToUi() .clearContent() .createMenu() .getActiveSpreadsheet() .getRange() .getSheetByName() .getUi()
Automatically Clear Content | Refresh Reuse Recycle Templates Members only Automatically Clear Content | Refresh Reuse Recycle Templates snippet preview
Automate Form Response to Confirmation Email Members only Automate Form Response to Confirmation Email snippet preview

ContentService GmailApp Logger SpreadsheetApp Utilities .createTextOutput() .sendEmail() .log() .getActiveSpreadsheet() .getRange() .getRow() .getSheetByName() .getValues() .setValue()
Automate Form Response to Confirmation Email Members only Automate Form Response to Confirmation Email snippet preview
Automate Google Sheets With Zero Experience Members only Automate Google Sheets With Zero Experience snippet preview

Logger SpreadsheetApp .log() .copyTo() .deleteRow() .getActiveSheet() .getActiveSpreadsheet() .getColumn() .getLastRow() .getMaxColumns() .getRange() .getRow() .getSheetByName()