activities
latest
false
UiPath logo, featuring letters U and I in white

Productivity Activities

Last updated Jun 4, 2025

PREVIEW
Copy Paste Range

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.
  • Description
  • Project compatibility
  • Configuration

Was this page helpful?

Get The Help You Need
Learning RPA - Automation Courses
UiPath Community Forum
Uipath Logo White
Trust and Security
© 2005-2025 UiPath. All rights reserved.