Subscribe
Sign in
Better Sheets
p/better-sheetsMake Better Google Sheets
Start new thread
Andrew Kamphey

OnlySheets by Better Sheets - Sell access to any Google Sheet

by•

Sell access to a google sheet without sharing with the whole INTERNET. Easy to set up via Gumroad.
Using gumroad ping, this sheet's script captures all sales and matches the sale with a sheet you assign in. Then gives viewer access to the buyer.

Add a comment

Replies

Best
Andrew Kamphey
Maker
Selling my own google sheets templates I found it heartbreaking to know that everyone who bought it could share it freely. They are doing what seems right and helping to spread the word, but also cutting the seller out of the deal. This simple script and sheet helps a creator keep their sanity and sell access to a google sheet. It also works with Docs and Slides.
Alexey Strelkov
@kampheyapproved What exactly will stop people from sharing it with this script?
Ken Savage
@kampheyapproved thx for your guidance on this so far Andrew. Exciting to see this unfold to the world and where it goes.
Mike Ritchie
@kampheyapproved @data_greed right, they can just delete the script
Andrew Kamphey
Maker
@data_greed The original sheet doesn't have to be set to "share with internet" so it's harder for non users to get access. Also if you make a screenshare video, like I do, of sheets, you can do so without thinking someone will just write the sheet id/url and get access. If they do, they will get the "ask for access" screen. not the sheet itself.
Andrew Kamphey
Maker
@kensavage Lots of interesting questions now. Shopify, Airtable. Lots of directions it could go.. if I could code outside of google scripts. Opportunities for others potentially. Also Looking into doing folders and groups of sheets.
Mick Vermaat
Smart. Also love the intro video !
Andrew Kamphey
Maker
@mick_ver Love that you love it Mick!
John Brown
This is great! Too bad to know that some are taking advantage of your work by sharing it freely.
Andrew Kamphey
Maker
@jbrowntheking Those with good intentions are able to do the most damage. And I'm my own worst enemy. I'd love to make more public videos on the sheets I make for those who wish to learn how to make them, and I'd like to sell those sheets to those who wish to pay for them. But if I put a sheet url on a video in a screenshare then anyone can access that if I set it to access to anyone with the link. So this is me eating my own dogfood, and scratching my own itch. So you'll see more free youtube videos from me where I make a sheet and also sell that as a template for a one off price. So far I've had to keep all those videos to paying members of Better Sheets who already have access to all my sheets.
John Brown
@kampheyapproved That is crazy and sad. I hope you find a good solution for this man. Rooting for you.
Henrik
Andrew delivers such high value, in the knowledge of how to make google sheets work for you. What he brings, enables getting so many things done, that you would normally not thing of, due to the time spend find out 'how to' in it self would render the time saved or benefit of the task a higher cost than just doing it "manually". But he shows how to enabling the power of sheets, that many knows are there but most don't knows or get around to harness. Such many brilliant ways to automate and otherwise time consuming tasks small or large :-) Yes, I know it shines trough that I am a fan, but take it for a spin and you'll join me ;-) - Besides Andrew is just the kind of guy that deserves good remarks as he brings a lot & in a super nice personal way.
Andrew Kamphey
Maker
@henrikt1 awww so nice Henrik. Thanks for the wonderful accolades. I hope OnlySheets helps many make much moolah!
Henrik
@kampheyapproved - Yes. I am sure it will :-) - And I had serious thoughts, if to try to sabotage this Producthunt presentation or endorse it... You know sometimes you just want to keep the secret sauce for you self (as your secret advantage) - or share it as both the creator (you) and others deserve to know about & have access to it. Actually made it a hard decision ;-). Just kidding. You deserve (and we) to make this a success :-D Good luck (thou I am sure you don't need it)
Andrew Kamphey
Maker
@henrikt1 You had a convo with a devil and an angel on your shoulders! Great! Ask the tough questions.
Ken Moo
Great product that solves a real pain point. And... it works!!
Andrew Kamphey
Maker
@kenmoo Thanks Ken!
Ni ✌🏾& ❤️
Can't wait to try this! Love that it is gumroad related
Andrew Kamphey
Maker
@ni_e_sha please do. How would you use it? do you already sell sheets on gumroad?
eyal kattan
Any plans for a shopify plugin?
Andrew Kamphey
Maker
@eyal_kattan Good question. If shopify has a webhook capabilities. Can it send all the data out as a JSON? if the answer is yes then yes.
Curt Crowley
What happens if a person's Gumroad email is different than their Google account email address?
Andrew Kamphey
Maker
@curt_crowley1 Great question, Chaos ensues. Sorta Joking, but really you have to use the address you use for gsuite. If not, email me and I'll help you out. It's happened to less than 5% of people so far in the last week who have used OnlySheets. There's no work around right now because the code itself (and google) automatically validates the email. As far as I know there's no way for me to email you if google can't email you.
Ken Savage
Andrew released us and I bought into it immediately seeing how valuable this can be when partnered up with #gumroad. He also made it work with the other Google drive files soooo it’s super easy to start selling access to all those hidden files you have.
Andrew Kamphey
Maker
@kensavage and also looking into folders, and groups or bundles of sheets. It's NotOnlySheets.com now.
Szymon Adamiak
Great name, useful product. Good luck!
Andrew Kamphey
Maker
@sadamiak Thx, and the name just hit a nerve, right?
Mathieu Silverstein
Amazing. Does this only work with Gumroad ping, or could I send the buyer's email address from Zapier or something else to the script to adjust the sharing permission?
Andrew Kamphey
Maker
@matsilverstein You absolutely might be able to use Zapier. Zapier is awesome. I'd rather give an alternative to paying $35/month. OnlySheets solves one problem, has one price. I also have it working with Stripe (different code). And am looking into any other tools that have a webhook or a ping like gumroad /stripe. Anything that can send a json payload, can be accepted by a google script web app and parsed for their email address.
Henrik
Yes!
Soheil
This is a great idea! Congrats Andrew.
Andrew Kamphey
Maker
@soheilpro Much appreciate your encouragement, Soheil
Welly Mulia
Simple yet useful tool. I love your retro video and how simple it was!
Andrew Kamphey
Maker
@welly_mulia Muchhhh appreciated Welly
Daryll Wong
Interesting idea! I'm not familiar in this space, what are some of the popular kinds of gsheets that people would want to purchase?
Andrew Kamphey
Maker
@daryllman Info products like contact info or curated resources. I made a 100 tweet inspiration sheet that also has one click tweet links built in so you can essentially write your own evergreen tweets and tweet them anytime. Calculators: Give a client or a customer a tool to figure some math out. Or see different possibilities. I made 19 templates people can download for free and use to build sheets you can sell: https://appsumo.com/google-sheet...
Sam✌️
Weldone Andrew. Love this product. Greater you.
Harrison from VC Guide
Best name. Full stop.
Andrew Kamphey
Maker
@vcguidehq You're the best!
Marzooq Asghar
Smart product, cereal maker ;)
Andrew Kamphey
Maker
@marzooqasghar I just noticed that... yeah Serial... Maker... :P
Mario Lattuga
Would this work with an airtable? I'm trying to see how i can monetize an Airtable sheet that I've built. Thanks!
Andrew Kamphey
Maker
@mlattuga That's a great question. This doesn't work with Airtable but potentially could if airtable can add viewers through their api. and sends api webhooks.
Max Prilutskiy
Hey, this one looks nice! 👍
Andrew Kamphey
Maker
@prilutskiy You look nice too! Thanks Max.