Topics > Build Your Own Tools

139 Tutorials

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:
  1. Budget Tracker: Use Google Sheets to track your monthly expenses, categorize them, and calculate your monthly budget.
  2. Project Management Tool: Create a project management tool using Google Sheets to track project progress, assign tasks, and monitor deadlines.
  3. Inventory Management Tool: Use Google Sheets to track inventory levels, monitor stock levels, and manage purchase orders.
  4. Employee Time Tracker: Use Google Sheets to track employee working hours, overtime, and vacation days.
  5. 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. 

139Tutorials

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).
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
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.
Unlock the Power of OpenAI: Create Ultimate GPT Prompts for Seamless Interaction! Discover the Formula Inside, Explore APIs, and Boost Productivity. Watch Now!
Create the Apps Script to create a new sheet from some data inside your sheet. Script included in the sheet below.
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! 
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.
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.
Create a sheet that can trash itself. It can delete itself instantly or on a timer. Maybe in 24 hours or a month.
Just in time for the holidays. Great for making promotion calendars to reveal promotions day to day.
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.
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.
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.
Quickly make a daily email to myself with a motivational quote.
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.
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..
Create automatic notifications when a project is assigned, a project needs review. And move a project from one tab to another tab.
Discover the Ultimate Google Sheets Hack! Transform Text with Title Case Formula. Say Goodbye to 'Proper' and Hello to Easy Capitalization. Find Out How! 
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.
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.
Create your own "Add Columns" button just like the add rows to the bottom.
 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
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.
Build a simple function that deletes undone items in our checklist.
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
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
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".
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.
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.
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
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)
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

Stick around after the 1st portion of the video for bonus content.
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.
Automate copying a template for new form submissions with user data inserted into the new sheet.
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.
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
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! 
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.
There's something wrong with PROPER() the google sheets function. Let's fix it by customizing our own TitleCase() function inside of Apps Script.
Create your own AI writer with these google sheets tips and tricks and code.
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.
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.


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.
Having trouble with ppl filling in cells before other cells?
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.
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.
Create an embeddable NPS system on a web page.
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.
The entire process to create and publish a Google Sheets Add-on internally to your own domain.
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.
Go from nothing to a working PR agency. Capture sites, and Send email via script
Created a tournament template with 4 automations. So tabs can be copied by a laptop, ipad, or mobile.
Create buttons on your Google Site to get an NPS, or Net Promoter Score directly to a Google Sheet.
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
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.
Create a Log sheet in Google Sheets
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.
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.
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.
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!
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.
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.
Made Ali Abdaal's study google sheet better.
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.
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
Created a daily email with a motivational quote in the subject.
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! 
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

Create a simple facebook ad mockup with image and primary text in a google sheet. Get character count too!
Find out which words in your sheet are the most common. Highest count of each individual word.
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.
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.
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. 
Send daily emails to yourself to master sales every single day. 100% completely free for Better Sheet members.
Get a random winner from a list of names. Also great to randomize tasks to do.
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.
How to change your locale and figure out what changing locales means for your sheets.
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.
Create a start time and end time and duration of that, with a little bit of Apps Script.
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 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.
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.
Learn how to redirect a domain to a google sheet. Set up subdomains and MVPs of sites easily.
I built a twitter clone in Google Sheets
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.
Followup to the Bookmarklet video. To help you find the entry number for each form field.
Add one more feature to the 100 Twitter Templates tool.
You can easily add your own links and improve your bio for free.
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!
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.
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.
Build from scratch a calculator to figure out podcast advertising rates.
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 
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.
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!
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.
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.
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!
Make a marketplace where sellers and buyers do not have to have edit access to a sheet.
Create a pastel colored hunting game, just in time for Easter.
We're gonna create another virtual mall, and in this one we're gonna make it for newsletters
Revolutionize Your Business Ideas with This Simple Template - Get Inspired in Minutes! 
Create a headline generator inside Google Sheets. Add dropdown menus to make the generator easy to us.
Add pictures to your marketplace inside a google sheet. Might be great for garage sales, and community events.
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.
Create business names quickly with this Google Sheets trick.
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.
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.
We have a question from Rupesh about the quick CRM. He wants to add some team members.
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.
Create a growing flower pot from checkboxes with this bountiful formula combination. Members get free access to the sheet in the video.
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.
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.
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.
Get crypto prices into a Google Sheet.
4 formulas that make your sheets feel automated. Start with user-started actions, and get automated data flowing in other parts of your sheet.
Create a year progress bar to see how much of the year is gone. Great motivational chart to watch count up to 100%.
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.
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.
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.
this is gonna be fun because we get to create a calculator with Apps Script.
Create a duplicate detector with a few google sheet formulas.
Exclusive video only for Better Sheets members. This is, uh, troubleshooting your click tracking web app or slash sheet.
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.

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.
Let's code a Radio button that turns off all checkboxes except the one clicked.
Go inside this apps script and sheet. See how it's designed and created.
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! 
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?
Add one more feature to our Photo search inside of Google Sheets.