Google Sheets
Google Sheets
Follow these steps to connect Google Sheets to your CData Connect Cloud account:
-
Open the Connections page of the CData Connect Cloud dashboard.
-
Click + Add Connection in the upper-right corner.
-
Type Google Sheets into the search field, then click the data source name.
-
On the Basic Settings tab of the new connection, enter a connection name or keep the default name.
-
Select the Authentication method, then proceed to the relevant section and follow those instructions.
Token
-
Enter the API Key for your Google Cloud account. You can create an API key in the Google Cloud Console by clicking Create credentials > API key.
-
(Optional) To improve performance, fill out either the Spreadsheet field with a comma separated list of sheet names or Ids or enter a Folder Name.
-
At the top of the CData Connect Cloud Add Google Sheets Connection page, click Save & Test.
-
If the connection test succeeds, a message indicates that your connection has been created.
-
If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. Then, try again.
-
OAuth
-
(Optional) To improve performance, fill out either the Spreadsheet field with a comma separated list of sheet names or Ids or enter a Folder Name.
-
Click Sign in with Google to connect securely through OAuth. This action opens the Google Sheets sign-in page on a new tab.
-
Log into your Google Sheets account.
-
At the top of the CData Connect Cloud Add Google Sheets Connection page, click Save & Test.
-
If the connection test succeeds, a message indicates that your connection has been created.
-
If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. Then, try again.
-
OAuthJWT
- Enter the OAuth JWT Cert. This is multi-line and should be in the following format:
{
"type": "service_account",
"project_id": "...",
"private_key_id": "...",
"private_key": "...",
"client_email": "...",
"client_id": "...",
"auth_uri": ...",
"token_uri": "...",
"auth_provider_x509_cert_url": "...",
"client_x509_cert_url": "..."
}
-
(optional) Set the OAuthJWT Cert Subject. Only set this value if the service account is part of a GSuite domain and you want to enable delegation. The value of this property should be the email address of the user whose data you want to access.
-
(Optional) To improve performance, fill out either the Spreadsheet field with a comma separated list of sheet names or Ids or enter a Folder Name.
-
At the top of the CData Connect Cloud Add Google Sheets Connection page, click Save & Test.
-
If the connection test succeeds, a message indicates that your connection has been created.
-
If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. Then, try again.
-
More Information
For more information about interactions between CData Connect Cloud and Google Sheets, see this information page.