Google Apps Script

253 snippets, unlocked with membership.

30 more with membership

Same format: full file, copy button.

Send a Button from Google Sheets in an Email

function sendEmail() {
  var owner = SpreadsheetApp.getActiveSpreadsheet().getOwner().getEmail()

Simple Inventory Management Automations

function onOpen() {
  var ui = SpreadsheetApp.getUi();

Send Better Email When Google Form Filled Out

function sendEmailsUponFormSubmit(e){
  //For multiple Forms use this to get URL

Spreadsheet Automation for Beginners

function emailReport() {
var tasks =  SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1").getRange("G1").getValue();