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
Search Wikimedia Commons From Google Sheets With a Custom Function
Use the free Wikimedia Commons API in Google Sheets: a short Apps Script function that returns free images with license, author and thumbnail.
2027 yearly planner in Google Sheets for goals
Plan 2027 at a glance in Google Sheets with a free yearly calendar, editable goals, print options, and Premium layouts for more planning views.
Outscraper Alternative: A $10 Google Sheet on Google's Own API
An Outscraper alternative for local leads: a $10 Google Sheet that uses Google's official Places API with your own key and up to 1,000 free searches a month.
2027 Google Calendar Template: Free Printable Year in Google Sheets
Want a 2027 calendar you can print from Google? This free Google Sheets template shows all 12 months on one page, editable, printable, with your own holidays.
Lead Tracking Spreadsheet: The Columns I Use in Google Sheets
A lead tracking spreadsheet template for Google Sheets: the 3 tabs, the 17 columns, what each one is for, and formulas for follow-ups and coverage.
Habit Tracker Ideas: 30 Things to Track (and a Few to Stop)
30 habit tracker ideas, grouped by what kind of tracker they need: yes or no habits, habits to break, and habits that are really numbers. With the free Google Sheet for each.
How to Track a Streak in Google Sheets (Break a Bad Habit in 14 Days)
A streak tracker in Google Sheets for the habits you want to stop. Tick a box on every clean day, and a REPT formula draws your streak toward a 14 day goal.
How to Make a Habit Tracker in Google Sheets (One Click a Day)
Build a habit tracker in Google Sheets that fills in a year of squares, one click a day. A big checkbox, a DATA tab, one IF formula and a LOG tab. Or copy the free template.
Free Holidays API: Get Public Holidays With No Key
A free public holidays API with no key and no sign up. One URL gives every holiday for 204 countries. Here's how to call it, and the easier way.
How to Get Public Holidays Into Google Sheets With a Free API
Type a country and a year, get every public holiday in Google Sheets. Free API, no key, 204 countries. Plus long weekends and working days.
How to Find Evergreen Content Topics With Wikipedia Page Views
Write about what people keep reading, not what spiked once. Here's how to use five years of free Wikipedia page views in Google Sheets to pick blog, video and newsletter topics that last.
Turn a Fitness Planner in Google Sheets Into Passive Income
Build a Google Sheets fitness planner that turns a few lifestyle answers into daily workouts and email reminders, then sell it or use it as a lead magnet.