Read google sheet to dataset

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.

Google sheet name example

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

${newGoogleSheet}

New dataset name examples

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

newDS