Password Protected Google Spreadsheet

Password Protected Google Spreadsheet

The best solution to this problem would be to have Google Drive ask for a password each time you open a document. Unfortunately, Google doesn't provide such a protection feature in-built. But you can achieve the same using the password protected Google Spreadsheet which uses Google Scripts. Here's how to use it.

1. Open and make a copy of ProtectedSheet Google spreadsheet. You can rename it to any name you want.
2. Next select "Tools->Script Editor". This will bring up a script in a new window or tab.
3. In this window, select "File->Manage Versions" and click on "Save a new version". You can leave all fields blank. A new row for version 1 will appear. Just click "OK" button.
4. Now select "Publish->Deploy as webapp" and click on the "Deploy" button.
5. You will now be shown a confirmation that you app has been deployed as a web app.

1. Now close this window and come back to the spreadsheet tab or window. You will find a new menu item "Protect File" in the spreadsheet. Select "Protect File->Initialize" and provide required permissions.
   
   All the above steps are one time only. You have now fully setup your password protected document.
2. Now you can add what ever you want to store securely into the document. Just make sure you leave the first two colored rows intact.
3. To secure the document, select "Protect File -> Encrypt File". You will be asked to enter a password. Once done, this will scramble the content each cell in the document. Now your data is fully password protected and nobody can read it without having the password you have set.
   NOTE: This password is not your Google account password, but any password you can choose. The first time you run "encrypt", you will be asked to set a password which will be used for all further encrypt/decrypt requests. 
4. When ever you want to decrypt your document, open it and select "Protect File -> Decrypt File". You will be again asked for the password giving which it will decrypt and bring back the cell contents which you can read or edit.

This works well if you are opening the spreadsheet in a PC. But if you are opening it from a phone, Google always loads the phone version and you won't get the "Protect File" menu. To encode/decode your spreadsheet from a phone, click on the encrypt/decrypt URL which will be present in the first row. This URL gets created and added once you deploy the web app in step 4 above.





References:

1. http://www.skipser.com/p/2/p/password-protect-google-drive-document.html