Goole unveiled a new feature in Apps Script – “integration with Google Maps. Google Maps has had an API for quite some time, but now we’ve made it very easy to generate customized maps and driving directions straight from a script. A mail merge is often used to automate some of the drudgery involved in sending invitations to a large number of people. With new Apps Script Maps Service you can easily add a map image to email, and even add a marker showing the event location.
While that’s nice, it’s hardly a time saver – why write code to generate same image repeatedly? A much more useful feature is generating a custom map for each guest, along with personalized driving directions. We’ve made a spreadsheet template that includes just such a script – it’s available here,” writes Google.