Topics → Automating

Includes

120 Tutorials

Free for Members

You find yourself doing rote tasks. Again and again, day after day. While designing better sheets makes your life in the sheets better. There’s far more life outside the sheets. Here are the videos that help you record simple tasks and repeat them without fail.

Are you tired of doing the same repetitive tasks in Google Sheets day after day? Do you wish you had more time to focus on the bigger picture instead of being bogged down by mundane data entry and formatting? Well, the solution to your problem is simple – automate your Google Sheets workflow! In this article, we will explore the benefits of automating your Google Sheets and provide you with tips and tricks on how to do so efficiently.

What is Google Sheets?

Google Sheets is a cloud-based spreadsheet software that allows users to create and edit spreadsheets online while collaborating with others in real-time. It is a free alternative to Microsoft Excel and offers many of the same functionalities, such as formulas, charts, and pivot tables. With Google Sheets, you can easily organize and analyze your data, making it an essential tool for businesses, students, and professionals alike.

Automating Google Sheets

As mentioned earlier, automating your Google Sheets can help you save time and reduce errors by streamlining your workflows. By automating your Sheets, you can eliminate the need for repetitive data entry, formatting, and calculations. Here are some ways to automate your Sheets:

Macros

Macros are a series of actions that you can record and replay in Google Sheets. They allow you to automate tasks such as formatting cells, copying and pasting data, and running calculations. Macros are an excellent way to save time and reduce errors, especially if you perform the same tasks repeatedly.

Google Apps Script

Google Apps Script is a scripting language that allows you to extend the functionality of Google Sheets. With Apps Script, you can create custom functions, automate tasks, and even build web applications that integrate with Google Sheets. Apps Script is an advanced tool that requires some coding knowledge, but it is a powerful way to automate your Sheets.

Triggers
Triggers are a powerful tool in Google Sheets that allow you to automate repetitive tasks by setting up scripts to run automatically under specific conditions. In essence, triggers work like cron jobs but within Google Apps Scripts, allowing you to start scripts automatically in response to specific events or at designated times.

Types of Triggers
There are two types of triggers that you can set up in Google Sheets: event-based triggers and time-based triggers.

Event Based Triggers
Event-based triggers are triggered by specific events that occur in your Google Sheet, such as a change to a cell, a new row being added, or a form being submitted. You can set up an event-based trigger to run a script automatically when one of these events occurs, allowing you to automate tasks such as data entry or updating calculations.

Time Based Triggers
Time-based triggers are triggered based on a specific time or interval, such as every hour, every day, or every week. You can set up time-based triggers to run a script automatically at the designated time or interval, allowing you to automate tasks such as sending reminder emails or generating reports.

Find out about all the triggers available in Google Sheets, here on Better Sheets.

Add-ons

Add-ons are third-party tools that you can install in Google Sheets to add new features and automate tasks. There are many add-ons available for Google Sheets, ranging from simple data formatting tools to advanced data analysis and visualization tools. Add-ons can help you save time and improve your productivity by automating repetitive tasks and simplifying complex workflows.
I've created Free Google Sheet Add-ons. You can find them here.

Google Sheet Formula Frustrations Solved

Find every formula you'll ever need in Google Sheets here at Better Sheets. Whether you're a beginner or an advanced user, I’ve got you covered with a comprehensive guide of 504 formulas.

Are you struggling to find a specific value in a column of data? Look no further than the powerful VLOOKUP formula. Or maybe you need to calculate the sum of values that meet specific criteria - try out SUMIF. And when it comes to frequency of values, COUNTIF has you covered.

Have you heard of the mysterious and powerful IF formula? It can turn your spreadsheets into gateways of productivity. And don't forget about the oft-partner ISBLANK().

Find step-by-step tutorials for any formula here on Better Sheets. Every formula page comes with links to written blog posts and Better Sheets tutorials featuring the exact formula.

Looking for a way to segment data based on specific criteria? The FILTER formula is perfect for you.

If you need to replace VLOOKUP, give INDEX/MATCH a try.

At bettersheets.co/formulas, I have everything you need to take your Google Sheets skills to the next level.

From ARRAYFORMULA() to ZTEST(), Better Sheets has it all.

At bettersheets.co/formulas, I have everything you need to take your Google Sheets skills to the next level.

From ABS() to ZTEST(), Better Sheets has it all.

120 Tutorials

2 Ways to Delete Lines Quickly (CAREFUL, it's a script!)

Write an apps script to delete lines easily.

Advanced

Generate Google Search Phrases

Create a lot of search phrases from one simple automation trick. Generates a lot of phrases without having to ask AI.

Beginner

Automatically Backup a Spreadsheet

Make a copy and rename to BACKUP plus the Date of the backup. Execute this automatically via Triggers in your Apps Script. Two are shown here. to back up a tab or back up a spreadsheet file.

Intermediate

Creating a Live Message in Google Sheets

Sit back and enjoy this comprehensive tutorial on how to create a live message in Google Sheets. In this video, we dive deep into the process of live message creation, providing step-by-step instructions and practical examples. Whether you're a beginner or an experienced user, this tutorial will empower you to unleash the full potential of Google Sheets.

Intermediate

MicroManager: Hourly Email Reminders

I'll show you how to set up a super powered checklist that can act like a micro manager. It emails you hourly with the top unchecked item on your To-Do list.

Advanced

Getting Started Coding in Apps Script

A short 10 minute video to get you started with Apps Script. Showing you menu: Extensions > Apps Script. And shows off how to write a function, do some math, manipulate some text. Members can get Spreadsheet Automation 101 in https://BetterSheets.co/courses

Beginner

Automatically Check Past Stages

Create an automation that runs whenver we check off a checklist item the past stages also check.

Beginner

How To Duplicate a Tab and Move it to the End in Google Sheets

Learn how to automate creating a template and moving the tab to the far right, or the end of the google sheets tabs.

Intermediate

How To Send Two Emails in Same Trigger

Without having to create two functions and two triggers you can combine two email sends into one function.

Intermediate

SheetLord Update: duplicate tab and automatically add Search Term

Updated SheetLord with a new function.

Intermediate

Onboarding Scheduler

I will guide you through the process of creating an onboarding scheduler using Google Sheets and Google Apps Script.

We will automate the sending of emails and granting access to documents based on a schedule.

I will walk you through the script code step by step. By the end of the video, you will have a functional onboarding system that can send checklists and standard operating procedures (SOPS).

Intermediate

Launching SheetOps The Business Operations Task Manager

Jump in and watch this quick run through of what is SheetOps. It's not just an automated task list, it's a business operations command center. Command the chaos! Get it at https://BetterSheets.co/tools/sheetops

Advanced Intermediate

Scrape Google Maps

Scrape any query in Google Maps into your Google Sheets. Enter your API key and enter a query. Get results. Get your APIKEY from here: https://developers.google.com/maps/documentation/places/web-service/get-api-key?setupProd=enable

Intermediate

Magical Numbering

Create a sequence of numbers that magically appears as you type in each row. Put this in A1 and start typing in column B: =SEQUENCE(COUNTA(B:B),1,1,1)

Beginner

COUNTA() SEQUENCE()

Go to Specific Cell When Spreadsheet is Opened

Create an automation that goes directly to a cell you pick every time you open the spreadsheet file.

Beginner

Automatically Copy Spreadsheet Tab to New File with Values Only, No Formulas

Automatically copy a spreadsheet tab to a whole new spreadsheet file, get the url of that new sheet, and make sure the new file is values only. no formulas. A member asked this question and I'm happy to answer it, code it, and let you in on the answer in this short video.

Intermediate

Automate Move Blank Rows

Automate the apps script we just created that moves blank rows from one sheet to the other sheet. Original tutorial to write the apps script

Intermediate

How to Insert Multiple Rows in Google Sheets (Easy to Hard)

Learn how to add multiple rows to your google sheets by hand, and automatically.

Advanced Beginner Intermediate

Sync Many Tabs without ImportRange()

Sync more than two tabs with Apps Script

Advanced

Move Cells to New Row with Formula

Move a range, or a set of cells, to a new area with a simple formula that's just "curly brackets". Very easy and simple to use once you know it.

Beginner

Whitening Google Sheet Prank

Drive your office crazy by setting a trigger to lighten the text and background of your sheet by 1 rgb point every time they edit, or based on every hour!

Learn how to create triggers in a fun way.

Advanced

Timestamp When Done (With Code)

Automatically create a timestamp when a certain cell is marked as Done. I show you how to customize this scrip and where to get the script. I hope this is simple enough for beginners to start automating you sheets. If you want to see more automations and dive deeper into apps script enroll in Spreadsheet Automation 101
and see more examples of Apps Script at BetterSheets.co/snippets

Beginner

Send Better Email When Google Form Filled Out

Find out how to email all the form entries each time your form is filled out.

Intermediate

Can I get alerted when a tab name is changed?

Find out in this quick experiment if a tab name can be alerted to the owner of the spreadsheet. Great for owners and operators who want to know if someone is changing the sheet.

One Million Checkboxes

Check out this fun onEdit() counting you can do with checkboxes in a fun sheet with 1 Million Checkboxes.
Anyone can log into google sheets and go here: https://bettersheets.co/checkboxes

Beginner

Email Yourself a Cell from a Google Sheet, Every Day

Learn how to email yourself a cell from a Google sheet every day in just a few simple steps! This powerful technique will change the way you manage your data. Follow along and get ready to be amazed!

Learn to automate an email, with data, from a sheet.

Beginner

Better Email Form on Google Sites

Submit email from a Google Sites to Google Sheets with this easy to embed html form instead of using Google Forms.

Advanced Intermediate

How to Copy To New Tab When Checked

Copy text from one tab to another based on a checkbox being checked.

Beginner

Reformat Pasted Cells Automatically

Create uniform formatting even if you're copy and pasting data that is differently formatted.

Intermediate

Every Google Drive File Created in Last 24 Hours

Create a simple report in a Google Sheet that documents every file in your Google Drive that was created in the last 24 hours.

Intermediate

Email Certain Department Based on Google Form Entries

Message a certain department when google form is submitted.

Advanced

Advanced Coding in Google Sheets for Programmers

Add a Custom Menu
Create Native-like Functions
Get URL and Sheet ID's via Apps Script
A Few things to know about Developing Google Sheet Add-ons

Advanced Intermediate

Idea Graveyard - Create a Decaying Checklist

Build a simple function that deletes undone items in our checklist.

Intermediate

Uncheck Every Checkbox in Google Sheets

Automatically uncheck a whole range of checkboxes. Or just do it yourself with the spacebar.

Intermediate

Brighten Up Your Checklist Automatically

Create a cool function that brightens your sheet background from white to some specific color a little bit each time you check off a to-do item.

Intermediate

Automatically Align Top

Automate formatting cells to align top. Either by a time-based trigger or every time you edit cells.

Move Blank Rows

Apps Script function to move all blank rows if a certain column is not filled in. Learn how to automate this script →Here

Intermediate

Breaking Through Errors In Apps Script

See where to find errors in your apps script and how to fix them. You will either get syntax errors ( the way the code is written) or runtime errors (when you actually run the code).

Intermediate

Spreadsheet Automation for Beginners

I start off this video with the idea to show beginners how to automate emails in their sheets, and also add a little bit of AI. Then half way through the video I have a question... can I write AI and then email myself everyday? We try to do that. So you get to see me struggle, and log, and debug. It's quite intense.

Learn more Automation: https://bettersheets.co/courses/spreadsheet-automation-101

Get the AI GPT-3.5 and GPT 4 code: https://bettersheets.co/tutorials/upgrade-google-sheets-openai-prompt-to-gpt-4

Better Sheets members can get the code and the sheet in the video below.

Beginner

SPLIT() INDEX()

Close Form After Certain Number of Responses

Create automatic triggers that close a form after a certain number of responses.

Intermediate

Automate Form Response to Confirmation Email

Create an email automatically when someone fills out a google form. include a url that has a clickable confirmation link and a unique id.

Advanced

Add Columns Automatically

Create your own "Add Columns" button just like the add rows to the bottom.

Intermediate

Proof of Life

Create a script that sends an email to ask for proof of life every month, or it will destroy the google sheet.

Advanced

Enter Google Drive File Name Get URL

Create a simple automation with an installable trigger that allows you to enter the Google Drive file name and get the URL inside your Google Sheet.

Intermediate

Sync Tabs in Different Sections

How to sync different sections on different tabs. In this case we're taking data from multiple tabs putting into one, and syncing between those.

Advanced

Weekly Email Sheet as Lead Magnet

Create a fun freebie for selling spreadsheets

Write Email Subject Variations Fast! A Simple Google Sheets Automation

Create a simple automation for adding text to a cell of text. Really easy example is to create a lot of email subject lines from one single cell of text.

Beginner

IF()

Automatically Clear Content | Refresh Reuse Recycle Templates

Create automatic functions to clear content.

Intermediate

VAR vs CONST vs CONSTANT in Apps Script

Level up your variable assignments in this quick video on why there is Var or Const, or a Constant.

Form Automations: Close Multiple Forms When Over Limit

Adding to the Form Automations:
Allow User to Reopen form without Apps Script access
Set Limit in a Sheet, not in Apps Script
Set Limits for different Forms

Advanced

I Created an Automatic Emailer

While creating SheetOps, a new product, I came up with this idea of an automatic emailer that I can just enter an email and select a series of emails to send them. Needs an unsubscribe link. And so I made it in less than 45 minutes. Here it is. You can start using this right now for free if you're a member.

Advanced Intermediate

Create Your Own Pride Flag Easter Egg in Sheets

If you type the letters of PRIDE in the first 5 columns in the first row of your sheets they'll turn the color of the pride flag. If you want to create your own easter egg in sheets then follow along this step-by-step tutorial as I show you how.

This might be better than Conditional Formatting! We're using the onEdit() simple trigger in Apps Script..

Conditional Formatting Advanced

Automate Google Sheets With Zero Experience

By the end of this video you should be knowledgeable about how to automate spreadsheets. I'm assuming you have no knowledge of how to automate or how to code and so we're gonna start with a very blank page

Beginner

Scoping Functions in Apps Script

Create multiple functions that run with the result of other functions.

Advanced

Laziest Checklist Ever

Get your spreadsheet to check off your checklist for you.

Dive into spreadsheet automation with this easy to follow script, or copy the sheet and use the script as you wish.

Intermediate

Don't Delete My Formulas

How to prevent someone from deleting your formulas. Beyond protecting your range or sheet.

Email Myself a Daily Random Motivational Quote

Quickly make a daily email to myself with a motivational quote.

Beginner

Automatically Uncheck A Daily Checklist

Create an automatic unchecker for a daily checklist. Fun way to learn Apps Script and simple Google Sheets automation.

Beginner

Saving OpenAI API Calls inside of Google Sheets

Copy text output and input into a google sheet from your OpenAI API calls. Great way to save AI text into a sheet or start to create your own AI writer, or even clone ChatGPT

Intermediate

Activate A Certain Sheet When Opening a Spreadsheet

Create a short function that runs every time a spreadsheet file is open. Redirects the user to the START tab. You can use this to direct anyone opening your file to a specific tab you want them to start on.

Intermediate

Create a Vote Button from Google Sites to Google Sheets

Connect your published Google Site to Google Sheets with Apps Script and a Button. Great to use for Voting, upvoting, NPS, or anything you want feedback on, at the click of a button from your Google site to a Google Sheet.

Intermediate

Self Destructing Google Sheet

Create a sheet that can trash itself. It can delete itself instantly or on a timer. Maybe in 24 hours or a month.

Intermediate

Automated Project Management in Google Sheets

Create automatic notifications when a project is assigned, a project needs review. And move a project from one tab to another tab.

Intermediate

Built a Cookie Clicker Clone in Google Sheets

I built a clone of Cookie Clicker, live on YouTube. Watch the full 1 hour live stream here.

In this video I update it a bit, and show off that it works!!

Learn how to build trigger builders and use user properties to store data you don't want a user to change (easily)

Advanced

Automatic Screenshots in Apps Script

Advanced

NEW TOOL Parse Spintax for Content Spinning

Introductng a new tool from Better Sheets. A free Google Sheets™️ Add-On to parse spin syntax content.

Revolutionize Your Google Sheets writing with Spin Tax Content Spinner! Say Goodbye to Tedious Editing. Get All the Variations You Need.

Spin randomly to get one variation
Spin text for all variations
Spin text for all variations including duplicates

Spintax is written with pipes separating content you want to randomly select. {Hi|Hello|Hey} would either be Hi, or Hello, or Hey.

SUBSTITUTE()

Announcing Sell Daily and How I Built Sell Daily

Send daily emails to yourself to master sales every single day. 100% completely free for Better Sheet members.

Beginner

ROUND() HYPERLINK() IF() MATCH() INDEX() +3 more

Make AI-generated Poems Based on Name

Create simple poems based on someone's name with AI.
AI Apps Script Code here: https://bettersheets.co/snippets/updated-open-ai-model-to-omni

Intermediate

Tips to Navigating Thousands of Lines of Code In Apps Script

Find out how I use Apps Script built in features to code very quickly and efficiently.

Beginner

How to Create AI Images From Google Sheets

Use the Open AI API and Dall-e-3 to create image in Sheets

Intermediate

Create New Worksheet When Google Form Submitted

Automate copying a template for new form submissions with user data inserted into the new sheet.

Advanced

Why Different Cell References in AI Integration in Sheets?

Find out How to Optimize your Apps Script functions. Learn the trade offs between flexibility, edit-ability, and protection. Different cell references allow you to do more with your apps script.

In the context of the video we're talking about an AI prompt and how I used different Cell References when writing different Apps Script functions. I'll show you why I chose those syntaxes and why you might choose different ones.

This video is more about Apps Script than writing Prompts but can help you create better web apps inside of Google Sheet, utilizing the best of Apps Script and creating your own custom functions.

Advanced

Expense Tracker Template with Data Entry Form Inside Sheets

Create a data entry form for an expense tracker. Simple dashboard too with sum and sum between two dates.

Intermediate

SUM() FILTER() IFNA()

Build a Visual Clock

I'll show you how to create a visual clock in your Google Sheet using conditional formatting.

By following a few simple steps, you'll be able to see the progress of each hour throughout the day.

No manual updates required! I'll guide you through setting up the custom formula, applying it to the desired range, and making it work for multiple columns if needed.

Plus, I'll share a tip on how to reverse the colors if you prefer to track the remaining time instead.

Let's get started and make your Google Sheet even more efficient!

Intermediate

TIMEVALUE() NOW()

Build Your Own AI Writer in Google Sheets

Create your own AI writer with these google sheets tips and tricks and code.

Advanced

SUBSTITUTE()

Create an Automated Task List

I've created simple automations to make an awesome automatic task list. Add a checkbox when adding a task. Add a timestamp when done. Also emailing every day the top task.

Intermediate

Simple Inventory Management Automations

Create a few simple automations like email notifications and low stock alerts.

Beginner Intermediate

ISBLANK() IF()

Learn to Code in Google Sheets, For Programmers

Google Sheets uses a scripting language called Google Apps Script, which is based on JavaScript. If you know how to code in JavaScript, you'll find Google Apps Script very familiar. To get started, open a new Google Sheet and go to the "Extensions" menu, then click "Apps Script".

Intermediate

IMAGE()

Create an Internal Google Sheets Add-on

The entire process to create and publish a Google Sheets Add-on internally to your own domain.

Intermediate

Tag Emails From A List of Members in Google Sheets

Add labels to gmail emails you get from email addresses you put in a Google Sheet list. Great for tagging members, subscribers, users, when you want to prioritize them in your Gmail. Great to see a function laid out that interacts with Gmail inside of Google Sheets Apps Script.

Advanced

Open Spreadsheet to Motivational Quote Automatically

Create a simple script to open a particular tab. In this case we're opening to a random motivational quote each time.

Beginner

RAND() INDEX() ROUNDUP() COUNTA()

Can I Automatically Rename a Sheet based on a Date?

Change the title of a spreadsheet from within a cell in the spreadsheet.

Intermediate

TODAY() YEAR() MONTH() DAY()

How To Change Date Format Automatically

Create automations to change date format based on the format you want, inside your sheet.

Advanced

CRM Automations

Simple automations you can add you to your CRM to keep it clean and looking great.

Intermediate

IF() ISBLANK() WORKDAY() DATEDIF()

Send Daily Email Updates

extending Google Sheets in a really fun way. We're gonna be sending emails. I have had literally two people in the past week and a half ask me for this and I answered their question very specifically, but I wanna generally reach out to everyone here, give everyone the opportunity to learn this.

Advanced

Building an AI Prompts Playground

Access the OpenAI API, walkthrough of the way we engineer the Apps Script so that we can play around with temperature and token length. Walk through UrlFectchApp as well and parsing JSON.

Advanced

Americano Tournament Template With Four Automations

Created a tournament template with 4 automations. So tabs can be copied by a laptop, ipad, or mobile.

Intermediate

UNIQUE() SORT() SUMIF() SUM()

How to Merge Cells in Google Sheets

A master class on merging cells. How to merge two cells. How to merge multiple cells. How to merge horizontally, vertically, and why. Create groups. Create headers. And how to merge automatically. Members get the sheet and the apps script down below.

Beginner

JOIN() CONCATENATE()

Add NPS to Your Google Site

Create buttons on your Google Site to get an NPS, or Net Promoter Score directly to a Google Sheet.

Intermediate

AVERAGE()

SubSpyHub Subreddit Scanner

I built a subreddit search tool to keep track of subreddits with keywords and interesting conversations.

Intermediate

ISBLANK() IF() HYPERLINK() SUBSTITUTE()

Automate Help Desk Ticket Closing

Create a simple automated help desk ticketing system.

Create tickets
Closed dropdown
Calculate time to close
Create dashboard

Advanced

IF() COUNTA() COUNTIF() FILTER() AVERAGE()

Richard Asks: Copy Template Tab and Rename to Date Every Week

Member Richard asks this question. Answer: use Google Script and a Trigger.

Access Free API's with Google Sheets

Get Kanye Quotes, Hogwarts Houses, Public Holidays, and more fun with API's in this 1 hour dive into Free APis available online and accessible in Google Sheets.
API's here: freepublicapis.com

Intermediate

IF() ISBLANK() IMAGE() COUNTIF()

Celebrate Your Completed Checklists

Learn how to use apps script to add emoji animations when you complete a checklist in Google Sheets.

Advanced Intermediate

RAND() INDEX() IF() COUNTIF() IFNA() +3 more

Send a Daily Email with Inspiring Quote - A Little Pick Me Up

Created a daily email with a motivational quote in the subject.

Intermediate

ARRAYFORMULA() RANDBETWEEN() LEN() IF() COUNTA()

Automatically Delete All Sheets If Not Listed Name

A raw, 1 shot take of figuring out how to automatically delete all sheets not named on a whitelist of sheet names. Using the on Change Installable trigger. This video was tough to make!

Advanced

Anika Asks: How To Set Text Overflow All The Time

Learn to set text wrap, overflow, or clip. Great for designing better text in your sheets.

Intermediate

Visicalc 2023 Technical Walkthrough

welcome to the technical walkthrough of VisiCalc 2023. This is the sheet that I released on April 1st for April Fool's Day. Learn how to use the onEdit() function in Apps Script. We learn the Apps Script for: Save a Sheet , Active Cell coloring, and the Out of Memory Toast.

Advanced

Write Your First Script

I walk you through everything you may encounter along the way of coding in Google Apps Script. Discover the challenges and pitfalls before you fail. If you’ve never coded before, I’m right there with you all the way.

How to Edit a Macro

Editing macros in Google Sheets helps you do more in less time.

Advanced

Basic CRM - Add a Powerful Script To Move Row Based on Status

we're going to be adding a very powerful script to our CRMs or any database in which you need to move rows between tabs.

Advanced

Track Every Edit (Almost)

Create a Log sheet in Google Sheets

What Can You Automate in Google Sheets? Every single trigger available to Google Sheet users

Learn about triggers, hourly, daily, weekly, etc.

Intermediate

Dylan Asks: How to Automatically Delete Rows If Cell Contains Value

Find out how to automatically delete rows based on a cell's value. We do this in Apps Script

Advanced

Copy That, From One Sheet to Another - Learn to Code in Google Sheets Part 4

Learn to code in sheets. Automate Your Daily Sales Report with Google Sheets: Learn how to create a script that copies data from one sheet to another, including timestamps. Boost your productivity with this easy guide!

Advanced

NOW()

Capture Emails from Website Form to a Google Sheet (Without Zapier)

Embed a little HTML into your site to capture Emails straight to a Google Sheet. I've written the apps script and the html and the javascript for you. As easy as copy and pasting. Use my referral link if you choose to use Carrd for this: https://try.carrd.co/kamphey

SUBSTITUTE()

Now Do It Every Damn Day - Learn to Code in Google Sheets Part 5

Now that we have a script that we wanna run every day, how do we run this? This is a key part of programming. It's like Cron Jobs in Apps Script

Advanced

Automatic Weekly Backup of Google Sheets

Discover how to Save Your Sheets Every Week Automatically

Intermediate

Sync Two Tabs Without ImportRange()

Get this epic script that automatically edits two tabs and keeps them in sync.

Advanced

Add Click Tracking To Your Google Sheets | Bitly in a Google Sheet

Create a click Edit: Google changed how the redirect is handled. It no longer automatically goes forward, so you will need to add a link for a user to click on again to go to the forwarded link.

Advanced

HYPERLINK()

How to Trigger Macros Daily

Automate your apps script and macros you can record.

Advanced

TODAY()

Embed a Headline in a Website from Google Sheets

One of the most requested videos, Ever. How to put data, a number, some text, from a Google Sheets onto a website without having to embed the entire Google Sheet. This is the way!

Advanced

SUBSTITUTE()

5 Ways to Generate Random Numbers

generate random numbers using Google Sheets. Fun ways to figure out how to get random characters. Great to use for creating IDs or Coupon Codes. Nice easy intro to some simple apps script.

Intermediate

RAND() RANDBETWEEN()

OpenSea Data Inside Sheets

Get floor prices into your spreadsheet with URLFETCHAPP. Accessing OpenSea's API directly from google sheets. Get any data you want. from Market Cap to One Hour Volume

How to Record Macros

Record a macro, to Insert a column every day.

Advanced

COLUMN()

Wrap Your Mind Around This - Learn to Code in Google Sheets Part 6

this completes learn to code in Google Sheets and I wanted to finish off by giving you a few more quick concepts that expands your mind of what Google Sheets can do.

Advanced

5 Ways To Use Google Sheets for Advanced Project Management

Here are 5 advanced ways to manage projects inside of Google Sheets Manage Task Flow with IF() and a Checkbox Manage Data Inputs with IF() and ISBLANK() Create Quick Dashboard headers with: Transpose / Unique Create Pickers with Index / Match Email reports with Apps Script

Intermediate

IF() ISBLANK() TRANSPOSE() UNIQUE() COUNTIF() +3 more

Move Entire Row when a Cell is changed to "Yes" - The $75,000 Google Script

This is one of the most popular asked first "automations". How to move a row of data based on a single criteria in a column. Great for sales teams and maintaining a CRM.

Spreadsheet Automation 101 Lesson 2: If ( ){ } and Checkboxes

Let’s talk about the IF formula and the differences. Learn how to insert a checkbox and all the other things it can do for you.

Data validation Intermediate

IF()

Create a Changelog Between 2 Cells Custom Function | To learn Double For Loop

Learn how to track every change in your Google Sheets with a simple custom function in this video on "What Changed." Discover how to compare sentences, paragraphs, and more with ease. Follow along as we create the function from scratch. Get ready to streamline your editing process!

We code a little apps script to figure out the difference between two cells.

Advanced