539Google Sheet Tutorials

'll show you a game-changing Google Sheet formula that will make your day, especially if you're into bulk publishing and chat GPT. With this formula, you'll be able to insert lists of keywords into prompts effortlessly. I'll guide you step-by-step on how to set it up and use it effectively. Get ready to become faster, better, and more efficient in your publishing tasks. Let's dive in!

10 Things I Hate About Your Spreadsheets and how to fix them. Here is a list of 10 things you can do today to make your sheets more lovable.

The 10 Things I Hate about your Sheets

I start off this video with the idea to show beginners how to automate emails in their sheets, and also add a little bit of AI. Then half way through the video I have a question... can I write AI and then email myself everyday? We try to do that. So you get to see me struggle, and log, and debug. It's quite intense.


Learn more Automation: https://bettersheets.co/courses/spreadsheet-automation-101

Get the AI GPT-3.5 and GPT 4 code: https://bettersheets.co/tutorials/upgrade-google-sheets-openai-prompt-to-gpt-4

Better Sheets members can get the code and the sheet in the video below.

I will introduce you to the power of AI writing in Google Sheets using a tool called Shaman. If you're a blogger looking to take your writing to the next level, this is the video for you. With Shaman, you can unleash your blogging potential by incorporating AI into your writing process.

These are simple spreadsheet hacks you might not know about. Simple interface tricks that knowing about will make your spreadsheet life better.

Learn how Starter Story, and Pat Walls, created a report that is well designed and packed with information.

Get the report at starterstory.com/solopreneur

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.

Are you tired of the default look of your Google Sheets? In this video, I'll show you the ultimate way to revitalize your workspace and enhance your productivity. By changing the background and text color in Google Sheets, you can create a more personalized and visually appealing environment that suits your preferences. Join me as I guide you through the simple steps to achieve a vibrant and eye-friendly spreadsheet experience.

Get Sheet Styles here: https://sheet-styles.bettersheets.co/

Learn a cool trick you can do with the ArrayFormula. If you don't know what the ArrayFormula does, I show you how to use it in the first few minutes of this video.  Then show you how to use it better.

Sit back and enjoy this comprehensive tutorial on how to create a live message in Google Sheets. In this video, we dive deep into the process of live message creation, providing step-by-step instructions and practical examples. Whether you're a beginner or an experienced user, this tutorial will empower you to unleash the full potential of Google Sheets.

Welcome to the captivating world of Readable Hex Codes! In this video, we dive into the intriguing realm of colors represented by hex codes. You'll witness the magic unfold as we explore the delightful hues of "Coffee," "Decade," and many more. With a click, we'll reveal the true essence of these hex codes and bring them to life on a Google Sheet.

Create a simple checklist checker that shows us the first unchecked item in a task list.

Learn the Quick Fix! Replace Text with Blank Cell in Google Sheets Hassle-Free. Say Goodbye to Data Glitches. Super helpful when you need to find and replace in google sheets any text.

I'll show you how to set up a super powered checklist that can act like a micro manager. It emails you hourly with the top unchecked item on your To-Do list.

New Tool for you: Fast FAQs. Create a quick 10 question FAQ for any new product or new feature you want. Even great for topics and theories. 
Sheet uses your own API Key from Open AI to power an AI FAQ generator. Then you answer the questions in the sheet. 

Once you've written the proper answers you can publish directly to Ghost, along with FAQpage schema structured data that is optimized for Google.

Wanted to share with you some opportunities where you can optimize your listing and get the most people installing your Add-on.

We did it! The Add-on is approved. You can now go find the Add-on in the Google Workspace Marketplace.

We get our Add-on rejected. Oh no! But wait, stay calm. We'll read the email and see why it was rejected.

After you get OAuth consent screen approval you can go ahead and submit the store listing for review.

We will write our Store listing in this video.