Better Sheets

70 Google Sheet Tutorials

💡

An exclusive library of Google Sheet Tutorials

🚀: Efficient: Automation techniques to supercharge your workflow and automate repetitive tasks.
🎯: Precise: Ensure your data is always accurate and your analysis is clear.
🌈: Creative: Discover new ways to use Google Sheets.
❌: Can't Find a Video?: Members can reach out and ask me anything!

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

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.

Create a PR Agency From Scratch

Go from nothing to a working PR agency. Capture sites, and Send email via script

Intermediate

ARRAYFORMULA() FILTER() JOIN() SPLIT()

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

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

Sync Two Tabs Without ImportRange()

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

Advanced

Highlight Row as You Move Your Cell Selection

Checking data? This script changes bg color of entire row as you move your cell selection.

Conditional Formatting Beginner

Spreadsheet Automation 101 Lesson 3: MailApp

Learn about the needed variables for the Mail App to work. In this lesson, I’ll walk you through how you can email yourself or other people the items in a to-do list that hasn’t been done yet.

Spreadsheet Automation 101 Lesson 3: Email Other People For Loop

Send the same email to different people by using the same Four Loop to figure out which ones we’re sending. Do cool things with this Mail App and email system.

Spreadsheet Automation 101 Lesson 4: OmdbAPI Parameter Picker

Get more things than just the poster and movie title by changing our script a bit. By creating different functions, we can get other data such as movie posters or directors.

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.