Copy Paste Range
copy and paste the content in google sheets.
Last updated
copy and paste the content in google sheets.
Last updated
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
.
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.
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.