Read google sheet to dataset

Estimated reading: 1 minute 115 views

The “Read google sheet to dataset” activity is used to import the specified Google Sheet file into a dataset.

*Google sheet name	The reference name of the google sheet which has already been opened or created is chosen in the dropdown.
*New dataset name	The reference name is given to the dataset which will create in this field.
Sheet name	A page or tab name within a spreadsheet. If not included, it defaults to the first page.
Range	Cell range, e.g: A1:C2
Has header	If there are column headings in the dataset, check the box.
Include formatted text	The values will be calculated and formatted in the response according to the format of the cell.

_{Note: * Fields selected with are required, others are optional.}

You can use the Google sheet name as shown in the example.

${newGoogleSheet}

You can use the New dataset name as shown in the example.

newDS