Google Sheets Tutorials · Better Sheets

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?

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

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

Advanced

How to Create AI Images From Google Sheets

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

Intermediate

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

Email Certain Department Based on Google Form Entries

Message a certain department when google form is submitted.

Advanced

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

Member Asks: How do I calculate from a set of Form entries?

Use arrayformula to deal with Google form entries on a sheet. Even as they keep getting added.

ARRAYFORMULA()

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

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

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

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

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

3 Ways to Count in Google Sheets

The video explains three ways to count cells or information in Google Sheets: using the Explorer, using the COUNT function, and using the COUNTALL function. The Explorer is a tool located at the bottom right of the screen that allows you to quickly understand your data and find the count of items in a column. The COUNT function allows you to count the number of cells that contain numbers in a range of cells, while the COUNTALL function counts all the cells in a range, including those that contain formulas or are blank. The video also mentions other functions such as SUM and UNIQUE

Beginner

COUNTA() COUNTIF()

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!

Embed a Number in a Website from a Google Sheet

Ever wanted to display some data from a google sheet on your site? Without using 3rd party tools here is the javascript, html and the sheet you will need. and step by step instructions on how to use it.

Advanced

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

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

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

Headline Generator: Add Dropdowns

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

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.

Ali Abdaal's Google Sheet | Year at a Glance

Ali gave away a free Google Sheet Template. In this tutorial I step through making it better, with better fonts, and colors. As well as making it more branded to share Ali's brand message better as the sheet gets copied and used, and shared. Great tutorial for those wondering how to brand your own sheets. Make your own lead magnets, and share your brand's message via Google Sheets.

Beginner

Displaying items 21-40 of 290 in total

TAGS

FORMULAS

TOPICS

290 Google Sheet Tutorials

An exclusive library of Google Sheet Tutorials

Better Email Form on Google Sites

Why can't people fill in my Google Form?

Create New Worksheet When Google Form Submitted

How to Create AI Images From Google Sheets

Make AI-generated Poems Based on Name

Email Certain Department Based on Google Form Entries

Generate Google Search Phrases

Member Asks: How do I calculate from a set of Form entries?

Manage Your Wedding Guest List in Google Sheets

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

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

3 Ways to Count in Google Sheets

Quickstart Tutorial OpenAI API in Google Sheets

Embed a Number in a Website from a Google Sheet

Search for Photos in a Google Sheet

How to Use Smarket

Learn to Code in Google Sheets, For Programmers

Headline Generator: Add Dropdowns

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

Ali Abdaal's Google Sheet | Year at a Glance