I keep track of the concerts I'm attending with a spreadsheet, which I primarily edit in Google Drive and sync to my computer using Syncplicity. What I would like to do is sync this spreadsheet, in whatever form is doable, with Google Calendar. My GCal entries sync with my iPhone's Calendar.app, allowing me to check my concert schedule on the go. (It's much easier than Google Mobile Apps -- at least it is for me.)
As a side note: I know I've got my own sorting/coloring/column system for that spreadsheet, but if I can figure out a file/column format that works, I'll happily adapt my own data for that purpose.
I would guess that GCal could pull data from a CSV file, but I don't know how (if possible) to point it at one that would continuously update. Since I use Syncplicity, I have Dropbox available as part of my equation, so I could provide a URL for a CSV file if GCal requested it, but GCal seems to want a file to import once, negating the sync in favor of an as-needed update basis.
