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, credit card, debit card numbers, FTP credentials 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 Script Google sheets Our products

How to Convert Google Spreadsheet to PDF and Send as Email Attachment

Now a days Google Drive has gain a vast popularity. We have seen people gradually migrating from desktop based office software to browser based Google Sheet and Docs. Sometimes we need Google Sheet data to be emailed to somebody as PDF and at times we also want this to happen recurrently. Keeping these in mind we have come up …

Continue Reading
Google sheets How to ? Tips

How to Set Conditional Formatting Icons in Google Spreadsheet

We say, one image worth 1000 words. Similarly visual representations are sometimes more meaningful than raw data. Conditional formatting is a life saving feature we find in spreadsheets. It allows to format cells based on some condition. In MS Excel, conditional formatting allows background colors, data bars, color scales and icon sets. Among all, icon …

Continue Reading