---
schema_version: "1"
id: 51d203959b398471f0c73ac9269070873a75df3e452628cd1afaceeb415e82a6
title: Create External Credentials for Google Sheets (Beta)
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/data-cloud/data-cloud-int/guides/googlesheet/c360-a-googlesheet-cred.md
canonical_url: https://developer.salesforce.com/docs/data/data-cloud-int/guide/c360-a-googlesheet-cred.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: a26e1d7f94f03ccecdcc13353b03e3b2686c5dffa93a73aae76714dd3755dc92
products:
  - Data 360 Integration Guide
  - Data 360 Developer Documentation
---
# Create External Credentials for Google Sheets (Beta)

To ingest data from Google Sheets to Data 360, set up an external credential for your Google Sheets.

We recommend using the built-in Google Drive Data 360 OAuth provider. If you prefer to use your own, create the [OAuth-based authentication for Google](https://help.salesforce.com/s/articleView?id=data.c360_a_setup_oauth_google.htm&type=5) in Setup before completing these steps.

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

    ![namedcredential definition](https://developer.salesforce.com/media/NamedCred_13Aug2024.png)

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** or the provider you created.

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

## Next Step

- [Set Up a Google Sheets Connection (Beta)](https://developer.salesforce.com/docs/data/data-cloud-int/guide/c360-a-set-up-googlesheet-connection.md)