Apps Script & automations
Scripts, macros, custom functions, and hands-off automation
Find Files in Folder by Name Apps Script
Learn how to find files in a specific Google Drive folder by name using Apps Script, ensuring you retrieve the correct file even when multiple files share the same name.
Dutch Auction in Google Sheets and Google Forms
Learn how to create a Dutch auction using Google Sheets and Google Forms, where item prices decrease over time until sold. This tutorial covers form creation, automation for price reduction, and tracking sold items.
Create Calendar Event When Form Submitted
Learn how to automatically create a Google Calendar event when a Google Form is submitted, scheduling a review session one week later using Google Apps Script.
Automate Emails by Google Form Responses Using Google Apps Script Email Certain Department Based on
Learn how to automate email notifications to different departments based on Google Form responses using Google Apps Script. This tutorial walks you through creating a database of emails, setting up a Google Form, and linking it with an Apps Script to send emails upon form submission.
How to Create a Tab For Every Week of the Year
Learn how to create a tab for every week of the year in Google Sheets using Apps Script. This tutorial walks you through the necessary code adjustments to customize your weekly tabs based on your preferred starting day.
How to Add a Column Between Transposed List
Learn how to add a gap between transposed lists in Google Sheets without altering your original data. This tutorial demonstrates using the join and split functions effectively for better dashboard design.
How to Quickly Add Approval Dropdown Chip
Learn how to quickly add an approval dropdown chip in Google Sheets to streamline your approval process and keep your data organized.
How to Hide a Sheet Tab Automatically
Learn how to automatically hide and unhide sheet tabs in Google Sheets using Google Apps Script. This tutorial covers creating triggers to manage visibility based on time.
Automatically Check Past Stages
In this video, learn how to automate the checking off of previous stages in a project tracking sheet using Google Sheets and Apps Script, ensuring that once you complete a stage, all prior stages are automatically marked as complete.