TRY ME!
→ Random Tutorial

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

A Spreadsheet CRM: Automation at work

A Spreadsheet CRM: Automation at work

Check out a CRM built inside of Google Sheets called SheetifyCRM.com
Beginner
Lock Your Sheets with OnlySheets

Lock Your Sheets with OnlySheets

Understand what you can do, if you use OnlySheets between your payment processor and the buyer.
Intermediate
Weird Idea: Find a Great Sheet Domain Name

Weird Idea: Find a Great Sheet Domain Name

Find a domain to get sheet ideas.
Intermediate
Automate Move Blank Rows

Automate Move Blank Rows

Intermediate
Send Better Email When Google Form Filled Out

Send Better Email When Google Form Filled Out

Find out how to email all the form entries each time your form is filled out.
Intermediate
Every Google Drive File Created in Last 24 Hours

Every Google Drive File Created in Last 24 Hours

Create a simple report in a Google Sheet that documents every file in your Google Drive that was created in the last 24 hours.
Intermediate
Americano Tournament Template With Four Automations

Americano Tournament Template With Four Automations

Created a tournament template with 4 automations. So tabs can be copied by a laptop, ipad, or mobile.
Intermediate
SORT() SUM() SUMIF() UNIQUE()
Add NPS to Your Google Site

Add NPS to Your Google Site

Create buttons on your Google Site to get an NPS, or Net Promoter Score directly to a Google Sheet.
Intermediate
AVERAGE()
Better Email Form on Google Sites

Better Email Form on Google Sites

Submit email from a Google Sites to Google Sheets with this easy to embed html form instead of using Google Forms.
Advanced Intermediate
Why can't people fill in my Google Form?

Why can't people fill in my Google Form?

The reason is because a new form has a setting to only allow those in your domain to fill in the form. I show you in the settings page where to fix this.
 Create New Worksheet When Google Form Submitted

Create New Worksheet When Google Form Submitted

Automate copying a template for new form submissions with user data inserted into the new sheet.
Advanced
Can I Automatically Rename a Sheet based on a Date?

Can I Automatically Rename a Sheet based on a Date?

Change the title of a spreadsheet from within a cell in the spreadsheet.
Intermediate
DAY() MONTH() TODAY() YEAR()
Create an Automated Task List

Create an Automated Task List

I've created simple automations to make an awesome automatic task list. Add a checkbox when adding a task. Add a timestamp when done. Also emailing every day the top task.
Intermediate
How To Get Someone to look at a Cell in Your Sheet

How To Get Someone to look at a Cell in Your Sheet

Some helpful tips on how to get someone to look at a particular cell in your sheet.
Beginner
Simple Inventory Management Automations

Simple Inventory Management Automations

Create a few simple automations like email notifications and low stock alerts.
Intermediate Beginner
IF() ISBLANK()
Automate Help Desk Ticket Closing

Automate Help Desk Ticket Closing

Create a simple automated help desk ticketing system.
  • Create tickets
    Closed dropdown
  • Calculate time to close
    Create dashboard
Advanced
AVERAGE() COUNTA() COUNTIF() FILTER() IF()
Automate Form Response to Confirmation Email

Automate Form Response to Confirmation Email

Create an email automatically when someone fills out a google form. include a url that has a clickable confirmation link and a unique id.
Advanced
Form Automations: Close Multiple Forms When Over Limit

Form Automations: Close Multiple Forms When Over Limit

Adding to the Form Automations:
Allow User to Reopen form without Apps Script access
Set Limit in a Sheet, not in Apps Script
Set Limits for different Forms
Advanced
CRM Automations

CRM Automations

Simple automations you can add you to your CRM to keep it clean and looking great.
Intermediate
DATEDIF() IF() ISBLANK() WORKDAY()
Email Certain Department Based on Google Form Entries

Email Certain Department Based on Google Form Entries

Message a certain department when google form is submitted.
Advanced

Displaying items 241-260 of 347 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