# Copy Paste Range

> `UiPath.GSuite.Activities.CopyPasteRangeConnections`

`UiPath.GSuite.Activities.CopyPasteRangeConnections`

## Description

Copies and pastes a range of specified cells into a specified sheet. You can copy from sheet and paste into a different one, or copy and paste within the same sheet.

### Scopes

This activity requires the following scopes:

* https://www.googleapis.com/auth/drive

OR

* https://www.googleapis.com/auth/spreadsheets

## Project compatibility

Windows | Cross-platform

## Configuration

* **Add new connection** - You must connect to **Google Sheets** to use this activity.
* **Spreadsheet** - The spreadsheet where the autocomplete will be performed. This property supports `String` variables and string formatted values.
* **Spreadsheet sample** - Select a file with the same range and column structure as the variable file. This field becomes visible when you select the **Use spreadsheet template** option.
* **From Sheet Name** - The name of the sheet that you want to copy data from. This property supports `String` variables and string formatted values.
* **Range** - Specifies the range of cells that you want to copy. This property supports `String` variables and string formatted values. Enter your range in A1-style notation. The default value is A1:B2.

  + For example, if you have data in cells A1:C4, and you enter `A1:B3` as your **Range**, the data in cells A1:B3 is copied and the data in cells A4, B4, and C1:C4 remains.
* **To Sheet Name** - The name of the sheet that you want to paste data into. This property supports `String` variables and string formatted values.
* **Starting Cell** - The starting cell where you want to paste the copied data. This property supports `String` variables and string formatted values. Enter your range in A1-style notation. The default value is C3.

#### Input

* **PasteOrientation** - The orientation used when pasting data. Select one of the following options: **Normal** and **Transpose**. The default is **Normal**.
  + The **Transpose** option indicates that the copied rows will paste as columns and the copied columns paste as rows.
* **PasteType** - The format used to control how copied data is pasted. Select one of the following options:
  + **Paste Normal**: Paste values, formulas, formats and merges.
  + **Paste Values**: Paste values only, without formulas, formats and merges.
  + **Paste Format**: Pastes format and data validation only.
  + **Paste No Borders**: Pastes values, formulas, formats and merges, all without borders.
  + **Paste Formula**: Pastes the formula only.
  + **Paste Data Validation**: Pastes data validation only.
  + **Paste Conditional Formatting**: Pastes the conditional formatting only.