The script below can be used to export your calender dates from google calender to google sheets.
Turns out google sheets allows you to write scripts as .gs files which is basically javascript with some specific features for querying and editing google docs files. Just like the developer mode in Excel but in a nicer language.
Original script I based this on was found here: http://blog.cloudbakers.com/blog/export-google-calendar-entries-to-a-google-spreadsheet. I edited it for my needs.
To use open a new file in google sheets, click on tools > script editor. Paste the code in and put your email address and the date range you want.
Select export_gcal_to_gsheet and click play.