TRY ME!
→ Random Tutorial

88 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!

ChatGPT Clone in Google Sheets Part 1

ChatGPT Clone in Google Sheets Part 1

In this tutorial, learn how to create a ChatGPT-like interface using Google Sheets and Apps Script. Record your questions and get answers from OpenAI's GPT-3 API. Follow this step-by-step guide to build your own interactive GPT-3 interface.

  • Style a sheet like ChatGPT. Use the correct colors and interface design.
  • Add new rows to record the questions/prompts.
  • Add rows for the responses, and answers we get from OpenAI API.
 YouTube Title Rewriter with GPT-3

YouTube Title Rewriter with GPT-3

Rewrite YouTube Titles with GPT-3 API. Writes shorter, more persuasive titles I can use to increase views on YouTube. Code is included in Apps Script of sheet.
Advanced
5 Ways To Use Google Sheets for Advanced Project Management

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
Manage Your Wedding Guest List in Google Sheets

Manage Your Wedding Guest List in Google Sheets

Learn how to manage any event with RSVPs and multiple organizers. Use Google Forms pre-filled links, and interesting formulas to manage the catering automatically. And we write Apps Script to send email to non-rsvp'ed guests.
COUNTA() COUNTIF() FILTER() IFERROR() MATCH() +1 more
Building an AI Prompts Playground

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
Solve The Errors, Learn For Loop

Solve The Errors, Learn For Loop

Learn how to debug a For Loop. These are common errors that happen when coding in Apps Script, specifically around the For Loop. This is Part 1 and 2. Get the goal of capture the flag exercise and I give you hints to each one.
Advanced Intermediate
Announcing AtomicSheets.com

Announcing AtomicSheets.com

Most Popular Beginner
Sheet Review of 50 ChatGPT Prompts

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.
 Create Navigation Like A Book or Presentation

Create Navigation Like A Book or Presentation

A pretty cool script I came up with to click and set active the next tab. No matter how many tabs/sheets you have. Makes a book-like page turning action. At the end of the video I say you have to wait, but now you can get the sheet and the script only. Spreadsheet Alchemy is still a work in progress.
Advanced
100 Tweet Starters

100 Tweet Starters

Created a simple tweet starter sheet. Tweet directly from this Google Sheet. Free for Members.
Beginner
Better Font Colors

Better Font Colors

While this advice and all well and good, try out Sheet Styles, a free Google Sheets Add-on that enables you to do this less contrast style in one click. https://sheet-styles.bettersheets.co/
Magical Things You Can do with Checkboxes in Google Sheets

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
Transform Information Into an Info Product

Transform Information Into an Info Product

Transform your information into a money-making machine! Learn how to turn your data into an info product using Google Sheets. Easy steps to follow. Boost your business now! We are selling a Google sheet here. We're selling information, we're selling curation, we're selling the time and the effort and the energy and the focus around, uh, this kind of information that of course information is free online. But we'll make it better.
Intermediate
Create a Summary Tab with Min and Max

Create a Summary Tab with Min and Max

Free tutorial for finding Minimum and Maximum data points.
Intermediate
INDEX() MAX() MIN()
More LinkInBio Templates for Google Sheets | SheetInBio

More LinkInBio Templates for Google Sheets | SheetInBio

You can easily add your own links and improve your bio for free.
Beginner
Create a PR Agency From Scratch

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

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

Member Richard asks this question. Answer: use Google Script and a Trigger.
Escape Spreadsheet Hell A Mini Game

Escape Spreadsheet Hell A Mini Game

Beginner
Sync Two Tabs Without ImportRange()

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

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

Displaying items 61-80 of 88 in total

Better Sheets

Stop guessing your way through Google Sheets. Pick up beginner tutorials when you're stuck on the basics. And study advanced workflows when you're ready to automate. Practical lessons, zero fluff.

Get Started Now

Explore

Academy

Tools

Add ons