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.

  1. From Setup, in the Quick Find box, enter Named Credentials, and then select Named Credentials.

  2. On the External Credentials tab, click New.

    1. Enter a label and a name for your external credential. The name can’t contain spaces. You can use underscores.

    2. For Authentication Protocol, select OAuth 2.0.

    3. For Authentication Flow Type, select Browser Flow.

    4. For Authentication Provider, select Google Drive Data Cloud.

    5. Click Save.

  3. Add principal to external credentials

    1. In the external credentials that you created, under Principals, click New.

    2. Enter the parameter name. You can include spaces.

    3. For Identity Type, select Named Principal.

    4. Set the Sequence Number to 1.

    5. Click Save.

  4. Authenticate your external credentials.

    1. Under Principals, from the Actions dropdown menu, select Authenticate.

    2. From the Google Drive Authenticator, select the account where you’re pulling data from

    3. To connect Data Cloud to Google Sheets, click Allow.

      After you authenticate, the status changes to Configured.

  5. Define the named credential.

    1. 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.

    2. For the URL, enter https:/google.com.

    3. For external credentials, select the credential you created.

    4. Click Save.

  6. Enable external credential access.

    1. From Setup, in the Quick Find box enter Profiles and then select it.

    2. Click System Administrator

    3. On the Enable External Credential Principal Access tab, click Edit.

    4. Add the external credentials principal that you created to the Enabled External Credentials Principals column.

    5. Click Save.