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:
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.
- 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.
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.
Was this helpful?
YesNo