You will find a new menu item 'Protect File' in the spreadsheet. Now close this window and come back to the spreadsheet tab or window.You will now be shown a confirmation that you app has been deployed as a web app.Now select 'Publish->Deploy as webapp' and click on the 'Deploy' button.In this window, select 'File->Manage Versions' and click on 'Save a new version'.This will bring up a script in a new window or tab. Open and make a copy of ProtectedSheet Google spreadsheet.But you can achieve the same using the password protected Google Spreadsheet which uses Google Scripts. Unfortunately, Google doesn't provide such a protection feature in-built. The best solution to this problem would be to have Google Drive ask for a password each time you open a document. That means if somebody gets access to your PC or phone momentarily, he/she can actually take a peek at these. Although Google Drive can only be accessed after logging into Google, we are almost always logged into Google in our phones and PCs. Something like a bank account number, login ids, social security number etc which I can look-up using the Google Drive app on my phone. After all, its safe, secure and maintained by Google in the cloud.Īnd like a lot of people I also have a spreadsheet containing some little private info which I need to access now and then. With Google Docs merged to Google Drive, a lot of us have cultivated the habit of storing any and every document into Google Drive. Password, pin and pattern locks are available for security in the app. It support text notes, spreadsheets as well as checklists with all possible formatting options. IMP: If you are looking to use google drive as a secure option in your android phone, a better option would be ' Sec Notes'.

How to access google drive locked file