Subscribe
Sign in
OnlySheets by Better Sheets — Sell access to any Google Sheet
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.
65
Replies
Best
@kampheyapproved What exactly will stop people from sharing it with this script?
@kampheyapproved thx for your guidance on this so far Andrew. Exciting to see this unfold to the world and where it goes.
@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.
@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.
Interesting idea! I'm not familiar in this space, what are some of the popular kinds of gsheets that people would want to purchase?
@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...
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?
@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.
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.
@kensavage and also looking into folders, and groups or bundles of sheets. It's NotOnlySheets.com now.
This is soo cool! Two part question: Does it work on Google Data Studio? If so, can you set access to expire after # of days? I
Can we use it to sell subscriptions to a sheet? And if so, when the subscription ends will the user be removed immediately ?
@konstantinos_giaouzos Great question because this was intended to be the use case. I was attempting to create a recurring membership to a google sheet. I think it's still possible but it's going to be based on what gumroad ping sends. If gumroad ping sends membership start and membership end information, then yes it's possible.
The stripe integration can because you can send any stripe notifications you want to the webhook and then edit the code. But I'd like to abstract that to the sheet level so a user doesn't have to edit the code each time they want to edit the webhook notifications.
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.
@henrikt1 awww so nice Henrik. Thanks for the wonderful accolades. I hope OnlySheets helps many make much moolah!
@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)
@henrikt1 You had a convo with a devil and an angel on your shoulders! Great!
Ask the tough questions.
What a great product! Wondering this too: "Two part question: Does it work on Google Data Studio? If so, can you set access to expire after # of days? "
And can't the user just take a screenshot or does the application prevent screenshots?
Would this work with an airtable? I'm trying to see how i can monetize an Airtable sheet that I've built. Thanks!
@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.
@ni_e_sha please do. How would you use it? do you already sell sheets on gumroad?
This is pretty cool. But can't any buyer-viewer copy the sheet and then share? @kampheyapproved
@irrvrntvc Yep. And they would be intending to "steal" but in this case it gives them a little road bump. And a owner of a sheet can disable copy and download by Viewer. So you can give literally only view access and that's it.
more trouble comes from people who are trying to help the original owner. They share the sheet link as a goodwill thing. Letting others know about it. Or I as a maker want to make a screenshare video with my url showing. Now everyone can access the sheet. But if I don't give them access, they can't.
This is great! Too bad to know that some are taking advantage of your work by sharing it freely.
@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.
@kampheyapproved That is crazy and sad. I hope you find a good solution for this man. Rooting for you.
What happens if a person's Gumroad email is different than their Google account email address?
@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.
@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.
Better Sheets