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.
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.
@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.
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.
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?
@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.
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.
@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)
@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.