Password Protect A Google Drive Spreadsheet With This Script


Google Drive is a great service for both creating and storing spreadsheets if you don’t want to shell out the cash for Excel. However, security is a concern, particularly when it comes to someone accessing your machine. This simple script from tech blog Skipser will allow you to encrypt all your data in a document and put it behind a password.

Initial setup is fairly straightforward. You’ll be given a template spreadsheet that you can duplicate as needed (detailed instructions found at the source link). For each new document, run the script once to give it the permissions it needs at which point you can encrypt or decrypt your data at will.

You’ll need to set up a password the first time you encrypt a spreadsheet, and enter it every time you want to access your data. Encryption is not automatic, so you’ll want to make sure to lock up when you close the document. The first two lines are reserved for links in case you need to decrypt the spreadsheet from mobile, since the Drive app does not support scripts the way the webapp does. Check out the video above to see a demonstration of how to set this up.

How to Password Protect a Document in Google Drive. [Skipser]


The Cheapest NBN 50 Plans

Here are the cheapest plans available for Australia’s most popular NBN speed tier.

At Lifehacker, we independently select and write about stuff we love and think you'll like too. We have affiliate and advertising partnerships, which means we may collect a share of sales or other compensation from the links on this page. BTW – prices are accurate and items in stock at the time of posting.

Comments


3 responses to “Password Protect A Google Drive Spreadsheet With This Script”

Leave a Reply