How to password protect or lock a Google Drive spreadsheet using an encryption script.

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, has already created an encrypted spreadsheet template for us to use.

See Also:Google Drive / Docs Tutorial 2015 – Overview [Video]

The instructions 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.

Anson Alexander

Anson Alexander is a blogger, author, SEO expert, teacher, and tech geek. As the founder of, Anson works full time writing, editing, and producing content for his site and providing technical and business services to clients. He has a BS in international business and information systems from the University of Tampa. In his free time, Anson plays video games, enjoys nature, spends time at the beach, and loves to travel.

View all posts