Write Range

Write the data into the range of google sheet.

Write the values from the data table into the specified range of the google sheet.

This activity can only be used after the Create GSuite Connection Activity.

Input

• Credential: Object Variable A variable name that references the user credential to access the resources.

• SpreadSheet Id: String Argument The Id of the spreadsheet in which the data is to be written.

• Sheet Name: String Argument The name of the sheet in which the data is to be written.

• Range: String Argument The range of the sheet to write.

• Include Headers:

  • True - column headers from the specified data table will be written.

  • False - column headers from the specified data table will not be written.

• Data Table: DataTable Variable The data table to be written.