Recipes

Free Apps Script recipes for Sheets, Gmail and Drive

Full code, install steps, the errors you are likely to hit, and the checks each recipe passes.

• Send an email when a checkbox is ticked in Google Sheets6 checksInstallable on-edit · SpreadsheetApp, MailApp
• Add a timestamp when a row is edited in Google Sheets4 checksSimple onEdit · SpreadsheetApp, Utilities
• Save Gmail attachments to Google Drive automatically3 checksTime-driven, hourly · GmailApp, DriveApp
• Turn a Google Form response into a PDF and email it4 checksInstallable on form submit · DriveApp, MailApp, Utilities
• Mail merge from Google Sheets with sent tracking5 checksRun from the editor or a time-driven trigger · SpreadsheetApp, MailApp
• Run an Apps Script function every day at a set time3 checksTime-driven, daily · ScriptApp
• Email a Google Sheet tab as a PDF on a schedule2 checksTime-driven, weekly or daily · SpreadsheetApp, UrlFetchApp, MailApp
• Create Google Calendar events from a Sheet3 checksRun from the editor or a time-driven trigger · SpreadsheetApp, CalendarApp
• Remove duplicate rows from Google Sheets automatically2 checksRun from the editor or a time-driven trigger · SpreadsheetApp
• Move a row to another tab when its status changes3 checksSimple onEdit · SpreadsheetApp
• Send a reminder email before a due date in Google Sheets3 checksTime-driven, daily · SpreadsheetApp, MailApp
• Create a Drive folder for each new row in Google Sheets3 checksTime-driven · SpreadsheetApp, DriveApp
• Log new Gmail messages to a Google Sheet3 checksTime-driven · GmailApp, SpreadsheetApp