Back to blog

Field note

How to sync Airtable to Google Calendar with an iCal feed

Publish selected Airtable records to Google Calendar as a read-only subscription, with clear field mapping and view-based filtering.

The simplest way to keep Airtable dates visible in Google Calendar is a calendar subscription. Airtable remains the source of truth, while Google Calendar periodically reads an iCal URL and displays the current events.

This is different from an automation that creates independent Google Calendar events. A subscription avoids maintaining two copies of the same schedule.

Before you create the feed

Prepare one Airtable table with:

  • A reliable title field
  • A start date or date-time field
  • An optional end date
  • A view containing only records that belong in the calendar

Records without a usable start date cannot become calendar events. Give every scheduled record a clear title as well, otherwise the calendar will be difficult to scan.

If the base contains drafts or internal records, create a dedicated view. Airtable explains that view filters hide records that do not match their conditions. That makes a view the cleanest contract between your operational table and a calendar audience.

Create the Airtable feed

  1. Sign in to Airtable to Calendar with Airtable OAuth.
  2. Create a new feed.
  3. Select the base, table and optional view.
  4. Map the event title and start date.
  5. Add an end date, description, location or URL when the workflow needs them.
  6. Save the feed and copy its private subscription URL.

Treat that URL like a password. Calendar applications cannot log in to a private feed, so possession of the URL grants read access. Delete the feed if the URL is shared with the wrong person.

Subscribe in Google Calendar

Open Google Calendar in a desktop browser. In the left sidebar, find Other calendars, choose From URL, paste the private feed URL and add the calendar.

The imported subscription appears alongside your existing calendars. Give it a distinct color so Airtable deadlines are easy to identify.

Do not import a downloaded .ics file when you need ongoing updates. An import is a snapshot; a URL subscription is the connection Google Calendar can refresh.

Understand refresh timing

Airtable updates the source immediately, but Google Calendar decides when to request subscription URLs again. A changed record may therefore take time to appear. Recreating the feed does not force Google to refresh faster.

Use this model for publish dates, project milestones and operational schedules where Airtable is authoritative. If users must edit events in Google Calendar and send those changes back to Airtable, compare one-way and two-way Airtable calendar sync before choosing an automation platform.

For a decision between a focused feed and a workflow builder, see Airtable to Calendar vs Zapier.