Google Sheets Tutorials · Better Sheets

Spreadsheet Automation 101 Lesson 2: Get Values - Introduction

Get Values is done in the Apps Script. In this lesson, you’ll learn what changing .getValue() to .getValues() do. You’ll also learn about Logger and For Loop, which I mention here briefly.

Learn Google Sheet Formulas The Hard Way

One weird way to learn more about what Google Sheets can do. https://bettersheets.co/formulas

Embed a Number in a Website from a Google Sheet

Ever wanted to display some data from a google sheet on your site? Without using 3rd party tools here is the javascript, html and the sheet you will need. and step by step instructions on how to use it.

Advanced

Better Google Ad Writing Tool Sheet Makeover

Got an amazing tool from Inside Google Ads course by Jyll. She shares this tool, and I went for 30 minutes reviewing it, improving it, and redesigning it. Hope members can learn from this video. Jyll graciously allows me to share this sheet with members only!

CONCATENATE() IF() ISBLANK() LEN()

Quickstart Tutorial OpenAI API in Google Sheets

Use the power of OpenAI's GPT-3 inside of Google Sheets. In this quick start tutorial I show you how to take OpenAI's curl commands and change them into Apps Script to use GPT-3 inside of sheets. We write a tweet, we ask questions. And now you can use this power for greater good!

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

COUNTIF() FILTER() IF() INDEX() ISBLANK() +3 more

How To Add Columns in Google Sheets

Do you know all the ways to add columns to your Google Sheets?

Beginner

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.

Create Hundreds of Tweets in a Google Sheet

Write tweets fast! Create hundreds of tweets in a Google sheet with ease and tweet each other's tweets! Learn how to do it with our step-by-step guide

Add Cool Responsive Graphs to Your Stock Tracking Sheets

Create little graphs with SPARKLINE() super easy!

GOOGLEFINANCE() INDEX() SPARKLINE() TODAY()

Magical Things You Can do with Checkboxes in Google Sheets

Turn your sheets into web apps with interactive checkboxes. Make your sheets' UI better with more interaction.

Data validation Beginner

3 More Ways to Count in Google Sheets

Learn how to use CountBlank() and more counting formulas.

Beginner

COUNTBLANK() COUNTIFS() COUNTUNIQUE()

How to Make An Easter Egg Hunt in a Google Sheet - by BetterSheets.co

Create a pastel colored hunting game, just in time for Easter.

Intermediate

COUNTIF() IF()

Get Data With Comments

A great way to manage your data if you have a small group of people who want to add data, but you want control over that data in the sheet. Give them the ability to comment on your data.

Beginner

Make Unsplash in Google Sheets - Part 2

Fix the case sensitive search with lower(). Add quick links to prefilled results. Create another sheet with ImportRange().Protect the sheet from unnecessary edits.

Troubleshooting Bitly in a Google Sheet Script

Exclusive video only for Better Sheets members. This is, uh, troubleshooting your click tracking web app or slash sheet.

Advanced

How to Make a Marketplace in a Google Sheet

Make a marketplace where sellers and buyers do not have to have edit access to a sheet.

Intermediate

ARRAYFORMULA() FILTER() UPPER()

Search for Photos in a Google Sheet

This feature is really handy for designers who want to create notes around designs and mockups to showcase to clients. As a photographer, I can also use this to create a searchable sheet with keywords for my photos. You can even use screenshots instead of Unsplash photos like I'm using here. Basically, all you have to do is insert the images into cells and use V lookup to search for them using the ID numbers. You can use this to mock up a newsletter, test out different thumbnails as a YouTuber, or create a landing page or workflow for your business. It's really easy to change the photos by just changing the ID number.

VLOOKUP()

New Syntax for WhatChanged Formula in Google Script

revisiting the "what changed" custom function I built in a past video. Showing you more apps script

Advanced

Create a Radio Button From Checkboxes Using Google Apps Script

Let's code a Radio button that turns off all checkboxes except the one clicked.

Data validation Advanced

IFS() NOT() OR()

Displaying items 81-100 of 283 in total

TAGS

FORMULAS

TOPICS

283 Google Sheet Tutorials

An exclusive library of Google Sheet Tutorials

Spreadsheet Automation 101 Lesson 2: Get Values - Introduction

Learn Google Sheet Formulas The Hard Way

Embed a Number in a Website from a Google Sheet

Better Google Ad Writing Tool Sheet Makeover

Quickstart Tutorial OpenAI API in Google Sheets

5 Ways To Use Google Sheets for Advanced Project Management

How To Add Columns in Google Sheets

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

Create Hundreds of Tweets in a Google Sheet

Add Cool Responsive Graphs to Your Stock Tracking Sheets

Magical Things You Can do with Checkboxes in Google Sheets

3 More Ways to Count in Google Sheets

How to Make An Easter Egg Hunt in a Google Sheet - by BetterSheets.co

Get Data With Comments

Make Unsplash in Google Sheets - Part 2

Troubleshooting Bitly in a Google Sheet Script

How to Make a Marketplace in a Google Sheet

Search for Photos in a Google Sheet

New Syntax for WhatChanged Formula in Google Script

Create a Radio Button From Checkboxes Using Google Apps Script