The video above shows you how to password protect and lock a Google Drive spreadsheet via an encryption script.
Unfortunately, Google does not offer a native, built-in way of locking access to specific documents. The only form of security offered by Google is your account username and password.
There is, however, a way to code an encryption script within Google Drive to lock a spreadsheet.
Sounds complicated right?
Luckily, Skipser.com has already created an encrypted spreadsheet template for us to use.
See Also:Google Drive / Docs Tutorial 2015 – Overview [Video]
The instructions Skipser.com regarding how to use the scripted spreadsheet are a bit outdated and its actually easier now!
In the video above, I walk you through all the specific steps needed to encrypt your spreadsheet.
This method isn’t going to be fool proof but it will definitely make it much harder for an average person to see your data even if they’re logged into your Google account.
As always, if you find this video helpful, I would really appreciate a thumbs up and you may also want to think about subscribing to my YouTube channel.
