Hey there stranger!

Sign up to get access.

Quality Curation

About this Tutorial

How to curate data easily and quickly into a sheet (Bookmarklet)

Video Transcript

0:00 In this video, I'm going to share with you an idea of how to create sheets to sell, but also, I'm going to give you a tool, a free tool here, a bookmarklet, and what is a bookmarklet?
0:11 So, let me show you my bookmark bar, you're going to see some other stuff here. What is it? Uh. There it is, and so you see this plus company up here.
0:19 What this does is it's a button I have created that allows me to take any website anywhere, take the title and the URL automatically and put it into a Google form.
0:28 Why do we do this? Well, I was, I was uh creating, curating a newsletter for a couple and a half years, two and a half years, and I would read about a hundred articles a week about, this was about influencer marketing industry, and out of the hundred I'd say about ten to twenty were very interesting 
0:45 and useful to me, and so what I would do is I'd curate those. and then I'd put them into a newsletter.
0:50 Well to curate them, all I had to do was click this button, and usually you have to copy paste, you have to keep a file somewhere, you have to write some notes, and this is what I would do.
0:58 So I would have an, what this does is it allows you to immediately get the title and the URL with one click into a Google form and then add some context.
1:10 So this appears in a Google Sheet tool that I call Better Letters, which is a curator suite of sheets to curate a newsletter, but again, you're going to get this for free, you get this for this exact sheet here, so let's make a copy and I will show you how to uhm set it up.
1:25 So I'm going to create a copy and I'll show you how to use it as well. But something like if we found, uh, just go to, uh.
1:36 Let's go somewhere. So for example, maybe we want to curate all the special offers from universities across the United States.
1:43 We have this special offers URL. Every URL is going to be unique usc.edu special offers. And I want to click this button and it's going to grab the title and URL.
1:52 So I don't have to copy that in. But let's create this university deals. We're going to call this unis. That's just what we want to call the form tab.
2:05 We're going to go up to custom functions, create form and booklets. Bookmarklet. Again, this is just what you're going to have to do when you set this up.
2:12 Authorize it. Step through this process. You're going to copy it to your Google Drive and then do this. Uhm. We're going to need to do that again.
2:22 Run that. Script. And it will create a form here down below called Unis because we typed it in B2. Here's the Google Sheet, uh the Bookmarklet code.
2:33 Click OK if you don't want to copy it from there. It'll be here in this B2. And all we have to do is we can take actually any URL, so I'm going to just take this URL, drag it over to this bookmark bar, right click, edit, and we're going to name this plus uni, and in the URL we're going to delete everything
2:55 . We're going to Command A, delete. Delete everything, paste that javascript bookmarklet code, and so at the very beginning it'll say javascript colon, and then it'll have all this code here for you.
3:06 Click save, and now, when I'm on this USC site, and I click uni up here. Let's see, it automatically grabs special offers USC, it grabs a URL, and now I can add some notes, so I created three fields here, you can always add more if you wish, but I'm going to add some notes here, alumni Thank you. deals
3:30 . Just a little note, let's hit submit, and now in my form responses, I have this here, so now I can go to any website, uh alumni deals.
3:44 Membership perks, here it is, and this one is at membership slash perks, so it's a bit different, right? Click plus uni, I have University of Florida, alumni membership.
4:00 Hit submit, and now over here I have that as well. So this makes curation super easy, and I think anyone can create a curated list in a Google Sheet with this tool.
4:10 You can create a resource, a document, a directory, all types of stuff. Now, when you're curating stuff you're probably going to put it all into here, this form responses, but I think one way to make a really great sellable sheet is to add context, but also make filtered views.
4:32 Say we want to add uhm, we want to add state to these or anything like that, we're going to need to use filters.
4:39 I'll show you that in the next video.


Selling Spreadsheets Course Introduction

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