Google Calendar Connector

Read and write Google Calendar data effortlessly. Integrate, manage, and automate events, calendars, and availability — almost no coding required.

Establish a two-way connection to query and load Google Calendar data using SSIS, SQL Server, ETL platforms, reporting tools, any ODBC/JDBC-compatible application, or your preferred programming language.

Download for SSIS Download for SQL Server and ODBC Documentation

Integrate Google Calendar with these applications

All
Data Integration
Database
BI & Reporting
Productivity
Programming Languages
Automation & Scripting
ODBC applications

Actions supported by Google Calendar Connector

Google Calendar Connector supports following actions for REST API integration:

Create event

Description

Creates event.

Parameters

You can provide the following parameters to this action:

  • Calendar ID (e.g. 'primary' or calendar ID)
  • Send Event Updates

Input Fields

You can provide the following fields to this action:

  • Id
  • StartsOn
  • StartsAt
  • StartsInTimeZone
  • EndsOn
  • EndsAt
  • EndsInTimeZone
  • Summary
  • Description
  • Location
  • ConferenceData
  • Attendees
  • Attachments
  • Recurrence
  • Status
  • Transparency
  • Visibility
  • RemindersUseDefault
  • RemindersOverrides
  • ColorId
  • GuestsCanInviteOthers
  • GuestsCanModify
  • GuestsCanSeeOtherGuests
  • AnyoneCanAddSelf
  • PrivateCopy
  • ShowMeAs
  • SourceTitle
  • SourceUrl

Output Fields

The following fields are returned after calling this action:

  • Id
  • Kind
  • Status
  • HtmlLink
  • CreatedAt
  • UpdatedAt
  • Summary
  • Description
  • CreatorEmail
  • OrganizerEmail
  • OrganizerDisplayName
  • StartsAt
  • StartsOn
  • StartTimeZone
  • EndsAt
  • EndsOn
  • EndTimeZone
  • Attendees
  • Location
  • Recurrence
  • ICalUID
  • EventType
  • ColorId
  • Visibility
  • Transparency
  • Sequence
  • Attachments
  • ConferenceDataConferenceId
  • ConferenceDataEntryPoints
  • ConferenceDataConferenceSolutionKeyType
  • ConferenceDataConferenceSolutionIconUri
  • ConferenceDataConferenceSolutionName
  • GuestsCanInviteOthers
  • RemindersUseDefault
  • RemindersOverrides
  • ETag
  • HangoutLink
  • RecurringEventId
  • OriginalStartDateTime
  • OriginalStartDate
  • SourceUrl
  • SourceTitle

Visit documentation for more information.

Delete event

Description

Deletes event.

Parameters

You can provide the following parameters to this action:

  • Calendar ID (e.g. 'primary' or calendar ID)
  • Event ID

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id

Visit documentation for more information.

Get event

Description

Gets event.

Parameters

You can provide the following parameters to this action:

  • Calendar ID (e.g. 'primary' or calendar ID)
  • Event ID

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • Kind
  • Status
  • HtmlLink
  • CreatedAt
  • UpdatedAt
  • Summary
  • Description
  • CreatorEmail
  • OrganizerEmail
  • OrganizerDisplayName
  • StartsAt
  • StartsOn
  • StartTimeZone
  • EndsAt
  • EndsOn
  • EndTimeZone
  • Attendees
  • Location
  • Recurrence
  • ICalUID
  • EventType
  • ColorId
  • Visibility
  • Transparency
  • Sequence
  • Attachments
  • ConferenceDataConferenceId
  • ConferenceDataEntryPoints
  • ConferenceDataConferenceSolutionKeyType
  • ConferenceDataConferenceSolutionIconUri
  • ConferenceDataConferenceSolutionName
  • GuestsCanInviteOthers
  • RemindersUseDefault
  • RemindersOverrides
  • ETag
  • HangoutLink
  • RecurringEventId
  • OriginalStartDateTime
  • OriginalStartDate
  • SourceUrl
  • SourceTitle

Visit documentation for more information.

List calendars

Description

Lists calendars.

Parameters

You can provide the following parameters to this action:

  • User ID (e.g. 'me' or other-user-email)
  • Max Results

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • Summary
  • Description
  • TimeZone

Visit documentation for more information.

List events

Description

Lists events.

Parameters

You can provide the following parameters to this action:

  • Calendar ID (e.g. 'primary' or calendar ID)
  • Start Time
  • End Time
  • Show Deleted
  • Single Events
  • Max Results
  • Order By

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • Kind
  • Status
  • HtmlLink
  • CreatedAt
  • UpdatedAt
  • Summary
  • Description
  • CreatorEmail
  • OrganizerEmail
  • OrganizerDisplayName
  • StartsAt
  • StartsOn
  • StartTimeZone
  • EndsAt
  • EndsOn
  • EndTimeZone
  • Attendees
  • Location
  • Recurrence
  • ICalUID
  • EventType
  • ColorId
  • Visibility
  • Transparency
  • Sequence
  • Attachments
  • ConferenceDataConferenceId
  • ConferenceDataEntryPoints
  • ConferenceDataConferenceSolutionKeyType
  • ConferenceDataConferenceSolutionIconUri
  • ConferenceDataConferenceSolutionName
  • GuestsCanInviteOthers
  • RemindersUseDefault
  • RemindersOverrides
  • ETag
  • HangoutLink
  • RecurringEventId
  • OriginalStartDateTime
  • OriginalStartDate
  • SourceUrl
  • SourceTitle

Visit documentation for more information.

List events for all calendars

Description

Lists events of all calendars.

Parameters

You can provide the following parameters to this action:

  • User ID (e.g. 'me' or other-user-email)
  • Start Time
  • End Time
  • Show Deleted
  • Single Events
  • Max Results
  • Order By

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • Kind
  • Status
  • HtmlLink
  • CreatedAt
  • UpdatedAt
  • Summary
  • Description
  • CreatorEmail
  • OrganizerEmail
  • OrganizerDisplayName
  • StartsAt
  • StartsOn
  • StartTimeZone
  • EndsAt
  • EndsOn
  • EndTimeZone
  • Attendees
  • Location
  • Recurrence
  • ICalUID
  • EventType
  • ColorId
  • Visibility
  • Transparency
  • Sequence
  • Attachments
  • ConferenceDataConferenceId
  • ConferenceDataEntryPoints
  • ConferenceDataConferenceSolutionKeyType
  • ConferenceDataConferenceSolutionIconUri
  • ConferenceDataConferenceSolutionName
  • GuestsCanInviteOthers
  • RemindersUseDefault
  • RemindersOverrides
  • ETag
  • HangoutLink
  • RecurringEventId
  • OriginalStartDateTime
  • OriginalStartDate
  • SourceUrl
  • SourceTitle
  • CalendarId

Visit documentation for more information.

Move event to another calendar

Description

Moves event from one calendar to another.

Parameters

You can provide the following parameters to this action:

  • Source Calendar Id
  • Target Calendar Id
  • Event ID

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id

Visit documentation for more information.

Update event

Description

Updates event.

Parameters

You can provide the following parameters to this action:

  • Calendar ID (e.g. 'primary' or calendar ID)
  • Event ID
  • Send Event Updates

Input Fields

You can provide the following fields to this action:

  • Id
  • StartsOn
  • StartsAt
  • StartsInTimeZone
  • EndsOn
  • EndsAt
  • EndsInTimeZone
  • Summary
  • Description
  • Location
  • ConferenceData
  • Attendees
  • Attachments
  • Recurrence
  • Status
  • Transparency
  • Visibility
  • RemindersUseDefault
  • RemindersOverrides
  • ColorId
  • GuestsCanInviteOthers
  • GuestsCanModify
  • GuestsCanSeeOtherGuests
  • AnyoneCanAddSelf
  • PrivateCopy
  • ShowMeAs
  • SourceTitle
  • SourceUrl

Output Fields

The following fields are returned after calling this action:

  • Id
  • Kind
  • Status
  • HtmlLink
  • CreatedAt
  • UpdatedAt
  • Summary
  • Description
  • CreatorEmail
  • OrganizerEmail
  • OrganizerDisplayName
  • StartsAt
  • StartsOn
  • StartTimeZone
  • EndsAt
  • EndsOn
  • EndTimeZone
  • Attendees
  • Location
  • Recurrence
  • ICalUID
  • EventType
  • ColorId
  • Visibility
  • Transparency
  • Sequence
  • Attachments
  • ConferenceDataConferenceId
  • ConferenceDataEntryPoints
  • ConferenceDataConferenceSolutionKeyType
  • ConferenceDataConferenceSolutionIconUri
  • ConferenceDataConferenceSolutionName
  • GuestsCanInviteOthers
  • RemindersUseDefault
  • RemindersOverrides
  • ETag
  • HangoutLink
  • RecurringEventId
  • OriginalStartDateTime
  • OriginalStartDate
  • SourceUrl
  • SourceTitle

Visit documentation for more information.

Make Generic REST API Request

Description

This is generic endpoint. Use this endpoint when some actions are not implemented by connector. Just enter partial URL (Required), Body, Method, Header etc. Most parameters are optional except URL.

Parameters

You can provide the following parameters to this action:

  • HTTP - Url or File Path
  • HTTP - Request Body
  • HTTP - Is MultiPart Body (Pass File data/Mixed Key/value)
  • HTTP - Headers (e.g. hdr1:aaa || hdr2:bbb)
  • Parser - Filter (e.g. $.rows[*] )
  • Download - Enable reading binary data
  • Download - File overwrite mode
  • Download - Save file path
  • Download - Enable raw output mode as single row
  • Download - Raw output data RowTemplate
  • Download - Request Timeout (Milliseconds)

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • N/A

Visit documentation for more information.

Make Generic REST API Request (Bulk Write)

Description

This is a generic endpoint for bulk write purpose. Use this endpoint when some actions are not implemented by connector. Just enter partial URL (Required), Body, Method, Header etc. Most parameters are optional except URL.

Parameters

You can provide the following parameters to this action:

  • Url
  • IsMultiPart
  • Filter
  • Headers

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • N/A

Visit documentation for more information.