Guides for Sheety work
Tips & tricks? Who needs tips and tricks? You just want your sheet to do something it isn't doing now. These aren't just hot tips. They're the long guides I write when a problem is too annoying to just say "here's a quick fix."
Free tutorials on YouTube
Step-by-step videos on Google Sheets. All free at youtube.com/bettersheets.
Watch on YouTube
Latest posts
Package Niche Mental Models as a Sellable Google Sheet
Turn five years of industry experience into a Google Sheet of mental models for one specific audience, and sell it to the people just entering your field.
Turn Business Book Summaries Into a Google Sheets Product
Read a lot of business books? Package 100 summaries for one specific audience in Google Sheets, then sell the sheet or earn from affiliate links inside it.
Sell 100 Pre-Written Twitter Templates in a Google Sheet
How to write 100 fill-in-the-blank tweet templates, package them in Google Sheets, and sell them to founders and marketers who hate the blank box.
Build a Creator Command Center in Google Sheets and Sell It
How to build a creator command center in Google Sheets, seed it with templates and tools, and sell it to newsletter writers, YouTubers, and podcasters.
Keep 0007 as 0007: a Google Sheets handoff for existing PDF forms
A guest-post walkthrough for keeping vendor IDs, postal codes, and amounts as exact text when moving data from a Google Sheets register into an existing PDF form.
How to Use Google Sheets as a Website Database
Did you know you can use Google Apps Script to turn a Google Sheet into a free, auto-syncing database for your website? This guide shows you exactly how to set it up. You’ll prepare your spreadsheet, write a few lines of code and publish your site. Don’t worry if you’re not a developer, we’ll walk you through it. Why Use Google Sheets as a Database? For small projects, Google Sheets offers many advantages over traditional databases: * Free hosting and storage * Easy to edit data without...
Build a CRM in Google Sheets in Under 20 Minutes (No Code Needed)
If you’ve ever felt overwhelmed trying to manage relationships, sales leads, outreach campaigns, or even press contacts—this video is going to be a game-changer. In it, you’ll learn how to build your very own CRM (Customer Relationship Manager) entirely inside Google Sheets. It’s fast, functional, and flexible. No need for clunky software, expensive subscriptions, or unnecessary features—just a clean spreadsheet that does exactly what you need it to do. We start with the basics: names, ema...
Automate Your Expense Tracking in Google Sheets: A Step-by-Step Guide
You can turn a manual chore into an efficient, automated workflow, allowing you to focus on your financial goals. As we usher in a new year, it's time to get our finances in perfect order. There's no better way to start than by automating our expense tracking in Google Sheets. This guide will walk you through some incredible automations that will transform your manual entries into a smooth and efficient process. Set Up Your Expense Sheet Transform negative to positive values by refining y...
Protect Your Formulas from Accidental Deletion in Google Sheets
Ever spent hours crafting the perfect formula in Google Sheets, only to accidentally delete it? It's a frustrating experience that can derail your productivity. Fear not! In this guide, we'll unveil some clever tricks to safeguard your hard work.
How To Make That Viral Growing Plant Progress Chart
Imagine checking off tasks and seeing a cute little plant sprout right before your eyes. That's exactly what we're going to create today!
Word Tracker and Progress Tracker in Google Sheets
Ever dreamed of having a personal writing assistant right there in your Google Sheets? Imagine tracking your word count, setting goals, and watching your progress grow – all without leaving your favourite spreadsheet app. Well, your dream is about to come true! In this post, we're going to show you how to create your very own word counter and goal tracker using Google Sheets. It's super easy to set up, completely customizable, and perfect for keeping you motivated on your writing journey. L...
5 Ways to Combine Names in Google Sheets
Ever found yourself stuck in a loop of copying and pasting names in Google Sheets? Let's face it, it's a task that can feel like a never-ending chore. But fear not, because I've got your back! So, we're diving into the world of Google Sheets and exploring five super-easy ways to combine first and last names into a single cell. No more manual labor, no more headaches. Imagine being able to whip up a list of full names in seconds, instead of spending hours on it. Sounds like a dream, right? We...