Google calendar output


I'm pretty ignorant when it comes to the coding side of things, so I'm hoping someone can help me with something that I assumed would be pretty simple (but which is driving me mad!). We have a number of upcoming events in a calendar and I'm wanting to easily, automatically display them in a weekly newsletter (sent by Mailchimp - Mailchimp can easily draw from an RSS feed). I'm also hoping to be able to display all future events in a list that I can easily copy and paste into a document.

The calendar address is: https://www.google.com/calendar/feeds/nzcmsdrive%40gmail.com/public/basic (A link including useful tags - https://www.google.com/calendar/feeds/nzcmsdrive%40gmail.com/public/basic?orderby=starttime&sortorder=ascending&futureevents=true )

All I want to display is future events, arranged by date, with the following fields: Event title Date Start time - end time (or just the start time if this isn't possible) Venue Description

At present this is the best I can achieve:

NZCMS gathering with Anthony and Anne (Dunedin) When: Fri May 9, 2014 6pm to 8:30pm NZST

Where: St. Matthew's church lounge cnr Stafford and Hope Street Event Status: confirmed Event Description: We will be having a pot luck meal with as many NZCMS folk as we can gather to welcome Anne and Anthony to the south and hear something of their journey in Cambodia on Friday. Pot luck tea from 6pm with speakers from 7.15pm.

Is it possible to create a pipe to format this into a more desirable output?

Many thanks!


1 Reply

Recent Posts

in Pipes