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
Run a Micro HARO for Your Niche Out of Google Sheets
Build a niche version of Help a Reporter Out in Google Sheets: a media contact database, a pitch intake form, and press examples.
Sell a Product Hunt Launch Checklist Built in Google Sheets
How to build a step-by-step Product Hunt launch checklist in Google Sheets, load it with tactics and interviews, and sell it to founders before launch day.
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!