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
Sell a Swipe File of Facebook Ad Examples in Google Sheets
Build a Facebook ad examples swipe file in Google Sheets with fillable ad formats and a team review tab, then sell it to marketers and small business owners.
Is Scraping Google Maps Legal? What Google's Own Terms Say
Is scraping Google Maps legal? I read Google's terms: what they say about scraping, what you can store from the Places API, and for how long. Not legal advice.
List of Local Businesses: How to Make One for Any Town
Directories only show who joined. Here's how to make your own list of local businesses for any town, with phone, website and reviews: 142 Boise coffee shops.
The History of AI in Google Sheets: From Explore in 2015 to Gemini in 2026
Google Sheets has had AI since 2015. People wired GPT-3 into Sheets before ChatGPT existed. Here's the whole timeline, from Explore to Gemini, with Excel and the add-ons alongside.
Best AI for Spreadsheets? What Every Spreadsheet AI Benchmark Says in 2026
I read every spreadsheet AI benchmark from the last year. AI now beats the human score on the famous one, and still almost never builds a pivot table right.
Google Sheets CRM for Leads: Pipeline, Follow-Ups, No Repeats
A simple Google Sheets CRM for local leads: the leads come in from Google Maps, contacted rows turn green, and five columns turn it into a pipeline.
How to Use the Wikipedia Pageviews API in Google Sheets
The Wikipedia pageviews API is free and needs no key. Here's how the URL works, a small Apps Script function that pulls monthly views into Google Sheets, and a no-code template if you'd rather skip it.
Sell a Digital Media Workflow Template Made in Google Sheets
Build a digital media workflow template in Google Sheets with stages, deadlines, and automated email reminders, then sell it to creators and marketers.
Free Google Maps Scraper in Google Sheets (That Doesn't Scrape)
A Google Maps scraper's job in Google Sheets, without scraping: Google's Places API, your key, up to 1,000 free searches a month. 98 plumbers, not 20.
How to See Wikipedia Page Views Over Time
Every Wikipedia article's page views are public. Here are three ways to see them, from the last 30 days to five years of monthly history in a Google Sheet.
Sell a Digital Course Creator Checklist in Google Sheets
Build a digital course creator checklist in Google Sheets covering outline, video, audio, graphics, freelancers, and marketing, and sell it to creators.
How to Change Border Colors in Google Sheets with Apps Script
Recolor only the borders you already have in Google Sheets, with a hex code prompt, a reset button, and a custom menu. The real Apps Script from Big Year Premium, explained step by step.