Recently I discovered a powerful tool from the awesome Google Developers Youtube channel: Google Apps Script.
I tried it writing a simple, but powerful example, experimenting with a use case that for sure will be useful to me in the future: geocoding a list of addresses taken from a spreadsheet.
If you are new to Google App Script (like I was) here you can see an introductory video tutorial.
Another tutorial explains how to integrate Google Sheets with Google Maps.
I started from there and I created a script to geocode (that is going from an human readable address to the geographical coordinates of the location) a list of addresses written in a Google Sheets.
To test the script just create a new Spreadsheet in Google Drive, and write down a list of addresses in the first column, like this:
Then click on Tools > Script editor… and write this code in the editor:
Click run, save the script with a name, allow the script to write data on your document, and ta-dah, your addresses will be geocoded and coordinates will appear in the second and third column!
Google Apps Script is not limited to Sheets and Maps data; in the documentation you’ll find all services that can be used in your scripts. You can integrate GMail, Google Calendar, Docs, Drive, Forms and more; you can also connect to external public APIs from your script.