Show Zoho Creator Records in Google Calendar with an iCal Feed

Publish Zoho Creator Records to Google Calendar or iCloud

Your team already lives in a calendar. Rather than asking them to open Creator to see what is booked, publish the report as an iCal feed and let them subscribe — Google Calendar, iCloud, Outlook and anything else that speaks the format will poll it and keep itself current.

Still the right approach — with one warning the original never gave. This is a Creator feature rather than a third-party API, so nothing has been deprecated underneath it. But the feed depends on a private link, and that deserves saying plainly: a private link is a permanent, unauthenticated URL. Anyone who holds it can read that report, forever, with no login. That is unavoidable here — calendar clients cannot authenticate — but it is a decision you should make knowingly. The original published a working private link in the lesson text, which is exactly the mistake to avoid.

Step 1 — build a description worth reading

A calendar entry showing only a record ID is useless. Concatenate the fields that make it meaningful into a single multi-line field:

// On Edit > On Success — build a readable event description
input.Event_Description = input.Event_Name + " / " + input.Client + " / " + input.Organizer;

Step 2 — publish the report and build the feed URL

Publish the report, take its private link, and assemble the feed URL. Only DTSTART and DTEND are mandatory:

https://creatorexport.zoho.com/icalFeed.do
    ?sharedBy=YOUR_ACCOUNT
    &appLinkName=YOUR_APP
    &viewLinkName=Your_Report_Name
    &privatelink=YOUR_PRIVATE_LINK
    &SUMMARY=Event_Description
    &DTSTART=Start_Date_Time
    &DTEND=End_Date_Time
    &ZC_FULL_DAY_EVENT_VAR=Full_Day_Event

Paste that into Google Calendar under Other calendars → From URL, or in iCloud under File → New Calendar Subscription.

Notes

  • Add one variable at a time. Start with DTSTART, DTEND and SUMMARY, confirm events appear, then extend. A malformed optional field makes the whole feed fail to parse, and the error surfaces as “nothing appeared”.
  • This is read-only and one-way. Editing the event in Google Calendar changes nothing in Creator. If you need two-way sync, you need the Google Calendar API instead — note that it rejects API keys for writes and requires OAuth or a service account, with the calendar.events scope.
  • Subscribers refresh on their own schedule. Google typically polls a subscribed feed every few hours, not instantly. For anything time-critical, send a calendar invitation instead.
  • iCloud has no usable API alternative. Apple offers only CalDAV, which needs an app-specific password and a PROPFIND discovery step that Deluge cannot practically perform. For iCloud, the subscribed feed above is genuinely the only sensible route.
  • Filter the report before you publish it. The feed exposes whatever the report shows, so restrict it to future events and to the fields you actually want visible to anyone holding the link.

This script is part of the free Creator Scripts Deluge Library.

All 39 Deluge scripts, the full Zoho Creator course, and every downloadable asset are now free. Get free access →