Google Workspace connector

The Google Workspace connector enables you to integrate with the Google Workspace platform’s Contacts, Calendar, and Spreadsheets services.

You can use this connector to do the following:

• Create, edit, delete, and search for Google contacts and contact groups.

• Create, edit, delete, and search for calendars and events in Google Calendar.

• Read and modify the data in Google Spreadsheets.

You can use Google Data Extended Properties with Google Contacts and Google Contact Groups by adding custom fields to the XML profile.

Connector configuration

To configure a connector to communicate with Google Workspace, set up two components:

• Google Workspace connection

• Google Workspace operation

You can create one Google Workspace connection for each Google account with one or more Google Workspace operations, one for each type of interaction required by your integration scenario.

You can reuse components, containing connection settings (such as user name and password) and operation settings (such as Object, Action, data definitions). After building your connection and operation, set up your connector within a process. When you define the Google Workspace connector correctly within your process, Boomi Integration can map to and from virtually any system using the connector to retrieve data from or send data to Google Workspace.

Processing special characters

To process special characters in the Google Workspace connector, the data must be UTF-8 encoded. You can do this when running a local basic runtime on Windows by doing one of the following:

• Adding the line -Dfile.encoding=utf-8 to the atom.vmoptions file.

• Converting special characters in a Data Process step setting Character Encode to UTF-8.

• Converting the data source.

Supported editions

Boomi Integration supports the following editions:

• Google People API version 1.0

  note

  Boomi strongly recommends that you migrate your apps from the deprecated Google Contact API to the People API. For more information about the deprecation, what's changing, and the steps you need to complete, see Google's announcement.

• Google Calendar API version 3.0

• Google Sheets API version 3.0

  note

  Boomi recommends using the Google Sheets connector, which uses a newer API version, instead of Google Spreadsheets. To learn more, see the topic Google Sheets connector.

Spreadsheet file management operations use the Google Drive API. The Google Drive API does not have an exact match property filter as did the older and no longer available Google Docs API. As a result, filters by title uses the CONTAINS operator instead of the EQUAL operator. Operations on worksheets and worksheet rows still use the Google Sheets API.

Prerequisites

The Google Workspace connector requires that you have a Google account.

Tracked properties

This connector has no predefined tracked properties. See the topic Adding tracked fields to a connector operation to learn how to add a custom tracked field.