I wrote a small snippet that does the trick.
Code
function CalendarEvents() {
// get contact
var contactByMail = ContactsApp
.getContactsByEmailAddress('e-mail with address in Google Contacts');
// get location
var location = contactByMail[0].getAddresses()[0].getAddress();
// set date
var date = new Date("September 26, 2013");
// fetch calendar
var cal = CalendarApp.getCalendarById('e-mail of your calendar')
.createAllDayEvent("test", date, {location:location});
}
Usage
This code will run just from within the script. There's no need to add it to a Google Spreadsheet. Go to script.google.com while you're logged in. Add the code and press the bug button to authenticate the script. Afterwards, press the play button to execute the script.
References
See the ContactsApp and the CalendarApp from Google Apps Script.
- CalendarApp
- ContactsApp