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.

When Urgent, Move to Top of Google Sheet Members only This Google Apps Script function, onEdit(e), automatically moves rows to the top of "Sheet1" when a specific condition is met. Here's how...

SpreadsheetApp .getActiveSheet() .getRange() .getValues() .setValues() .deleteRow() .getRow() .getColumn()
Custom Menu - 1 Function Members only One menu function

SpreadsheetApp .getUi() .createMenu() .addItem() .addToUi()
Dall-e-3 API Call Members only Create an image from Google Sheets with OpenAI's Dall-e

SpreadsheetApp UrlFetchApp .getActiveSpreadsheet() .getSheetByName() .getRange() .getValue() .setValue() .clearContent() .fetch() .getContentText()
Duplicate Template Members only Create a copy of the template. You can trigger this every day or every month, or every week.

SpreadsheetApp Utilities .getActiveSpreadsheet() .getSheetByName() .copyTo() .formatDate()
Create Tab For Every Day of the Year Members only Creates a new tab for every day of the year.

SpreadsheetApp Utilities .getActiveSpreadsheet() .insertSheet() .formatDate()
Get month as full month name Members only This apps script gives you just the full name of the current month, without the day, year, or time. For example instead of Jan. it will...
Email form entries when form filled out Members only Create a simple html table email and send it automatically when a form is filled out.

Logger MailApp SpreadsheetApp Utilities .getActiveSpreadsheet() .sendEmail() .formatDate() .log()
Get Sheet ID and Tab GID Into Your Google Sheet Members only The function retrieves and writes the active spreadsheet ID and the specific sheet ID of "Sheet1" into cells A1 and A2 of "Sheet1",...

SpreadsheetApp .getActiveSpreadsheet() .getSheetByName() .getRange() .setValue()
Remove Second Row Members only A Google Apps Script function that deletes the second row of a specific sheet named "Sheet1" in a Google Spreadsheet. Use...

SpreadsheetApp .getActiveSpreadsheet() .getSheetByName() .deleteRow()
Updated Open AI Model to Omni Members only Updated the code for AI API Calls from Turbo to Omni.

SpreadsheetApp UrlFetchApp .getActiveSpreadsheet() .getSheetByName() .getRange() .getValue() .fetch() .getContentText()
Embed Testimonials with SheetTo Members only Add this code to your Apps Script file 1. Extensions > Apps Script 2. Paste code 3. Deploy > New Deployment 4. Execute as "Me" 5....

ContentService MimeType SpreadsheetApp .getActiveSpreadsheet() .getSheetByName() .getRange() .getValues() .getLastRow() .createTextOutput() .setMimeType()
OpenAI API Custom Function Members only Call OpenAI's API with this simple custom function. Use your own API Key with this seemingly native function.

UrlFetchApp .fetch() .getContentText()
Automatically Open to Tab Members only in this case the tab is called "OPENME" but you can name the tab you want anything and change the text "OPENME" to the name of the sheet...

SpreadsheetApp .getActiveSpreadsheet() .getSheetByName() .activate()
Title Case Members only Add title Case or headline capitalization to your google sheets as a native function.
Timestamp Last Change of Row Members only For a column 3 or C, we want to timestamp anytime the row changes.

SpreadsheetApp Utilities .getActiveSheet() .getRange() .setValue() .getRow() .formatDate()
Timestamp When Done on Certain Sheet Members only This is a version of Timestamp when Done that adds a Sheet to the mix to make sure we're on the right sheet.

SpreadsheetApp Utilities .getActiveSpreadsheet() .getActiveSheet() .getSheetByName() .getRange() .setValue() .getRow() .getColumn() .formatDate()
Timestamp When Cell Changed to Done Members only Automatically create a timestamp when a column of cells is changed to "Done" The Timestamp goes into the next column over from the...

SpreadsheetApp Utilities .getActiveSheet() .getRange() .setValue() .getRow() .getColumn() .formatDate()
Back up Spreadsheet Tab Members only Make a copy and rename to BACKUP plus the Date of the backup. Execute this automatically via Triggers in your Apps Script

SpreadsheetApp Utilities .getActiveSpreadsheet() .getSheetByName() .copyTo() .formatDate()
Add Custom Function Ability to any Google Sheets Function Members only Adds the use of the function inside of your google sheets' cells as part of autocomplete. Add this text just above any function you want...
OpenAI API Prompt and Response Members only Send a text prompt to OpenAI API using GPT 3.5 Turbo. Here's how the code works: Basically the function is named "ai" and then a...

SpreadsheetApp UrlFetchApp .getActiveSpreadsheet() .getSheetByName() .getRange() .getValue() .fetch() .getContentText()
Custom Menu - 2 functions Members only Create a custom menu with 2 functions

SpreadsheetApp .getUi() .createMenu() .addItem() .addToUi()
Custom Menu - 1 function Members only Create a custom menu with only 1 function

SpreadsheetApp .getUi() .createMenu() .addItem() .addToUi()