I cannot be the only person trying to do this, but have not seen a solution anywhere. I produce a monthly newsletter that has a calendar of events. I can export .ics files, make .csv files with the info formatted, but data merge doesn't seem to have a way to drop things into cells of a table.
Would love to find a script that let's me enter the URL of the public link to a Google calendar, prompt for a date range, grab data, then populate my lovely table.
My "manual solution" currently means using the clipboard for every event.