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 those data directly somewhere. We sometimes store our credentials in Google Spreadsheet. But is it really secure ? You never know when somebody peep into …
Category: Google sheets
Bulk URL Shortener with goo.gl and Google Spreadsheet
Goo.gl is one of the most used service to shorten long URLs provided by Google. But this service does not support shortening multiple urls at once. You have to short one url at a time. Sometimes for marketing and sales, you may need to shorten bulk URLs. There are APIs available for Goo.gl which you …
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. …
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 as email attachment and at times we also want this to happen recurrently. …
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 …