How do I prevent people from sharing my spreadsheets by making a copy?

<div>0:01 So how do I prevent people from sharing my spreadsheets by making a copy? I get this question all the time.<br>0:08 Hi, I'm Andrew I am the resident Google Sheets wizard behind bettersheets.co here. Roasting Google Sheets Make Spreadsheet Private OnlySheets How to Share Without Letting Others Edit your Google Sheets

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 bettersheets where I do sell tools templates and tutorials for Google Sheet users And I actually<br>0:25 came into this problem myself and the worst culprit the person that was most responsible for spreadsheets getting shared was myself and this is gonna sound really weird but 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&nbsp;<br>0:45 I was my own culprit I was the one that was releasing that URL and if anyone got that URL if you set a URL ah ah spreadsheet to that anyone with a link anyone with that link can share it and so I have here three ways that I think you can do three things to help you prevent people from sharing your sheet<br>1:05 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 gonna share with you a tool that I made myself that you can buy ah if you want to help prevent people from ah sharing your sheet.<br>1:21 So first off, ah this is a sheet that is available to everyone. Make More Money Selling Google Sheets Add Click Tracking To Your Google Sheets | Bitly in a Google Sheet How To Sell Google Sheets For Fun And Profit Make Your Google Sheet A Template For Others To Copy

This is a businesses that started as a spreadsheet .<br>1:28 It's a completely free sheet. You can go to it at bettersheets.co slash started bettersheets.co slash started and over here in the share button, you can see that this is set to anyone with the link .<br>1:40 So anyone with this link can see this sheet. If someone wants to, ah 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.<br>1:51 But what I did is I created something called Only Sheets. Get Sheet Done: Start Your Business in Sheets Access Free API's with Google Sheets OnlySheets One Click New Sheet

And Only Sheets lets you sell access to your Google Sheets.<br>2:05 What it does is it adds every single buyer to API, so they have to buy it from Gumroad , Stripe, somewhere where it can send an API to Google Sheets and then it adds them as a viewer . This allows you to not have to se- this allows you not to have to set that anyone with a link button, uh. So what you&nbsp;<br>2:13 can do is you can actually set it to restricted and then it will automatically add buyers individually. So only people with bu- only people who buy your sheet will be able to access it. Lock Your Sheets with OnlySheets What's Better Than Google Sheets? Add Click Tracking To Your Google Sheets | Bitly in a Google Sheet OnlySheets

But of course, the question still is, how do I prevent people when they copy it from sharing it? And that I don't have-<br>2:23 a very good answer. I have a few answers here. I go through these very much- 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.<br>2:27 But, 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. Anything is Possible in Google Sheets, But Not Everything Make Spreadsheet Private OnlySheets Make Your Google Sheet A Template For Others To Copy

Two, change your mindset. Instead of trying to sell sheet and only sell sheets, be in the reselling business. Create upgrades to your sheets,<br>2:36 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 sheets.&nbsp;<br>2:41 So here, on the sheet itself I have bettersheets.co and I say put, and I say put your brand name on the sheet that people are sharing . Get Sheet Done: Start Your Business in Sheets How To Sell Google Sheets For Fun And Profit 17 Minutes of Google Sheet Business Ideas

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. In this<br>2:51 case, this, people are going to bettersheets.co so I don't have a better, so I don't have an about page. And I'm not asking people to copy this. This is big year , no, I don't want to say. But what I do suggest is adding an about page, an about tab down below. Have any information you want to add about<br>3:40 your website. Offerings, any contact information, add it there. Roasting Google Sheets Upgrade Your Outreach LIVE COWORK SESSION

Third, make sure the coloring all matches your, your branding, like your feeling. Make sure that people see the sheet and feel your business. Another fun play. Place you can do if you're selling like scripts, you can add it to Apps Script .<br>3:08 Here's an example of a freebie. that I made for Josh who created a list of H1s, Subheads, Primary Call to Actions. I added his name and a link to his Podio right here where they copy a sheet. Again, this is a freebie but I recommend this even in a sold sheet. Roasting Google Sheets Embed Testimonials with SheetTo Hand-Designed Elements How To Sell Google Sheets For Fun And Profit

Looks like your site that has a link to your<br>3:18 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 add a website here, HTTPS slash. And he can also add his website here, joshnewsbomb.com. If you want to get OnlySheets ,<br>4:11 you can get that at onlysheets.bettersheets.co . If you are a member of BetterSheets, you get OnlySheets . sheets for free if you are a lifetime member. If you're a monthly member, it is an extra cost. How to Easily Add Company Logos to Your Google Sheets Add Click Tracking To Your Google Sheets | Bitly in a Google Sheet Download Google Sheets

But also become a member here at BetterSheets.co where there is a course called Selling Spreadsheets.<br>3:30 Entirely, 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's sold spreadsheets before. You can even check out the course, the course outline here at SellingSpreadsheets.com.<br>3:39 It is a Google sheet, it is a Google doc describing the course and goes through all of the curriculum that I share with you in the course, SellingSpreadsheets.com. How to Sell Google Sheets on Etsy & More Marketplaces Advanced Coding in Google Sheets for Programmers How To Sell Google Sheets For Fun And Profit How to Get Every Editor on Every Google File I Own

But all monthly and lifetime members get Selling Spreadsheets for free or you can check out Udemy. Ah, Selling Spreadsheets is also on Udemy<br>4:09 if you want to check that out.</div> How to Sell Google Sheets on Etsy & More Marketplaces 5 Google Sheet Templates You’ll Get as a Better Sheets Member