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 …
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. …
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 …
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. …