Topics → Build Your Own Tools

Includes

155 Tutorials

Free for Members

Master Google Sheets by building tools you'll use again and again.

Go beyond just collaborating within sheets. Create tools from Google Sheets.

Sure, I'd be happy to help you master Google Sheets and build tools that you can use repeatedly. Google Sheets is a powerful tool that can be used to create useful and efficient tools to streamline your work.

To get started, you should have a basic understanding of Google Sheets and its features. You can start by creating simple spreadsheets and gradually build your skills by incorporating more complex formulas and functions.

Better Functioning Sheets
Better functioning sheets in your everyday life will make your life better. By mastering Google Sheets, you can streamline your workflow, automate repetitive tasks, and improve your data analysis skills. This will save you time and increase your productivity, allowing you to focus on what really matters.

Create sheets that help you, your business, and your life. Better functioning sheets in your every day life, will make your life better. Better spreadsheets means happier employees.

Building Impressive Sheets
In this section you'll find videos that help you create impressive sheets you can use yourself. You'll be able to make Internal tools. Tools you'll love to use every day. You'll want to share them.

Making Sheets Others Can Use
Not only for your own benefit. but also tools that your colleagues and coworkers will love too. Once others start using your sheets, you'll need a whole new set of principles. Your old sheet theories don't work anymore. I'll show you how to make sheets others can use without bothering you over and over again. You won't need to remind them what cells to fill out, nor what tabs to click on. Hopefully it'll all be clear as a tool they use, and love.

Nearly every sheet is available to you to download too. As you watch the tutorials you can build everything step-by-step, or you can choose to copy the sheet to your own drive and start from where I left off. Customize the templates and make them personalized to your business needs.

Some examples of tools you can build using Google Sheets include:

Budget Tracker: Use Google Sheets to track your monthly expenses, categorize them, and calculate your monthly budget.
Project Management Tool: Create a project management tool using Google Sheets to track project progress, assign tasks, and monitor deadlines.
Inventory Management Tool: Use Google Sheets to track inventory levels, monitor stock levels, and manage purchase orders.
Employee Time Tracker: Use Google Sheets to track employee working hours, overtime, and vacation days.
Sales Tracker: Create a sales tracker using Google Sheets to monitor your sales performance, track revenue, and forecast future sales.

These are just a few examples of the many tools you can create using Google Sheets. By building tools that you will use repeatedly, you'll become more proficient in using Google Sheets, and you'll be able to accomplish more in less time.

Google Sheet Formula Frustrations Solved

Find every formula you'll ever need in Google Sheets here at Better Sheets. Whether you're a beginner or an advanced user, I’ve got you covered with a comprehensive guide of 504 formulas.

Are you struggling to find a specific value in a column of data? Look no further than the powerful VLOOKUP formula. Or maybe you need to calculate the sum of values that meet specific criteria - try out SUMIF. And when it comes to frequency of values, COUNTIF has you covered.

Have you heard of the mysterious and powerful IF formula? It can turn your spreadsheets into gateways of productivity. And don't forget about the oft-partner ISBLANK().

Find step-by-step tutorials for any formula here on Better Sheets. Every formula page comes with links to written blog posts and Better Sheets tutorials featuring the exact formula.

Looking for a way to segment data based on specific criteria? The FILTER formula is perfect for you.

If you need to replace VLOOKUP, give INDEX/MATCH a try.

At bettersheets.co/formulas, I have everything you need to take your Google Sheets skills to the next level.

From ARRAYFORMULA() to ZTEST(), Better Sheets has it all.

155 Tutorials

How to make a Pill Form Field in Google Sheets

Create rounded pill form fields in Google Sheets.
Using Canva and a bit of a transparent PNG hack, you can make these very easily too!

also make sure to check out Coupon Code Maker a software product I sell that generates thousands of coupon codes in a click.

Recently updated dashboard makes it really cool!

Intermediate

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

Created a GPT function in Sheets

Unlock the Power of OpenAI: Create Ultimate GPT Prompts for Seamless Interaction! Discover the Formula Inside, Explore APIs, and Boost Productivity. Watch Now!

Advanced

Create a new Spreadsheet from just a Name in a Sheet.

Create the Apps Script to create a new sheet from some data inside your sheet. Script included in the sheet below.

Advanced

How to Create a Google Form Automatically

How to create a form programmatically using Google Apps Script. I show you step-by-step how to create a form, set the title, add text items, and set the destination of the form to a specific sheet. This tutorial is perfect for anyone who wants to automate the process of creating forms, whether it's for templates, lead magnets, or recurring forms. No prior coding experience is required.

Intermediate

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

Onboarding Scheduler

I will guide you through the process of creating an onboarding scheduler using Google Sheets and Google Apps Script.

We will automate the sending of emails and granting access to documents based on a schedule.

I will walk you through the script code step by step. By the end of the video, you will have a functional onboarding system that can send checklists and standard operating procedures (SOPS).

Intermediate

Big Year - a Whole Year in One Google Sheets Tab

Get "Big Year" for free via Gumroad.

Get perspective on your 2024 plan with this full year calendar template in Google Sheets.

All-Year-in-One Overview

Imagine having the entire year's schedule on one single page. BIG YEAR offers a comprehensive 12-month display, providing an at-a-glance view of your whole year. This holistic perspective makes it easier to plan long-term projects, vacations, and personal milestones, ensuring you never miss out on life's big events.

More info on the Gumroad page

Coupon Code Maker Updates February 2024 - New Dashboard

Update to Coupon Code Maker
Available for free for lifetime members. Buy via Gumroad if you're not yet a member.
Watch the video because there are discount codes I show you in the video to get Coupon Code Maker for less than $30.
Yes I use Coupon Code Maker myself. It's how I put products from Gumroad onto AppSumo Marketplace.

Intermediate

Self Destructing Google Sheet

Create a sheet that can trash itself. It can delete itself instantly or on a timer. Maybe in 24 hours or a month.

Intermediate

I Created an Advent Calendar

Just in time for the holidays. Great for making promotion calendars to reveal promotions day to day.

Beginner

IMPORTRANGE()

How to Redirect Domains to Google Sheets and Google Docs

Learn how to use URL forwarding to Redirect Domains to Google Sheets and Google Docs. Also included is a new feature I like to in Google which is Publish To the Web. In a previous video about this topic I might not have mentioned that.

Intermediate

Generate Coupon Codes from a Google Sheet - Announcing Coupon Code Maker

You can now generate 100% off unique 1 time use Gumroad Coupon codes from a Google Sheet.
It's $30, available now.
Lifetime members get it for free
https://bettersheets.co/tools/coupon-code-maker

What does Coupon Code Maker do?
Coupon Code Maker is designed for generating coupon codes, particularly useful for sellers on Gumroad. The tool, simplifies the process of creating large quantities of unique, single-use coupon codes.

The tool leverages Google Apps Script for its functionality, indicating a strong reliance on automation and API interactions. It's particularly noted for its ability to generate a high volume of codes quickly and efficiently, which can be exported as CSV files for use on platforms like AppSumo and others. This is important for marketing and selling products effectively on various online marketplaces.

There will be continuous updates to Coupon Code Maker. Get it now for a 1-time payment and you'll get all future upgrades for free.

If you're wondering how to build something like this check out Spreadsheet Automation 101 and Supercharge Your Sheets, two courses available for monthly members and lifetime members alike.

Intermediate

Create Your Own Pride Flag Easter Egg in Sheets

If you type the letters of PRIDE in the first 5 columns in the first row of your sheets they'll turn the color of the pride flag. If you want to create your own easter egg in sheets then follow along this step-by-step tutorial as I show you how.

This might be better than Conditional Formatting! We're using the onEdit() simple trigger in Apps Script..

Conditional Formatting Advanced

How to Validate Email Addresses

I will show you how to validate email addresses using the Mailboxlayer API and Google Sheets Apps Script.

I will guide you through the process of checking MX records, SMTP checks, and other cool features.

By the end of the video, you will be able to validate up to a thousand email addresses per month.

get your free apikey and 1,000 requests at mailboxlayer.com

Intermediate

Email Myself a Daily Random Motivational Quote

Quickly make a daily email to myself with a motivational quote.

Beginner

Automated Project Management in Google Sheets

Create automatic notifications when a project is assigned, a project needs review. And move a project from one tab to another tab.

Intermediate

Advanced Coding in Google Sheets for Programmers

Add a Custom Menu
Create Native-like Functions
Get URL and Sheet ID's via Apps Script
A Few things to know about Developing Google Sheet Add-ons

Advanced Intermediate

Add Title Case to Google Sheets

Discover the Ultimate Google Sheets Hack! Transform Text with Title Case Formula. Say Goodbye to 'Proper' and Hello to Easy Capitalization. Find Out How!

Advanced

Build a Startup Pitch Generator in 20 minutes

Build a fully functioning AI powered startup pitch generator in 20 minutes. I saw a tweet listing startup accelerators and thought it would be cool to build a tool that edits my own startup idea into a personalized pitch to each startup accelerator fund. Get it for your google drive down below
https://docs.google.com/spreadsheets/d/1KevSvdwpONP89eBOe-8fDfp2fGlBafE7BAtI5wgGe2U

Get the AI script here: https://bettersheets.co/snippets/updated-open-ai-model-to-omni

Intermediate

Proof of Life

Create a script that sends an email to ask for proof of life every month, or it will destroy the google sheet.

Advanced

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

NEW TOOL Parse Spintax for Content Spinning

Introductng a new tool from Better Sheets. A free Google Sheets™️ Add-On to parse spin syntax content.

Revolutionize Your Google Sheets writing with Spin Tax Content Spinner! Say Goodbye to Tedious Editing. Get All the Variations You Need.

Spin randomly to get one variation
Spin text for all variations
Spin text for all variations including duplicates

Spintax is written with pipes separating content you want to randomly select. {Hi|Hello|Hey} would either be Hi, or Hello, or Hey.

SUBSTITUTE()

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

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()

Idea Graveyard - Create a Decaying Checklist

Build a simple function that deletes undone items in our checklist.

Intermediate

Why Different Cell References in AI Integration in Sheets?

Find out How to Optimize your Apps Script functions. Learn the trade offs between flexibility, edit-ability, and protection. Different cell references allow you to do more with your apps script.

In the context of the video we're talking about an AI prompt and how I used different Cell References when writing different Apps Script functions. I'll show you why I chose those syntaxes and why you might choose different ones.

This video is more about Apps Script than writing Prompts but can help you create better web apps inside of Google Sheet, utilizing the best of Apps Script and creating your own custom functions.

Advanced

Quickly Build a Daily Random Motivational Quote Website

Build a website from scratch using a little bit of Google Sheets as the backend. Using Carrd to build a html website from the data and display a random quote every time you refresh the page. All the code including the HTML embed is in the sheet below.

Intermediate

Better BMI Calculator

Learn how to calculate BMI and create a custom BMI formula in Google Sheets! In this video, you'll explore the basic formula for BMI using weight and height, then dive into Google Apps Script to create a native BMI function. Perfect for anyone looking to enhance their spreadsheet with custom functionality.

Intermediate

Add Columns Automatically

Create your own "Add Columns" button just like the add rows to the bottom.

Intermediate

YNAB Origin Story From Expense Recorder to $10M a Year Revenue

Learn how YNAB started as a spreadsheet.
Get this and 15 more business stories at BetterSheets.co/started

Learn to Code in Google Sheets, For Programmers

Google Sheets uses a scripting language called Google Apps Script, which is based on JavaScript. If you know how to code in JavaScript, you'll find Google Apps Script very familiar. To get started, open a new Google Sheet and go to the "Extensions" menu, then click "Apps Script".

Intermediate

IMAGE()

Build a License Key Generator and API in 20 Minutes

How to leverage Apps Script to create an API in less than 20 minutes. Create a license key for use in your own apps or as a cloud based API service. We'll create the API using Apps Script and the front end system using a basic Carrd page. Also I'll show you how to test your API in Postman, a free api checker web app.

Advanced

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

Count Merged Rows

Count the number of cells or rows in a merged cell. This is a quick little code you can add to your sheets with the onOpen code.

Intermediate

Saving OpenAI API Calls inside of Google Sheets

Copy text output and input into a google sheet from your OpenAI API calls. Great way to save AI text into a sheet or start to create your own AI writer, or even clone ChatGPT

Intermediate

Expense Tracker Template with Data Entry Form Inside Sheets

Create a data entry form for an expense tracker. Simple dashboard too with sum and sum between two dates.

Intermediate

SUM() FILTER() IFNA()

How do I prevent people from sharing my spreadsheets by making a copy?

A video I did summarizing the 3 things you can do to help people who share your sheet, not do it, or at least get some value from it.

More info on the course: sellingspreadsheets.com

→ Get OnlySheets

Beginner

Create a Public Sheet and Private Sheet: Using ImportRange()

Stick around after the 1st portion of the video for bonus content.

Intermediate

FILTER() IMPORTRANGE()

Make AI-generated Poems Based on Name

Create simple poems based on someone's name with AI.
AI Apps Script Code here: https://bettersheets.co/snippets/updated-open-ai-model-to-omni

Intermediate

Build a Book Recommender with AI in Google Sheets

Create an Email form that sends a few books to AI and gets back a book recommendation. Build the backend in Google Sheets Apps Script while using Carrd to easily make an online form.

Advanced

How to Create AI Images From Google Sheets

Use the Open AI API and Dall-e-3 to create image in Sheets

Intermediate

Activate A Certain Sheet When Opening a Spreadsheet

Create a short function that runs every time a spreadsheet file is open. Redirects the user to the START tab. You can use this to direct anyone opening your file to a specific tab you want them to start on.

Intermediate

Built a Cookie Clicker Clone in Google Sheets

I built a clone of Cookie Clicker, live on YouTube. Watch the full 1 hour live stream here.

In this video I update it a bit, and show off that it works!!

Learn how to build trigger builders and use user properties to store data you don't want a user to change (easily)

Advanced

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

Build a Visual Clock

I'll show you how to create a visual clock in your Google Sheet using conditional formatting.

By following a few simple steps, you'll be able to see the progress of each hour throughout the day.

No manual updates required! I'll guide you through setting up the custom formula, applying it to the desired range, and making it work for multiple columns if needed.

Plus, I'll share a tip on how to reverse the colors if you prefer to track the remaining time instead.

Let's get started and make your Google Sheet even more efficient!

Intermediate

TIMEVALUE() NOW()

Create a Tracking Number Fetcher with Google Sheets and Google Sites

Build a tracking number google site with Google Sheets as a backend.

Advanced

Create New Worksheet When Google Form Submitted

Automate copying a template for new form submissions with user data inserted into the new sheet.

Advanced

Perfect Use of AI in Google Sheets (Categorize Tasks)

Explore how to use AI for task categorization in Google Sheets, from setting up the environment to using a pre-made code template. Watch as we walk through the process, from generating an API key to fine-tuning the prompt for effective categorization of work and home tasks.

Final code is available in the sheet below. And the original template code is available here:
https://bettersheets.co/snippets/updated-open-ai-model-to-omni

Intermediate

Quickly Integrate AI and Google Sheets

Get the code here: https://bettersheets.co/snippets/openai-api-prompt-and-response

Intermediate

Use Random Quote API in Google Sheets

Learn how to add random movie quotes and famous quotes to a Google Sheet. We'll use RapidAPI to get the code and just have a little bit of editing to the code to be able to use it in Google Sheets.

Intermediate

Build Your Own PROPER() Custom Apps Script Function to Capitalize Each Word

There's something wrong with PROPER() the google sheets function. Let's fix it by customizing our own TitleCase() function inside of Apps Script.

Intermediate

PROPER()

Build Your Own AI Writer in Google Sheets

Create your own AI writer with these google sheets tips and tricks and code.

Advanced

SUBSTITUTE()

Create Your Own NIGHT Mode (like PRIDE)

Create easter eggs in your sheets.

Conditional Formatting Intermediate

AND()

Simple Inventory Management Automations

Create a few simple automations like email notifications and low stock alerts.

Beginner Intermediate

ISBLANK() IF()

How to Make Better Lead Magnets

Learn how to make better lead magnets from Google Sheet checklists. Great for marketers and solo operators trying to get more leads, more customers, more clients.

Beginner

IF() HYPERLINK()

Restrict Access to a Cell if Another Cell is Blank

Having trouble with ppl filling in cells before other cells?

Data validation Beginner

NOT() ISBLANK()

Mr. Beast Renamed My YouTube Titles

I need help to supercharge my YouTube channel! Are you struggling to find the best strategies to boost your YouTube channel's performance too? Let's see if Mr. Beast can help.

Advanced

ROW() INDEX() JOIN()

Ultimate Prompt Writer and Prompt Rater

Create a chat interface inside of Google Sheets using GPT-4. Insert rows as prompts get written. This sheet will help us ultimately write better prompts. We can actually tell the difference between what we're doing to get good vs bad response from the prompts.

Data validation Advanced

IFERROR() FILTER()

How To Change Date Format Automatically

Create automations to change date format based on the format you want, inside your sheet.

Advanced

Turn Titles Into Lower Case Hyphened Slugs

Create a slug maker inside your sheet. We'll take any title with any case, even if it's wrong. Our sheet template will lower case the whole line, and replace any spaces with hyphens. This way we can enter any kind of title we want and get a hyperlink slug out for use in blogs or cataloging.

Beginner

LOWER() ARRAYFORMULA()

Get Instagram Follower Accounts in Google Sheets

I will show you how to create a hack to retrieve Instagram follower accounts from any Instagram page using import XML. I will explain the step-by-step process, including how to identify the XML, split it, and extract the follower account. Follow along and try it out yourself.

Intermediate

INDEX() SPLIT() IMPORTXML()

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()

Create a PR Agency From Scratch

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

Intermediate

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

Run 100 ChatGPTs at One Time

Create a ChatGPT prompt inside a sheet, edit that prompt with a single input 100 times over. In this case we're creating a twitter thread prompt and replacing the topic 100 times. so you can use 1 prompt to run 100 ai calls, and then we go further

We make it better.

We add a checkbox and another prompt to take the output of the 1st prompt and run it again. And we can do that 100 times too. So each horizontal row can be it's own ChatGPT.

You can get the ai Apps Script in this video's sheet or in the sheet connected to the GPT-4 upgrade: https://bettersheets.co/tutorials/upgrade-google-sheets-openai-prompt-to-gpt-4

Intermediate

IF() ISBLANK() SUBSTITUTE()

Build Your Own Net Promoter Score (NPS) Survey on a Web Site

Create an embeddable NPS system on a web page.

Advanced

ROUND() AVERAGE() DCOUNTA()

How to Power Testimonials with Google Forms and Sheets

I show you how I use a Google Form and a Google Sheet to power the testimonials page on BetterSheets. I walk you through the process of collecting testimonials, approving them, and displaying them on the website. I also explain how I implemented the functionality using Apps Script. If you're interested in learning about spreadsheet automation and how to leverage Google Forms and Sheets for your own projects, this video is for you!

And Spreadsheet Automation 101 is a great way to learn most of what I go over in this video.

Advanced

IFNA() FILTER()

Create an Internal Google Sheets Add-on

The entire process to create and publish a Google Sheets Add-on internally to your own domain.

Intermediate

Turn Headlines up to 11! - Update to Spintax Tool

Updated the Spintax tool to allow you to generate Spintax. Instead of having to come up with it all yourself, you can let AI generate the Spintax for you. Create variations on headlines, or phrases, or emails.

Intermediate

TRANSPOSE() IF() JOIN() CONCATENATE()

How to Make an AI Integrated Freebie Spreadsheet

Get the freebie here at @abloommedia on TikTok or on Abloommedia.com
Sorry no sheet available even for members. Get the AI code in the video mentioned: Upgrade AI to GPT 4

Intermediate

IF() ISBLANK()

Duplicate Everything For Each Unique Value

Great use of SPINTAX. Get the Google Sheet Add-on; SPINTAX for free.

Intermediate

ARRAYFORMULA() JOIN() CONCATENATE() SPLIT()

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

UNIQUE() SORT() SUMIF() SUM()

Free Education Expense Template

Get this free education funding template I use myself. I use it and enjoy it. Thought you would too.

FV() SUMIF() YEAR() TODAY() JOIN()

SearchLord: One Sheet to Search Them All

I created a new product called SearchLord. It's free for now and really fun to search multiple sites with 1 key word, or 1 phrase. Free for everyone at bettersheets.co/sheetlord

In this video I add 1 more feature to SearchLord to show you how to use a FILTER() function. And we add a custom menu with a little quick apps script function.

Beginner Intermediate

SUBSTITUTE() ENCODEURL() FILTER() IFNA()

Prompt Parade

Create an epic writing tool to generate text from AI with a parade of prompts. A list of prompts you create and write that can be used over and over again. Or use this template to create your own workbook to sell a sheet of your own prompts.

Advanced

CONCATENATE() JOIN() IF() ISBLANK()

Track Every Edit (Almost)

Create a Log sheet in Google Sheets

Automate Help Desk Ticket Closing

Create a simple automated help desk ticketing system.

Create tickets
Closed dropdown
Calculate time to close
Create dashboard

Advanced

IF() COUNTA() COUNTIF() FILTER() AVERAGE()

Discover Misspelled Duplicates

Discover effective methods to handle misspelled duplicates in Google Sheets using formulas without destroying your data. Search and find duplicates that are spelled differently.

Unveiling the Art of Taming Misspelled Duplicates: A Harmonious Symphony of Google Sheets Tricks and Tips

Embark on a captivating journey as we unravel enchanting secrets in this video guide.

Discover an ethereal dance of formulas that transcends the limitations of Google Sheets' native features, gracefully addressing the conundrum of misspelled duplicates.

Delve into the profound intricacies of the issue, where statuses and names intertwine, inviting chaos into your CRM or meeting records.

Witness the mesmerizing revelation of unorthodox yet elegant techniques that preserve your data's essence without sacrificing its integrity. Unveil the hidden world of the duplicate detector, where rows are harmoniously synchronized, leaving no spelling errors unnoticed.

Prepare to be enchanted by the sublime artistry of equals unique, a symphony of transformation that transforms hundreds or thousands of rows into a carefully curated masterpiece. Immerse yourself in this poetic quest and unlock the mystique of finding truth amidst a sea of missteps.

Beginner

UPPER() ARRAYFORMULA() UNIQUE() SORT() LOWER() +1 more

Build a Case Converter From Scratch

Create a little web app, or a tool inside of Google Sheets that can take any text input and give us the correct case we want. It can do Title Case or Sentence Case. It can do UPPER and lower case as well.

I added a little apps script to it that will check only one of the options. Check out the Radio Button Apps Script in another video.

Intermediate

UPPER() LOWER() PROPER() IF()

User Filter a Google Sheet Database based on Dates, Checkboxes, Dropdown!

Search through and filter data to get what you want, when you want it. Tired of sifting through endless rows and columns? Learn how to filter your Google Sheet database with dates, checkboxes, and dropdowns. Simplify your workflow today!

Beginner

IF() FILTER()

SubSpyHub Subreddit Scanner

I built a subreddit search tool to keep track of subreddits with keywords and interesting conversations.

Intermediate

ISBLANK() IF() HYPERLINK() SUBSTITUTE()

Build Your Own Free Domain Availability Checker

Built a Domain Availability Checker in Google Sheets. You can build your own with the code provided. Use RapidAPI and Domainr.com to get an APIEKY for your own free checker.

Learn how to integrate sheets with a TLD Availability API.

Advanced

IF() ISBLANK() FILTER() ARRAYFORMULA()

A Few New Spreadsheet Business Ideas

Learn how to import DropCatch data with 100,000 domains into a Google Sheet. Find out how to get a filtered list of domains with sheet in them. And how to generate ideas of what to build based on these found domains.

Leveraging Expired Domain Names for Google Sheets Business: The speaker discusses using expired domain names to create and sell Google Sheets templates or tools. He demonstrates how to find domain names related to 'sheets' and suggests creative business ideas around them.

Importing and Analyzing Data in Google Sheets: The process of importing CSV data into Google Sheets and manipulating it to find specific information (like domains containing the word 'sheet') is showcased. This highlights the versatility of Google Sheets in handling and analyzing data.

Idea Generation and Business Opportunities in Google Sheets: The speaker, Andrew Kamphey, provides several examples of how to generate business ideas using Google Sheets. He suggests various niches like WordPress-related spreadsheets, balance sheets for accountants, and even educational tools like math workbooks, demonstrating the wide range of potential applications for Google Sheets in various domains.

Intermediate

FILTER() ARRAYFORMULA() LOWER() IF() IFERROR() +1 more

5 Ways to Create Coupon Codes | Create UUIDs

Generate Coupon Codes with 5 Levels of Difficulty - From Copy-Pasting to Advanced Google Sheets Formulas. Get up to thousands of unique codes easily! Watch now for coupon mastery inside of Google Sheets.

RANDBETWEEN() DEC2HEX() CHAR() MID()

Study Better With Google Sheets

Made Ali Abdaal's study google sheet better.

Beginner

VLOOKUP() GOOGLETRANSLATE() INDEX() RANDBETWEEN() COUNTA()

I Built a SEO Meta Description Writer

Unlock the Secrets of SEO Meta Descriptions! Learn how to craft compelling meta descriptions using AI and Google Sheets. Boost your website's visibility and engage your audience. Dive into the world of effective SEO writing now!

Advanced

IF() ISBLANK() IMPORTXML() INDEX() REGEXMATCH() +1 more

Send a Daily Email with Inspiring Quote - A Little Pick Me Up

Created a daily email with a motivational quote in the subject.

Intermediate

ARRAYFORMULA() RANDBETWEEN() LEN() IF() COUNTA()

Daily Writer's Word Count Tracker

Walk through creating an awesome automatic word count tracker that's easy to use and motivates the writer to keep going. With AI generated quotes from famous writers, along with simple formulas to generate states along the way.

Intermediate

TEXT() ROUND() CONCATENATE() TODAY() SUM() +1 more

Access Free API's with Google Sheets

Get Kanye Quotes, Hogwarts Houses, Public Holidays, and more fun with API's in this 1 hour dive into Free APis available online and accessible in Google Sheets.
API's here: freepublicapis.com

Intermediate

IF() ISBLANK() IMAGE() COUNTIF()

Facebook Ads Mockup Generator

Create a simple facebook ad mockup with image and primary text in a google sheet. Get character count too!

Beginner

IMAGE() LEN()

Create a ChatGPT Cheat Sheet Spreadsheet

Walk through step-by-step going from a blank sheet to an AI powered prompt engineering cheat sheet of a spreadsheet.

Watch the Upgrade to GPT-4 video to see the differences between GPT-3 and GPT-4 Apps Script

Intermediate

SUBSTITUTE() IF() SWITCH() ISBLANK() CONCATENATE() +2 more

Find The Most Common Word(s)

Find out which words in your sheet are the most common. Highest count of each individual word.

Intermediate

Send Daily Email Updates

extending Google Sheets in a really fun way. We're gonna be sending emails. I have had literally two people in the past week and a half ask me for this and I answered their question very specifically, but I wanna generally reach out to everyone here, give everyone the opportunity to learn this.

Advanced

Better Sheets Videos Checklist

How to create a video checklist. Create a sheet with check boxes that you check off to mark the videos as seen. Great for those creating lead magnets or checklist digital products. Enables you to create a video course without having to download/upload any videos. Your users can keep track of their progress and get all the benefit of your knowledge.

Data validation Beginner

FILTER() SORT() SPARKLINE() COUNTIF() COUNTA() +1 more

Create a Course Outline in Google Sheets

Wanted to share with members this course outline I am using for my own course making process. I outlined the course then added a bunch of cool little stats to help see my progress and keep me on a certain pace of video creation.

Beginner

REPT() IF() ISBLANK() CONCATENATE() COUNTA() +4 more

Announcing Sell Daily and How I Built Sell Daily

Send daily emails to yourself to master sales every single day. 100% completely free for Better Sheet members.

Beginner

ROUND() HYPERLINK() IF() MATCH() INDEX() +3 more

Hold a Giveaway Raffle in a Google Sheet

Get a random winner from a list of names. Also great to randomize tasks to do.

Create a Branded Lead Magnet from Qualitative Data

Find out how to turn some data you can copy/paste from the web into a branded lead magnet for yourself.

Check out Josh's Tweet about the sheet.
and check out his Podia.

The video shows the importance of adding personal touches to a Google Sheet to connect better with users. It explains how to analyze the sheet's data to find trends and best practices for website content. Lastly, it discusses ways to share the sheet widely while still giving credit to its creator.

Intermediate

LEN() ROUND() COUNTA() COUNTIF() SPLIT() +7 more

Every Locale Listed in Google Sheets and a Tool to Save Your Sanity

How to change your locale and figure out what changing locales means for your sheets.

Create A Video Course in a Google Sheet | LMS in a Google Sheet

Set up a list of video links, and a checklist for others to use.

Conditional Formatting Data validation Intermediate

IF() COUNTA() COUNTIF() SPARKLINE()

ChatGPT Clone in Google Sheets Part 2

We fix the problem of OpenAI's API not remembering our last questions. And we label the text as Human and AI. I also add an archive Chat and new Chat function to create a new chat fresh.

Advanced

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.

Create a Timer with Apps Script

Create a start time and end time and duration of that, with a little bit of Apps Script.

Intermediate

ISBLANK() IF()

1 Simple Formula to Make Writing Tweets Easier or Make $1,000

Create a hook writing sheet with SUBSTITUTE(). Create an engine to write tweet upon tweet upon tweet. Bundle up 100 hooks/formats and sell it. Go ahead, make sweet tweets in a sweet sheet.

SUBSTITUTE()

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

Redirect a Domain to a Google Sheet

Learn how to redirect a domain to a google sheet. Set up subdomains and MVPs of sites easily.

Beginner

Twitter App Clone in a Google Sheet

I built a twitter clone in Google Sheets

Beginner

Create a Stop Watch in a Google Sheet

We'll create a stop watch from scratch. Including Apps Script. What it will do is when you click a button (a checkbox) in a sheet, the script on every edit will add a start or a stop time, then add another time and calculate the duration.

Find "Entry Number" for Bookmarklet

Followup to the Bookmarklet video. To help you find the entry number for each form field.

Added Categories to 100 Twitter Templates Template

Add one more feature to the 100 Twitter Templates tool.

Intermediate

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!

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.

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()

Create a Podcast Advertising Calculator

Build from scratch a calculator to figure out podcast advertising rates.

Announcing AtomicSheets.com

AtomicSheets.com for 10 Free Elements Members get it free at: https://bettersheets.co/products

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

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.

Embed a Headline in a Website from Google Sheets

One of the most requested videos, Ever. How to put data, a number, some text, from a Google Sheets onto a website without having to embed the entire Google Sheet. This is the way!

Advanced

SUBSTITUTE()

Add Click Tracking To Your Google Sheets | Bitly in a Google Sheet

Create a click Edit: Google changed how the redirect is handled. It no longer automatically goes forward, so you will need to add a link for a user to click on again to go to the forwarded link.

Advanced

HYPERLINK()

Create a Trello Board with Transpose Formula in Google Sheets

Use Transpose() to create a web-based, Kanban style, list-making application inside your Google Sheet! Learn how to display tasks and to-do’s in vertical categories.

World Peace in Google Sheets

Combining GoogleTranslate() and DetectLanguage() to figure out what a language is without having to know the two letter codes. And adding a dropdown range to make it easier to find the language you want to translate to. What a great way to solve the frustrating world of International language!

Beginner

VLOOKUP() DETECTLANGUAGE() GOOGLETRANSLATE()

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

FILTER() UPPER() ARRAYFORMULA()

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

IF() COUNTIF()

How To Improve: 1,000 Business ideas: Business Idea Generator

Revolutionize Your Business Ideas with This Simple Template - Get Inspired in Minutes!

Advanced

Building the Newsletter Geeks Virtual Mall

We're gonna create another virtual mall, and in this one we're gonna make it for newsletters

Advanced

CONCATENATE()

Headline Generator: Add Dropdowns

Create a headline generator inside Google Sheets. Add dropdown menus to make the generator easy to us.

Add Pics to Marketplace in a Google Sheet

Add pictures to your marketplace inside a google sheet. Might be great for garage sales, and community events.

Beginner

MATCH() FILTER() IMAGE() INDEX()

Calculate ROAS in Google Sheets

Calculate Return on Ad Spend with a formula combination. Bonus: create a more elegant solution in Apps Script using JsDoc syntax to create an autocomplete native function. We use the formula combination of Concatenate / Round to create the ratio, but in Apps Script we do it a whole lot better.

Intermediate

CONCATENATE() ROUND()

Generate Hundreds of Business Names

Create business names quickly with this Google Sheets trick.

Create a Headline Generator

Learn to create lead magnet or sellable worksheets for your business. Included are more topic ideas so you can take this template and run with it.

Create Instant QR Codes

Learn how to use a free Google API to create QR codes in sheet to any URL. And we'll learn how to make them magically appear as you enter domains.

ARRAYFORMULA() IF() ISBLANK() IMAGE()

Add Team Members to the Quick CRM

We have a question from Rupesh about the quick CRM. He wants to add some team members.

Intermediate

FILTER() IMPORTRANGE()

Create an Email Campaign Stats Calculator

Take your email marketing to the next level with our Google Sheet Campaign Stats Calculator. Analyze open rates, click-throughs, and conversions, and make data-driven decisions to improve your campaigns. Build a sheet from scratch. We're going to build a calculator, with some functions and some custom functions in apps script. We'll also design the sheet like a funky dashboard.

Advanced

CONCATENATE() ROUNDDOWN() UPPER()

That Viral Growing Plant Progress Chart

Create a growing flower pot from checkboxes with this bountiful formula combination. Members get free access to the sheet in the video.

Data validation Beginner

SWITCH() IMAGE() COUNTIF()

Adding a Foodcourt to Doc's Virtual Mall | Sheet Improvement!

A fun way to make a sheet look like a mall.

Advanced

IFERROR() INDEX() HYPERLINK() CONCATENATE()

Sheet Improvement: Better Band Bureau Better Schedule

A few tips: Delete extra columns and rows to improve readability, change the colors and fonts to incorporate branding, and adjust the sheet to promote the Better Band Bureau podcast more.

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

Build a Domain Grader

Create a way to grade the quality of a domain based on many different votes and inputs and qualities. Like measuring the length and ranking the results.

COUNTIF() ARRAYFORMULA() COUNTA() LEN() SWITCH() +1 more

How To Track Crypto Prices

Get crypto prices into a Google Sheet.

Intermediate

GOOGLEFINANCE()

This Seems Like Automation

4 formulas that make your sheets feel automated. Start with user-started actions, and get automated data flowing in other parts of your sheet.

IF() FLATTEN() TRANSPOSE() UNIQUE() IFERROR() +1 more

Insert Random New Quotes in Your Google Sheets (Every Edit/Open)

Discover the Secret Formula to Insert a Quote Randomizer in Your Sheet! | Learn how to use a simple one-formula combo to get a random assortment of quotes in your sheet. Change the quote every time you open the sheet. Watch now and amaze your friends!

How to insert a quote generator or a quote randomizer inside your sheet. Without using Apps Script.

Beginner

ROUND() COUNTA() RAND() INDEX()

Building a Year Progress Clone

Create a year progress bar to see how much of the year is gone. Great motivational chart to watch count up to 100%.

SPARKLINE() TODAY() NOW() EOMONTH() SWITCH() +3 more

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

Make Unsplash in a Google Sheet w/ BuyMeACoffee - Part 1

Create a photo search site inside with Google Sheets. Using this template you can empower users to: Enter a search term and get an image without leaving the sheet! And learn how to monetize this Google Sheet.

Create a CPM Custom Function (Create Better Calculators!)

this is gonna be fun because we get to create a calculator with Apps Script.

Beginner

How to Find Duplicates and create a Duplicate Detector

Create a duplicate detector with a few google sheet formulas.

Beginner

MATCH() IF() ROW() CONCATENATE() COUNTA() +1 more

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

Create a Changelog Between 2 Cells Custom Function | To learn Double For Loop

Learn how to track every change in your Google Sheets with a simple custom function in this video on "What Changed." Discover how to compare sentences, paragraphs, and more with ease. Follow along as we create the function from scratch. Get ready to streamline your editing process!

We code a little apps script to figure out the difference between two cells.

Advanced

How to Use Smarket

This video covers how a user would use Smarket to list items to be sold and then unlist those items to be sold. It uses two different forms for the listing and the unlisting. The key connection is that you use a unique number, or a unique text when entering the item to be sold. Then use that item to delist it once it's been sold. Also you can wait 7 days, and the item will be unlisted.

Beginner

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

OR() NOT() IFS()

Deep Inside Dark Habits Google Script

Go inside this apps script and sheet. See how it's designed and created.

ARRAYFORMULA() ISBLANK() TRANSPOSE() FILTER() INDEX() +3 more

Benoit Asks: How to Convert Case

How can I use this function, lower, upper, or proper as a conditional formatting? And then the other question is, how can I use this to apply on a bunch of cells without having to double the cells?

PROPER() UPPER() ARRAYFORMULA() LOWER()

Make a Better Template - Ambassador Nomination Template

Create a nomination or voting template. Looking to build better Google Sheets? Andrew from Better Sheets is here to help! Join his membership to access exclusive videos and email support. In this video, Andrew takes a closer look at a Google Sheet template by Tableau ambassador Adam Miko, offering tips and tricks for a better user experience. Save time and effort with Andrew's easy copy-and-paste method. Want more? Join his membership today and start building better Sheets!

Search for Photos in a Google Sheet by Keyword

Add one more feature to our Photo search inside of Google Sheets.

Beginner