You can do a lot of things with Google Drive via scripts, but I will focus here on the most simple scripting scenario. You all have used functions in Excel or similar spreadsheet application to make the value of one cell depend on that of other cells. For example, we usually use the sum() to put the summation of a whole row or column in one cell and we call it total. Nevertheless, in Google Spreadsheets, you can also write your own functions, and in those functions, you can even call external sources or applications.
This article was originally written here, also here is a link to a script that converts addresses into latitudes and longitudes in Goolge Spreadsheets.