Start the flow of data by creating a data stream for your Google Sheet spreadsheet. The data stream creates a data lake object (DLO) in Data 360 that you can map to the Customer 360 Data Model to use across Data 360.
This feature is a Beta Service. A customer may opt to try a Beta Service in its sole discretion. Any use of the Beta Service is subject to the applicable Beta Services Terms provided at Agreements and Terms. If you have questions or feedback about this Beta Service, contact the Data 360 Connector team at datacloud-connectors-beta@salesforce.com.
Note
| User Permissions Needed | |
|---|---|
| To create a connection: | Data Cloud Architect |
Before you begin:
In Data Cloud, on the Data Streams tab, click New.
You can also use App Launcher to find and select Data Streams.
Under Other Sources, select Google Sheets, and click Next.
Select from the available Google Sheets connections.
Enter the file URL that you want to connect to, select the File Type, and then click Next
Provide a data lake object (DLO) label.
Under Object Details, for category, identify the type of data in the data stream.
For primary key, select a unique field to identify a source record.
If a composite key is required or a key doesn’t exist, you can create one using a formula field. See Create a Formula Field or Use Case 2: Create a Primary Key.
(Optional) Select a record modified field.
If data is received out of order, the record modified field provides a reference point to determine whether to update the record. The record with the most up-to-date timestamp is loaded.
(Optional) To identify the data lineage of a record’s business unit, add the organization unit identifier.
Click Next.
For Data Space, if the default data space isn’t selected, assign the data stream to the appropriate data space.
Click Deploy.
When the Last Run Status displays success, you can see how many records were processed and the total number of records that were loaded.
You can now map the created DLO to the data model to use the data in segments, calculated insights, and other use cases.
j
