Google Sheets

Description

Use data on Google Sheets as a data source of CDP 365 by choosing Google Sheets Connector.

Step 1: Go to Data Source

Create a Google Sheets data source for the Dataflow.

Data Source

Step 2: Create a data source

Click the Create button

Create a data source

Step 3: Select the Google Sheets connector

Select the connector

Step 4: Input the Authentication

Authentication information for Google Sheet Connector includes:

• Username

• Password

Notes: This step means login to your Google account.

Step 5: Select the Sheets:

1. Select the Google Sheets file on the logged-in account that you want to push data into CDP 365.

2. Choose the worksheet of Google sheet file for connecting.

Notes: for the Optional Range, you can select specific ranges of the file pushing data into CDP 365.

Step 6: Connect the source

Click the Connect button to start the process.

Step 7: Select the fields

To finish creating the data source, select and set up the fields that you want to push data into CDP 365.

To set up the fields, please visit this section.