Merge Range

Merge a range of cells in google sheets.

Merge a range of sheets using specified merge types in google sheets.

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 is to be merged.

• Sheet Name: String Argument The name of the sheet to be merged.

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

Options

• Merge Type: The type to be merged.

  • MERGE_ALL - merge all cells in a range.

  • MERGE_COLUMNS - merge each column in a range.

  • MERGE_ROWS - merge each row in a range.