Copy Paste Range

copy and paste the content in google sheets.

Copy the content of the range and paste it into the specified sheet 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 copied.

• From Sheet Name: String Argument The name of the sheet is to be copied.

• To Sheet Name: String Argument The name of the sheet is to be pasted.

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

• Starting Cell: String Argument The starting cell of the sheet is to be pasted.

Options

• Paste Orientation: The orientation of data to be pasted.

  • NORMAL - Paste the data normally.

  • TRANSPOSE - Paste the data transpose.

• Paste Type: The type of data is to be pasted.

  • PASTE_NORMAL - Paste values, formats, formulas, and merges.

  • PASTE_VALUES - Paste values only.

  • PASTE_FORMAT - Paste formats and validation only.

  • PASTE_NO_BORDERS - Paste values, formats, formulas, and merges without borders.

  • PASTE_FORMULA - Paste formulas only.

  • PASTE_DATA_VALIDATION - Paste data validation only.

  • PASTE_CONDITIONAL_FORMATTING - Paste conditional formatting only.