Better Sheets on YouTube

Scrape H1 in Google Sheets

Learn how to scrape H1 tags from multiple URLs using a custom function in Google Sheets with Apps Script. This tutorial simplifies the process of extracting important header information from web pages.

Calculate Reading Time with Custom Function in Google Sheets

Learn how to create a custom function in Google Sheets to calculate reading time based on word count and words per minute, enhancing your spreadsheet capabilities.

Check URL Status from a Google Sheet!

Learn how to check the URL status of multiple links directly from Google Sheets using a simple custom function. This video demonstrates how to implement the function with Google Apps Script to fetch HTTP response codes effortlessly.

Get Tab Name in Cell

Learn how to get the tab name in a cell using a custom function in Google Sheets. This video walks you through the steps to create a simple app script that retrieves the active sheet's name.

How to Change Font Size

Learn how to easily change font sizes in Google Sheets with multiple methods for greater control over your text formatting.

Keep Data Hidden in Google Sheets

Learn how to keep sensitive data hidden in Google Sheets by using named ranges and custom functions in Apps Script. This video demonstrates how to create a more secure way to manage identifiers without displaying them directly in your sheets.

Automatic Certificate Creation in Google Sheets

Learn how to automate the creation and emailing of certificates in Google Sheets using Google Slides and Apps Script. This tutorial walks you through the steps to set up your spreadsheet, write the necessary code, and send personalized certificates as PDFs.

How To Add Emojis to Google Sheets

Learn how to easily add emojis to your Google Sheets using keyboard shortcuts and other methods to enhance your spreadsheets.

SUM From Date to Date in Google Sheets

Learn how to sum values between specific dates in Google Sheets using the SUMIFS function. This video provides a step-by-step guide to correctly setting up your criteria for date ranges.

Count Color by Row

In this video, learn how to count rows in Google Sheets by their background color using Google Apps Script. Discover how to create custom functions to automate this process and visualize your data effectively.

Get Full Year API with Google Sheets

Learn how to turn a Google Sheet into a full-year API that automatically updates, allowing you to share specific data with others securely. This tutorial covers the steps to create and deploy a web app using Google Apps Script.

Automatically Replace Words in Google Sheets

Learn how to automatically replace words in Google Sheets using both the SUBSTITUTE formula and Google Apps Script for real-time editing. This video provides step-by-step instructions to enhance your spreadsheet skills.

Change Font on Every Sheet Tab

Learn how to automatically change the font on every sheet tab in Google Sheets using a few lines of Apps Script. This simple tutorial guides you through the process step-by-step.

Quick Follow Up Email

Learn how to automate sending follow-up emails directly from Google Sheets using Google Apps Script. This tutorial walks you through setting up the script to send personalized emails based on task assignments.

How to Hide Rows Marked Complete in Google Sheets

Learn how to automatically hide rows marked as 'Complete' in Google Sheets using Google Apps Script. This tutorial walks you through the process step-by-step, ensuring your task list stays organized.

Download Google Sheets Quickly

Learn how to quickly download Google Sheets and utilize magic URLs for efficient sharing and exporting. This video reveals tips and tricks to enhance your Google Sheets experience.

Scrape Google Maps in Google Sheets

Learn how to scrape Google Maps data directly into Google Sheets using Google Apps Script. This tutorial covers setting up the API key, writing the script, and customizing your queries for effective data retrieval.

Download Google Sheets

Learn how to easily download Google Sheets in various formats, including PDF and CSV, and discover some hidden tricks to share and copy sheets effortlessly.

Auto Count Length

Learn how to automate character counting in Google Sheets using both a formula and Google Apps Script in this informative video. Discover how to streamline your workflow and eliminate the need for visible formulas.

Automate Upper Case

Learn how to automate upper casing in Google Sheets using Google Apps Script, allowing text in one column to automatically appear in uppercase in another column.

Highlight Unique Values

Learn how to highlight unique values in your data using conditional formatting in Google Sheets, specifically focusing on identifying customers who have made only one purchase.

Audit Your Gmail

In this video, learn how to perform a simple Gmail audit using Google Sheets and App Script to analyze your email metrics, including unread messages and subject line characteristics.

Highlight Below Average

Learn how to highlight numbers below average in Google Sheets using conditional formatting and custom formulas.

UnMerge Automatically Google Sheets

Learn how to automatically unmerge cells in Google Sheets using a simple Apps Script function that runs on a timer, ensuring your sheet stays organized without manual intervention.