Google Drive Google Script Google sheets How to ?

Store Passwords in Google Spreadsheet in Encrypted Format

It’s very difficult to remember many things which we need on daily basis like passwords, FTP credentials or any other secret data etc. Also it is very dangerous to save passwords directly somewhere. We sometimes store our credentials in Google Spreadsheet. But is it really secure ? You never know when somebody peep into your …

Continue Reading
Google sheets Our products Programming tricks Utility

Send Notification Email If a Cell is Changed in Google Spreadsheet

The live collaboration feature has turned the Google Spreadsheet into an awesome spreadsheet tool. We share our spreadsheets to multiple people with different level of access. Many times it happens that we want to be get notified when a cell in a specific range is updated. We need that updated value to be emailed to us. …

Continue Reading
Google Apps Script Programming tricks Tips

Custom Function to Get Place from Zip Code in Google Spreadsheet

Functions/formula are the most friendly way to quickly calculate something in a spreadsheet. There are a lot of in-built functions available in Google Spreadsheet, check here the list of all functions available. Google spreadsheet has also an option called custom function. When a calculation is repeatedly required at multiple places we can create a custom function for it. Just …

Continue Reading