Using the new functionality, I threw together a quick sample script that scans my Calendar for the next appointment with a location listed and emails me transit directions. It's designed to be run on a 30 minute trigger.
The new version of Google Sheets has known issues with the Apps Script features listed below. If you are affected by these issues or any other unsupported features, you should continue to use the current version of Sheets for now
"Doing cross domain requests for JSON data from client jQuery apps are hard work. In the past, you would have needed a data source that had implemented JSONP, but nowadays you can use CORS (cross origin resource sharing). However CORS only works if the server is co-operating - meaning that it is allowing access from the domain hosting the client doing the requesting.
It seems that GAS Content Service does not support CORS, and up till now I've managed GET requests perfectly fine by returning JSONP. However, you cannot POST to a Google Apps Script webapp unless it is publicly available, but the thing is, I need to POST to webapps that have different permissions, and I don't really want to use a proxy to do it."