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. …
Category: Programming tricks
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 …
Desktop Notification From Browser Using Google Spreadsheet
These days many sites have implemented browser notification. Its a new HTML5 feature which can show a quick alert on desktop. Of course users have to first allow the permission for the desktop notification to be displayed. You can see browser supports for notifications here .What a Browser Notification displays ?A notification is a small …
Extract All Emails From a Webpage Using Bookmarklet
Bookmarklets are the small javascript programs stored in the bookmarks bar. It does small tasks when clicked. It is platform independent, very easy to handle and can be run in any browser. To run a bookmarklet you just need to drag the bookmarklet to the bookmark bar. How to show bookmarks bar in browser ? Firefox …
How to Send Email From Gmail with JavaScript
Many times it is needed to send emails programmatically from JavaScript. So here is a beautiful way we present to send emails from your Gmail with JavaScript using Google Apps Script. You don't need to go through any OAuth process. This is very simple, straight forward, easy to use and needs zero programming skills to …