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
Selling on Consignment to Salons and Spas: Pitching a New Razor Kit to 55 Shops in Chattanooga
Door-to-door sales, but digital. If I had a new razor combo pack built for shaving underarms, I'd pitch it to salons, spas and wax studios on consignment. Here are the 55 shops I'd start with in Chattanooga and the message I'd send.
How to Get Your Product Into Salons: Pitching a New Shampoo to 284 Independent Salons in Chattanooga
If I had a new shampoo and wanted it on salon shelves, I'd give salons a free case to use with their guests and sell bottles at the front desk. Here's how I'd find every independent salon in a city, which ones to skip, and the pitch I'd send.
How to Get More Google Reviews for Local Businesses (and Turn It Into a Side Business)
If I were starting a business helping local businesses get more Google reviews, I'd start with the ones that are great but invisible. In Spokane that's 38 dentists rated 4.5 stars or higher with fewer than 52 reviews, when the median dentist has 209. Here's how I found them and what I'd send.
How to Get Commercial Cleaning Contracts: 255 Property Managers and 153 Plazas in Minneapolis
Every guide to commercial cleaning contracts says to go door to door. None of them gives you the doors. Here's the list I'd start with in Minneapolis: 255 property management companies and 153 shopping centers, pulled into one Google Sheet.
How to Get Landscaping Contracts: 255 Minneapolis Property Managers in One Google Sheet
If I were starting a lawn care or landscaping business in Minneapolis, I'd skip homeowners and go after commercial contracts. One list of 255 property management companies, 8 HOA managers and 106 suburban managers, and the message I'd send them.
How to Get Snow Removal Contracts in Minneapolis: 255 Property Managers and 153 Plazas in One Sheet
If I were going after snow removal contracts in Minneapolis, I wouldn't knock on doors. I'd pull every property management company and shopping center in the metro into one sheet, and start with the people who decide about dozens of lots at once. Here's the list: 255 property managers and 153 plazas.
Where to Get Local Leads: Google Maps Showed Me 20 Plumbers, My Google Sheet Found 98
I searched "plumber in Boise, ID" on Google Maps and got a list of 20. The same search run across 42 Boise-area neighborhoods in Local Lead Finder found 98 plumbers, including 25 with fewer than 20 reviews that Maps never showed me.
Local Lead Generation for Web Designers: 1 Search, 225 Dentist Leads
I searched every dentist in the Spokane area with Local Lead Finder, then sorted by rating and reviews. 31 practices are rated 4.8 or higher with fewer than 50 reviews, while the typical Spokane dentist has 209.
How to Build a Local Business List in Google Sheets (142 Coffee Shops in Boise)
One search in Local Lead Finder turned the Boise area into a list of 142 coffee shops, with phone, address, rating, reviews and website for each. Here's the list, how it broke down by town, and what to clean up before you use it.
How to Find Local Businesses Without Websites (I Found 131 Hair Salons in Chattanooga)
I pulled every hair salon in the Chattanooga area into Google Sheets with Local Lead Finder. 131 of 325 list no website on Google Maps, and in East Ridge it's 11 out of 13.
How to Set Up Local Lead Finder: Google Maps to Google Sheets in 5 Minutes
Step by step: put in your Places API key, find every area in your city, search them all at once, and track who you've already messaged. In my test, Gainesville, Florida turned into 69 areas and 74 coffee shops.
How to Get a Google Maps API Key for Free (Step by Step)
How to get a Google Maps API key in Google Cloud, step by step with a screenshot of every screen. The key is free, Places API (New) gives you 1,000 free searches a month, and it's the key Local Lead Finder needs.