Write dataset to google sheet

The “Write dataset to Google Sheet” activity is used to write changes made in a dataset to the relevant Google Sheet file after the completion of the changes.


*Google sheet name	The reference name of the google sheet which has already been opened or created is chosen in the dropdown.
*Dataset name	The reference name is given to the dataset.
Sheet name	A page or tab name within a spreadsheet. If not included, it defaults to the first page.
Destination	Sets destination cell on which the operation will write the results.
*Shift	Select how to copy the dataset to Google Sheet.
Has header	If there are column headings in the dataset, check the box.
Row	Rows that will be written to the excel. Use “:” to select range of rows. (Starting from index 0)
Column	Columns that will be written to the excel. Use “:” to select range of columns. (Starting from index 0)

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}

Dataset name examples

You can use the Dataset name as shown in the example.

newDS

Destination examples

You can use the Destination as shown in the example.

A1

C5

Shift examples

You can use the Shift as shown in the example.

NONE

It copy your data to current place which already has data.

RIGHT

It will copy your data to current place by moving the existing data to the right.

DOWN

It will copy your data to current place by moving the existing data to the down.