Bootstrapping Tools

Create Calendar Event If Missing

“Create a calendar event for each booking row” is easy. Running it twice and getting two events per booking is just as easy…

Sharing from a script is one line, until the job runs twice and the client gets two “shared with you” emails. shareFileWithEmail…

Some jobs should run once: send the reminder Thursday at 9, close the form at midnight, re-check the invoice in two hours…

“What landed in the Inbox folder since last run?” is the start of half the Drive automations we write. listDriveFilesModifiedSince…

You wrote a perfect onEdit that emails the team when Status flips to Done — and nothing happens. Or worse: it works when you edit, then…

Spreadsheets make terrible message buses — until you need a visible, editable backlog that non-engineers can triage. A Jobs tab with pending…

Re-running "Install triggers" should be safe. In too many client workbooks it isn't — every Setup click stacks another time-driven job, and…

Time-driven triggers are how most overnight syncs stay hands-off. This helper creates a once-per-day trigger for a named function around the…

Drip campaigns (aka email sequences) are a powerful way to re-engage users using a linear fashion. Many email marketers use this technique…

In this video, we'll go over 5 examples of using Event Triggers to help you go from doing tedious work to being a SUPERCHARGED automation…

Automating your Google Search Console data imports into Google Sheets has NEVER been easier with this customized Sidebar UI that lets ANYONE…

We all wish that uploading responses to your Google Form was as easy as inserting new rows into the linked Google Sheet, but it's not... It…

Adding Dependent/Dynamic Drop Downs to your spreadsheet can give it a HUGE boost in data quality and make it much easier to manage. In this…

Make sure to watch the video to follow along with the code: You're adding Dates WRONG If you don't DO THIS This "Simple Trigger" will fire…

If you have a drop down field in your Google Form where the options tend to change, we're going to show you how you can easily make changes…

Do you have 10+ tabs in your Google Sheet that you have to update? Instead of manually (and mind-numbingly) going through all of them and…

Google Apps Script is a powerful free Google product that lets you write scripts to customize and automate your workflows. In this video, we…

In this video, we'll show you how to programmatically generate a Table of Contents using Google Apps Script. We'll go over how to set up…

Monday.com is a modern task management application that has become incredibly popular thanks to its intuitive UI and flexible integrations…

Welcome to Community Support - where you can get help with hurdles you're facing while bootstrapping your company or trying to find new ways…

In this video, we'll show you how to automate snapshots of your Google Sheets and have those logs stored in a separate Google Drive folder…

Ever wish you could automatically notify your colleagues of important changes you've made to a Google Sheet? Or maybe notify a client when…

We've seen how helpful a Table of Content can be when your google sheet has many different tabs in it, but as we saw in the basic TOC guide…