Excel-jSon-Excel. A very simple example - creating jSon representation of an Excel Sheet and cloning the whole sheet to another sheet. Normally you would jSon to exchange data with webservices, but it's this simple to use the cJobject inside Excel also. Nov 02, 2017 · Google Apps Script as a Backend Part I: Google Sheets Integration If you are like me, when you have an idea, you like to jump on it and build a proof-of-concept app for it. That is all nice and well, but what if it is a shared idea and the other participants know nothing about coding?

Google Spreadsheets provide a lot of useful functions, but unfortunately nothing that calculates the distance between two locations. However, this is easy to add as a custom function using the Maps service available in Google Apps Script.