top of page
Google Sheets Password Protector (GSPP)

Protect your Google Spreadsheet with a Password.

 

Install the script inside your sheet in two minutes and let the Password Protector secure your sheet for you.

 

Click here to see how to install the Google script.

 

More Details:

You will receive a sample spreadsheet with the password protection add-on script pre-installed and complete installation instructions.

 

Below are the instructions to use the Password Protection add-on script. 

 

Instructions for using this add-on script.
 
Creating a Password
1) Goto Add-ons ➀ Password Protection âž€đŸ”‘ Activate Password Protection
2) Enter your password in the text box.
3) Reload the sheet and test your password.
 
Changing the Password
1) To reset the password goto Add-ons ➀ Password Protection âž€đŸ”‘ Activate Password Protection
2) Enter a new password and click ok.
 
Disabling the Password Protection
1) To disable the password protection goto Add-ons ➀ Password Protection ➀ 🔑 Deactivate Password Protection
2) Your password protection will now be disabled.
Note: This action only disables the password protection and does not activate/deactivate the sheet lock.
 
🔒 Lock sheet - Blocking other editors from using your sheet
1) Goto Add-ons ➀ Password Protection ➀ 🔒 Lock Sheet
2) Select Yes, if you would like to show a custom message that is displayed to other editors of your sheet when they open the sheet.
3) Select No, if you would like to display the message "You are not allowed to open this sheet".
4) Your sheet is now locked and no editors can open it till you unlock it.
 
🔒 Unlock sheet - Allow other editors to use your sheet
1) Goto Add-ons ➀ Password Protection ➀ 🔓 Unlock Sheet
2) Your sheet will be unlocked.
3) All users with edit access to your sheet can now edit, even if the password protection is enabled.
 
Password protect  any other Google Spreadsheet
1) Go to Tools -> Script editor -> Copy everything from code.gs
2) Open your sheet -> Go to Tools -> Script editor -> Paste the copied code in Code.gs.
3) Reload the sheet.
 
Features:
1) Easily password protect your sheet and block other users from using your sheet. This applies to your Google Account.
2) Lock other editors from using your sheet.

3) Display custom message when someone opens your sheet.

 

 

20% Discount code:  NEWYEAR22 Valid till Feb 2022

 

No hidden charges. This product comes with a lifetime license.

 

International customers are adviced to use  PayPal payment gateway.

Only Indian customers can use Credit/Debit cards for payment. 

Please contact support@gscriptgallery.com for any kind of assistance.

Google Sheets Password Protector (GSPP)

$15.00 Regular Price
$13.50Sale Price
    • Please enter your Google email address during checkout.
    • You will receive a complete Google sheet template along with the add-on script pre-installed.
  • Lifetime. No hidden charges.

bottom of page