Crafting High-Demand Sheets from Scratch. Turn templates into tools to make sellable spreadsheets.
Academy ↓
Hey there stranger!
SECTION 3 - How to Make a Spreadsheet
About this Tutorial
Video Transcript
0:00 In this next section, I'm going to share with you how to make a spreadsheet that you can sell. Technically, we are going to add little interesting automations, little curations, filters, a few formulas, a few Apps Script.
0:15 Don't worry if you've never coded before. I'm going to show you step by step how to add custom functions, formulas to your sheets that absolutely make your branding sing, make your spreadsheets more like tools, and then by the end of this section, we're going to get into automations and at least give
0:31 you the idea as of different types of automations inside of your sheet, in Apps Script, how to create emails. I'm gonna show you literally how to create, and I'm gonna give you the code.
0:41 So in one video, I show you a bookmarklet, which is one of the coolest tools I've ever created and use all the time in Spreadsheet.
0:50 It makes it so easy to scrape websites, and I'm also going to give you the code of how to automate your emails from Google Sheets.
0:58 So you can create automatic reporting, you can create email templates in Sheets, all kinds of cool stuff. You can automate emails from Sheets, so make your, um, add reminders, notifications for users of your spreadsheets.
1:12 I think it's so much fun. I think this is the best, I think this is the best section if you are trying to create a spreadsheet and you're like, what kind of feature can I add?
1:21 to a spreadsheet to really make this feel like a good tool, to make it feel like a good spreadsheet and really use Google Sheets functions and features to their absolute max.
1:31 Uh, in this section we're gonna do that, we're gonna do this very quickly, I'm gonna walk through step-by-step and show you step-by-step how to do it.
1:37 Let's do this, I'm so excited, let's get started.
0:15 Don't worry if you've never coded before. I'm going to show you step by step how to add custom functions, formulas to your sheets that absolutely make your branding sing, make your spreadsheets more like tools, and then by the end of this section, we're going to get into automations and at least give
0:31 you the idea as of different types of automations inside of your sheet, in Apps Script, how to create emails. I'm gonna show you literally how to create, and I'm gonna give you the code.
0:41 So in one video, I show you a bookmarklet, which is one of the coolest tools I've ever created and use all the time in Spreadsheet.
0:50 It makes it so easy to scrape websites, and I'm also going to give you the code of how to automate your emails from Google Sheets.
0:58 So you can create automatic reporting, you can create email templates in Sheets, all kinds of cool stuff. You can automate emails from Sheets, so make your, um, add reminders, notifications for users of your spreadsheets.
1:12 I think it's so much fun. I think this is the best, I think this is the best section if you are trying to create a spreadsheet and you're like, what kind of feature can I add?
1:21 to a spreadsheet to really make this feel like a good tool, to make it feel like a good spreadsheet and really use Google Sheets functions and features to their absolute max.
1:31 Uh, in this section we're gonna do that, we're gonna do this very quickly, I'm gonna walk through step-by-step and show you step-by-step how to do it.
1:37 Let's do this, I'm so excited, let's get started.
Courses
Selling Spreadsheets Course Introduction
What Sucks About Selling Spreadsheets And How to Solve These Problems
SECTION 1 - You Are The Sheet
Coupon Code Maker Updates February 2024 - New Dashboard
How to Make Good Looking Spreadsheets
Curate Google Sheets Easily - Automatic Bookmarklet Maker
Explore Your Spreadsheet Selling Options
What you know matters
Who you are matters
How you think matters
Why you think it matters, matters
Surprising Things about Selling Spreadsheets
SECTION 2 - Your Spreadsheet Blueprint
Easiest Sheet Ever to Sell
Problems Everywhere, and the Spreadsheets that Solve Them
The #1 Mistake Spreadsheet Sellers Make and how to Save People Time
Customer’s Context Is King
The Two T’s: Turn Templates into Tools
Create a Branded Lead Magnet from Qualitative Data
Tracker Tactics
SECTION 3 - How to Make a Spreadsheet
Ask Questions
Quality Curation
Fabulous Filters
Wield Wizardry
Automatic Calculations
Automate Emails
You Must Double Duplicate (If you're selling a sheet you use)
Different Kinds of Automation
How do I prevent people from sharing my spreadsheets by making a copy?
SECTION 4 - Spreadsheet Sales Mastery
Write The Sales Page
The Strangest Secret to Selling a Spreadsheet
The F Word
Reciprocity Rules
Pricing Strategies for Spreadsheets
Upselling and Cross-Selling Techniques
Avoid A Multi-Tier Approach
SECTION 5 - Marketing Mastery
Where to Sell Spreadsheets - Marketplace Marketing
Customer Service is Marketing
Six Figure Secrets
How to Sell Spreadsheets on AppSumo Marketplace
Protect Your Spreadsheet IP
Lock Your Sheets with OnlySheets
Weird Idea: Find a Great Sheet Domain Name
A Few New Spreadsheet Business Ideas
SECTION 6 - Spreadsheet Breakdowns
Maximize Spreadsheet Sales to Startups
A Spreadsheet CRM: Automation at work
How to Make Better Lead Magnets
How to Turn a Simple List into an Epic Lead Magnet
The Art of the Sell: Breaking down a Free Title Generator
How to Make an AI Integrated Freebie Spreadsheet