Add Google Calendar to doc

Syncing a Google Calendar into your Coda doc enhances organization, collaboration, and automation, enabling you to streamline your workflow and make better use of your calendar data. Benefits include:
  • Real-time updates: By syncing your Google Calendar, you can ensure that any changes made to the calendar are automatically reflected in your Coda doc. This provides you with real-time updates, ensuring that your doc is always up to date.
  • Centralized information: Syncing your Google Calendar allows you to consolidate all your calendar information in one place. You can view and manage your calendar events directly within your Coda doc, eliminating the need to switch between multiple platforms.
  • Automation: Coda offers powerful automation capabilities, allowing you to create workflows and trigger actions based on calendar events. For example, you can automatically send notifications or update other parts of your doc when certain events occur in your Google Calendar.
  • Visualization: With the data from your Google Calendar synced into Coda, you can create custom views and visualizations to gain insights and track your schedule more effectively. Coda provides flexible options for creating tables, charts, and other visual representations of your calendar.

Step 1: Add the gmail pack to your doc.

You might be prompted with selecting additional settings for your gCal account connection. Check out this article for more on connecting accounts and account permissions.

Step 2: Drag in an events table

Step 3: Customize the sync

Now that you have your sync table created, it’t time to make sure it is pulling in the correct set of events. Use the Google Calendar Events panel, found in the Table options, to view and customize your settings.

Refresh This Table

This setting controls how often Coda will sync any changes that have taken place in google calendar. your options are:
  • Manual: The coda table does not sync to google calendar unless you manually sync it.
  • Daily: The coda table will sync approximately every 24 hours beginning from when you first set up the sync. For example, if you set it up today at 1:37pm, next daily sync will be roughly tomorrow at 1:37pm.
  • Hourly: The coda table will sync approximately every 60 minutes, beginning from when you first set up the sync.

Date range

This setting allows you to control the dates of events you’d like to sync into Coda.

Search text

This setting allows you to sync only events that include a specific word or phrase.

Calendar

This setting allows you to select a single calendar to sync from. If you’d like to sync multiple but not all available calendars, you’ll need to create separate syncs for each. See below for more details.

Add Criteria

These additional settings allow you to include cancelled or hidden events (which are not synced by default) or exclude events you have declined (are included by default).

Adding another sync

Sometimes you may need additional syncs to bring in exactly the events you’re looking for. Click the “+ Add another sync” button at the bottom of the Google Calendar Events Setting Panel to add a new sync. Common situations that would require a separate sync:
  • Syncing events from multiple but not all calendars
    • Each sync can pull in events from either all calendars or a single calendar. To pull from some but not all calendars, you’ll need one sync per calendar.
  • Syncing events from two or more distinct date range
    • Each sync can pull in events from one continuous date range. To set up multiple date ranges that are separated by time, create a new sync for each range.

Step 4: Customize Columns

By default, a Google Calendar Sync Table has the following columns.:
  • Event - This column houses the synced event that was pulled from google calendar. It is not useful to look at BUT it is needed for the rest of the columns to work. Do not delete it! Instead, we recommend hiding this column so that it does not clutter your view.
  • Summary - Title of the event
  • Start - start date and time
  • End - end date and time
  • Attendees - These are all invited persons to the event. They contain additional information about each person, like RSVP status and email. Hover over each name to see the additional details.
However, there are several more data points that are synced in, but hidden. Check out this help article for help with hiding, unhiding and rearranging columns. If one of the columns contains information that is similar to what you want but not quite, we recommend seeing if you can adjust the column settings to tweak how the information is displayed. If this fails, try creating a new column for your customized information and using a formula to auto-populate it.

Was this helpful?

YesNo