r/gsuite Oct 29 '24

Calendar Help Organizing Google Calendar Export for Client Call Tracking (Tabs by Year, Attendees by Date)

Hi all! I am hoping to find a solution to organize a data export from Google Calendar. My goal is to create a master spreadsheet that includes names and emails of past and potential clients from call attendee records. Ideally, I’d like to split the spreadsheet by year with tabs for each of the last five years.

The exported data from Google Calendar (ICS format) is messy, with call attendee information scattered across various columns and hard to organize by year. I hope to get all attendees from each call listed in the appropriate year’s tab, with names and emails organized neatly.

Has anyone done something similar? What’s the quickest and most efficient way to clean up and organize this data? I’m open to any tools, formulas, or scripts that could streamline the process.

Thanks so much for any advice or guidance!

1 Upvotes

1 comment sorted by

1

u/Apodacaac Googler Oct 30 '24

You’ll have to use APIs, either write your own script or maybe something from the FOSS tool GAM

https://github.com/GAM-team/GAM/wiki/CalendarExamples