How do I prevent people from sharing my spreadsheets by making a copy?
In this video, Andrew shares effective strategies to prevent unauthorized sharing of your Google Sheets by making copies, including mindset shifts and the use of a specialized tool called Only Sheets.
How do I prevent people from sharing my spreadsheets by making a copy? I get this question all the time. Hi, I'm Andrew. I am the resident Google sheets wizard behind better sheets. co here. Uh, I've been making Google sheets for well over 10 years. I started in a startup making internal tools, and then in 2020, I started better sheets where I sell tools, templates, and tutorials for Google sheet users, and I actually came into this problem myself and the worst culprit, the person that was most responsible for spreadsheets getting shared Was myself, I would make a video like this and I would show a sheet that I was selling and then that URL bar of the spreadsheet , you can see I was my own culprit. I was the one that was releasing that URL and if anyone got that URL, anyone with that link can share it. And so I have here three things to help you prevent people from How do I prevent people from sharing my spreadsheets by making a copy? What's Better Than Google Sheets? Introducing SheetFools OnlySheets
sharing your sheet and one of them is going to be a mindset shift. One of them is going to be actual advice on what to do. And then third, I'm going to share with you a tool that I made myself. If you want to help prevent people from sharing your sheet. So first off, this is a sheet that is available to everyone. This, this is a businesses that started as a spreadsheet . It's a completely free sheet. You can go to it at better sheets. co slash started. And over here in the share button, you can see that this is set to anyone with the link . So anyone with this link can see this sheet. If someone wants to, they actually go to the sheet. They can copy this URL and they can share it with anyone else. And anyone can make a copy. But when I sell spreadsheets myself. I don't want you to be able to copy that sheet unless you bought a copy. And so what I did is I created something called only sheets and only sheets lets How do I prevent people from sharing my spreadsheets by making a copy? YouTuber Talks About Sheets | Sheet Talking Episode 3 Prolific Oaktree Make Spreadsheet Private OnlySheets
you sell access to your Google sheets. What it does is it adds every single buyer via API. So they have to buy it from gumroads, stripes, somewhere where it can send an API to Google sheets, and then it adds them as a viewer . This allows you not to have to set that anyone with the link button. And so what you can do is you can actually set it to restricted and then it will automatically add buyers individually. So only people who buy your sheet. We'll be able to access it. But of course the question still is, how do I prevent people when they copy it from sharing it? I have a few answers here. I go through a lot of these answers here in selling spreadsheets, where you want to protect your intellectual property and you want to maybe change your mindset from selling sheets to reselling sheets. I share with you there. I will tell you the number one first thing you can do is make sure that anyone with a link is not set up on your sheet. So you need only sheets to do that to change your mindset. How do I prevent people from sharing my spreadsheets by making a copy? What's Better Than Google Sheets? Can a Google Sheet have DRM? OnlySheets
Instead of trying to sell sheet and only sell sheets, be in the reselling business, create upgrades to your sheets, create a mailing list that people want to be a part of that gets upgrades, new features to your sheets, add automations. And the third thing, and I have to say, this is probably the most important brand the heck out of your sheets. So I'll share with you now a few places you can brand your sheet. So here. On the sheet itself, I have better sheets dot go. I say, put your brand name on the sheet that people are sharing . Even in the screenshot. If you're sharing that screenshot on Twitter, on social media, put your branding there, make sure people see it also have an about page. I do suggest adding an about tab down below, have any information you want to add about your website, your offerings. Any contact information, add it there. Third, make sure the coloring all matches your branding. Like you're feeling, make sure that people see the sheet and feel your business. How do I prevent people from sharing my spreadsheets by making a copy? Make More Money Selling Google Sheets How To Sell Google Sheets For Fun And Profit Things to Think About When You Share a Sheet
Another fun place you can do if you're selling like scripts, you can add it to app script . Here's an example of a freebie that I made for Josh who created a list of H1 subheads, primary call to actions. I added his name and a link to his podium right here where they copy a sheet. Again, this is a freebie, but I recommend this even in a sold sheet. Add something that looks like your site, that has a link to your site in there, so that when people share it, they will share a link to your site. In Apps Script , because he is a developer, I put this comment , Hi, I'm Josh, I made this sheet. And he can also add his website here, joshnewsbomb. com If you want to get Only Sheets, you can get that at onlysheets . com If you are a member of better sheets, you get only sheets for free. If you are a lifetime member, if you're a monthly member, it is an extra cost, but also become a member here at better sheets to co where there is a course How do I prevent people from sharing my spreadsheets by making a copy? Get Sheet Done: Start Your Business in Sheets Embed Testimonials with SheetTo Hand-Designed Elements
called selling spreadsheets, entire course about how to sell brand, your sheets, make sheets that people want to buy all kinds of cool tips and tricks on sell sales and marketing of your sheets from someone who Who sold spreadsheets before you can even check out the course, the course outline here at selling spreadsheets. com. It is a Google doc describing the course and goes through all of the curriculum that I share with you in the course selling spreadsheets. com, but all monthly and lifetime members get selling spreadsheets for free, or you can check out Udemy selling spreadsheets is also on Udemy if you want to check that out. Selling Spreadsheets Course Introduction How to Sell Google Sheets on Etsy & More Marketplaces How To Sell Google Sheets For Fun And Profit How to Get Every Editor on Every Google File I Own