Google Workspace (GSuite)
This guide will walk you through how to sync your Google Workspace data with Openline customerOS.
The specific data customerOS uses includes from the following Google Workspace services:
- Google Mail
- Google Calendar
- Google Meet
- Google Drive
This will allow you to sync your users and their data from Google Workspace into customerOS, allowing you to see the full picture of your customers in real-time.
Connecting your Google Workspace
Openline connects to Google Workspace using a special type of Google Workspace account called a Service Account.
To create a Service Account in Google Workspace, you'll need access to Google Cloud Platform on your Google Workspace with Super Administator permissions. If you don't have this, please contact your Google Workspace administrator to help you create a Service Account.
- As the Google Workspace Super Administrator, log into your Google Console account. If you haven't logged in before you will have to agree to the terms & conditions shown.
Next we will create a new project to contain our Service Account. Click the button
Select a project ▾
in the upper left corner of the Console
- Now click
New Project
- Enter a Project name and click
Create
. In this example we set the name Gmail Service Account.
- You should now have been sent to the Dashboard of your new project. From here we want to click the
+ Enable API and Services
button
- On the API Library page that opens, use the search box to find
Gmail API
, select it and then Enable it on the next page.
Note that enabling the APIs here does not instantly grant the access, it is a prerequisite to add the corresponding permission scopes later.
In the same way, now find and enable four more API sets for the service account:
Google Calendar API
Google People API
Google Drive API
Tasks API
Gmail API
(enabled above)
- Now the you have created the Google Project and enabled the API accesses that are required for the service account, we can create the service account itself. Click the
☰ (Navigation menu)
icon (1) in the upper left corner of the Console and selectIAM & admin
(2) >Service accounts
(3) in the navigation pane.
- Click the
+ Create Service Account
button
- Enter a name to identify the service account and fill in the Service account description field, then click
Create and continue
. Copy the email address and Client ID of the service account, as it will be used later.
- In the next section, set the value
Project > Owner
in the fieldSelect a role
and clickContinue
- Click
Done
in the next section
- The next step, click the
⁝ (Menu)
icon in the Actions column of the created service account and selectManage keys
- On the opened page, click
Add key
and selectCreate new key
from the drop-down list
- Select JSON format for the key (the default one) and click
Create
- The JSON file will be downloaded to your computer; store the Key file securely, as it has access to your Gmail resources. This file will be used at a later step. Close the download notification to proceed.
- We now need to setup Domain Delegation. To do this return to Gmail Admin Console’s
Security
tab, then go toAccess and data control > API controls
- Click
Manage Domain-Wide Delegation
at the bottom of the page
- Click
Add new API client
- On the opened page we need to enter the Client ID related to the service account created in step 8. We need to populate the OAuth scopes field with the following value and click
Authorize
:
For more information about scopes you can read here: https://developers.google.com/gmail/api/auth/scopes
Wait for 5+ minutes while Google propagates your configuration across it's systems. You now have set up a Service Account with Domain Delegation ready to integrate with Openline's customerOS!
Log into your Openline account, click on the
Settings
button and paste your Google Workspace Service AccountPrivate Key
andService Account Email
from Step 8. Press save.
- That's it! Openline will now continuously monitor your Google Workspace account for data changes and automatically sync them to customerOS.
What happens to this data?
- Openline collects your Google Workspace data and stores this within your customer graph for easy manipulation into useful aggregations and views
- This data includes contacts, interactions, companies, deals and more!
- Once stored in customerOS, this data is linked to all other customer data from other systems and inputs
- This allows you to see the full picture about your customer without having to load data from one place to another!