Link a date to google calendar so it is added to the calendar

I have a google spredsheet as data. I need to be able to insert data to a google calendar, is there a way to do this?? Thanks

0 5 1,680
5 REPLIES 5

LeventK
Participant V

@Ramiro_Ortiz
What data you want to insert to Google Calendar and in what way do you want to insert it? Can you elaborate?

iโ€™d like to insert the name of a patient and the date of surgery to the calendar. My idea is once u complete all the patientโ€™s data it adds the date and name to the calendar.

Maybe this can help you

I have this problem: Expression โ€˜https://www.google.com/calendar/render?action=TEMPLATE&text=[antec]&dates=[fecha qx]&details=[interconsultas]&location=[plan]&sf=true&output=xmlโ€™ could not be parsed due to exception: #VALUE!.

You cannot enter raw URLs as an expression. Instead, you have to construct it as a Text value:

CONCATENATE(
  "https://www.google.com/calendar/render?action=TEMPLATE&text=",
  ENCODEURL([antec]),
  "&dates=",
  ENCODEURL([fecha qx]),
  "&details=",
  ENCODEURL([interconsultas]),
  "&location=",
  ENCODEURL([plan]),
  "&sf=true&output=xml"
)
Top Labels in this Space