Auto Fill Range

Fill the range in the google sheets.

Fill the range of sheets with a specified range of data in the 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 auto filled.

• Sheet Name: String Argument The name of the sheet is to be auto filled.

• Range: String Argument The range of the sheet is to be auto filled.

• Fill Length: object Argument The length of the range to be filled.

Options

• Direction: The direction is to be auto filled.

  • UP - range of data is filled in up direction.

  • DOWN - range of data is filled in the down direction.

  • LEFT - range of data is filled in the left direction.

  • RIGHT - range of data is filled in the right direction.