Create External Credentials for Google Sheets (Beta)
To ingest data from Google Sheets to Data Cloud, set up an external credential for your Google Sheets.
-
From Setup, in the Quick Find box, enter
Named Credentials
, and then select Named Credentials. -
On the External Credentials tab, click New.
-
Enter a label and a name for your external credential. The name can’t contain spaces. You can use underscores.
-
For Authentication Protocol, select OAuth 2.0.
-
For Authentication Flow Type, select Browser Flow.
-
For Authentication Provider, select Google Drive Data Cloud.
-
Click Save.
-
-
Add principal to external credentials
-
In the external credentials that you created, under Principals, click New.
-
Enter the parameter name. You can include spaces.
-
For Identity Type, select Named Principal.
-
Set the Sequence Number to
1
. -
Click Save.
-
-
Authenticate your external credentials.
-
Under Principals, from the Actions dropdown menu, select Authenticate.
-
From the Google Drive Authenticator, select the account where you’re pulling data from
-
To connect Data Cloud to Google Sheets, click Allow.
After you authenticate, the status changes to Configured.
-
-
Define the named credential.
-
In the Named Credentials Tab, click New and enter a label and a name. The name can't contain spaces, but you can use underscores.
-
For the URL, enter
https:/google.com
. -
For external credentials, select the credential you created.
-
Click Save.
-
-
Enable external credential access.
-
From Setup, in the Quick Find box enter
Profiles
and then select it. -
Click System Administrator
-
On the Enable External Credential Principal Access tab, click Edit.
-
Add the external credentials principal that you created to the Enabled External Credentials Principals column.
-
Click Save.
-