TRY ME!
→ Random Tutorial

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

Create Navigation Buttons in Sheets to Other Sheets

Create Navigation Buttons in Sheets to Other Sheets

Add a button to go to another sheet inside your sheet.
Intermediate
I Created an Automatic Emailer

I Created an Automatic Emailer

While creating SheetOps, a new product, I came up with this idea of an automatic emailer that I can just enter an email and select a series of emails to send them. Needs an unsubscribe link. And so I made it in less than 45 minutes. Here it is. You can start using this right now for free if you're a member.
Advanced Intermediate
Write Email Subject Variations Fast! A Simple Google Sheets Automation

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

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

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

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
Get Every Editor on Every Google File I Own

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

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 Google Maps

Intermediate
Scrape Google Maps Added Phone and Reviews

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

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
David Asks: About Primary Keys

David Asks: About Primary Keys

Create relational databases with index/match. Discover the secret to efficient data management with primary keys! Learn how to sort, filter, and create tables based on unique identifiers in this expert video. Say goodbye to complicated spreadsheets and hello to easy data management.
Intermediate
INDEX() MATCH()
Meet Asa: Ask Sheets Anything

Meet Asa: Ask Sheets Anything

GPT3 Powered Answers to your spreadsheet questions. Ask sheets anything, literally any question about Google Sheets! This might put me out of a job as a Google Sheets Expert.
100 Tweet Starters

100 Tweet Starters

Created a simple tweet starter sheet. Tweet directly from this Google Sheet. Free for Members.
Beginner
Dark Mode / Better Font Color

Dark Mode / Better Font Color

While the desktop version of Google Sheets does not have a dark mode, doesn't mean we can't make it ourselves. Create dark mode in one click. You'll learn to make a dark mode toggle.
Intermediate
Headline Generator: Add Dropdowns

Headline Generator: Add Dropdowns

Create a headline generator inside Google Sheets. Add dropdown menus to make the generator easy to us.
Most Popular
Generate Hundreds of Business Names

Generate Hundreds of Business Names

Create business names quickly with this Google Sheets trick.
Pabbly Connect Countdown - "Sheet Improvement!"

Pabbly Connect Countdown - "Sheet Improvement!"

Create a countdown timer inside of a google sheet. Unlock the secret to a lifetime deal... TIMEI! Discover their amazing live Google sheet and join the countdown to their exclusive offer. Watch as we recreate and enhance their sheet with stunning colors. Don't miss out on this epic journey. Click now!
 Take a list and make it Vertical, Using Split Join or RegexReplace

Take a list and make it Vertical, Using Split Join or RegexReplace

Create vertical lists in Google Sheets.
Beginner
JOIN() REGEXREPLACE() SPLIT() TRUE()
Make a Quick Pipeline (For Sales and More)

Make a Quick Pipeline (For Sales and More)

Create a sales pipeline quickly in Google Sheets.
Beginner
TRANSPOSE() UNIQUE()

Displaying items 261-280 of 349 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