Google Sheets Tutorials · Better Sheets

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

FILTER() IFNA() SUM()

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()

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

Take Screenshots from URLs in Google Sheets

Use Screenshot One api to quickly get cached images of Screenshots and then go and download them. Check this out and let me know how you'd use it.

Intermediate

IMAGE()

Send a Button from Google Sheets in an Email

quick fun video to show you how to add a button to emails when you send emails from Google Sheets.

Intermediate

Free Education Expense Template

Get this free education funding template I use myself. I use it and enjoy it. Thought you would too.

FV() JOIN() SUMIF() TODAY() YEAR()

Get Every Editor on Every Google File I Own

Get every editor if you're looking for the sheets and documents you've shared with other people and forgot them! Or just want to get a list of them into a Google Sheet.

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

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

Scrape Google Maps Added Phone and Reviews

Added two helper functions to get Phone numbers and reviews of the Google Maps Results.

Google Maps Scraper for Outreach

Get this fun template to search on google maps via API, and quickly message via Whatsapp. Then Manage the outreach.

Intermediate

Intro Video - Make Better Sheets

Transform your Google Sheets game with Better Sheets tutorials! Learn how to create dynamic databases, design-friendly sheets, and more. Discover hidden formulas and tools, and even build your own. Don't miss out on leveling up your productivity. Create dynamic tools, revamp your skillset, and ultimately master Google Sheets like never before. Better Sheets platform offers more than just tutorials. There is a deep directory of every Google Sheets formula with links to step-by-step tutorials as well as blog posts and youtube videos. It's the ultimate resources to learn how to use formulas in Google Sheets. Every tutorial has listed categories and courses it's a part of. In addition to that any formula featured is listed. And you can click on any formula to see that formula in action in other tutorials on the Better Sheets platform. Watch this walkthrough of the Better Sheets platform.

Add Icons To Your Sheets With a Domain Name

Add visual flair to your Google Sheets when sharing company domain information. You’ll learn how to use an undocumented Google API. ( Easier than you think!)

Let's Make a Bookmarklet!

Curate a newsletter. Collect YouTube videos. Research competitors. All with this one line of javascript. Build your own web clipper. Use the Bookmarklet to clip web content to your Google Sheet. Clip text and links directly from the web to your Google Sheet with just a few clicks.

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()

Spreadsheet Automation 101 Lesson 4: OmdbAPI get data in Apps Script

Use getData and UrlFetchApp functions, as well as Logger to get OMDb API data in our Google Sheet. Learn how to access an API outside of Google Sheets.

Sheet Review of 50 ChatGPT Prompts

Tips to help improve the look, feel, branding of Better Sheets Member’s Free Lead Magnet. A free Google Sheet of ChatGPT Templates that just gets better by the end of the video.

Your First Formula

Learn how to use Formulas in Google Sheets. Use the Equal sign "=" to unlock a magical portal of over 500 functions and formulas. Learn one cool trick that even experts might not know about formulas.

Beginner

CONCATENATE() TRANSPOSE()

Build a Better ChatGPT Prompt Builder

In this sheet review I take another YouTuber's ChatGPT prompt builder through the Better Sheets Sheet Makeover process. We make it more useful and more branded. Make it really look and feel cool to use. Saves users time. And makes them want to share it with others.

JOIN() SUBSTITUTE()

My Favorite Fonts

Learn the best fonts to use in Google Sheets.

Beginner

Displaying items 181-200 of 289 in total

TAGS

FORMULAS

TOPICS

289 Google Sheet Tutorials

An exclusive library of Google Sheet Tutorials

Expense Tracker Template with Data Entry Form Inside Sheets

Write Email Subject Variations Fast! A Simple Google Sheets Automation

Generate Google Search Phrases

Take Screenshots from URLs in Google Sheets

Send a Button from Google Sheets in an Email

Free Education Expense Template

Get Every Editor on Every Google File I Own

Enter Google Drive File Name Get URL

Scrape Google Maps

Scrape Google Maps Added Phone and Reviews

Google Maps Scraper for Outreach

Intro Video - Make Better Sheets

Add Icons To Your Sheets With a Domain Name

Let's Make a Bookmarklet!

5 Ways to Generate Random Numbers

Spreadsheet Automation 101 Lesson 4: OmdbAPI get data in Apps Script

Sheet Review of 50 ChatGPT Prompts

Your First Formula

Build a Better ChatGPT Prompt Builder

My Favorite Fonts