Skip to main content

Auto Fill Range

UiPath.GSuite.Activities.AutoFillRangeConnections

Description​

Fulfills the auto-fill functionality from the Google Sheets user interface.

Scopes​

This activity requires the following scopes:

OR

Project compatibility​

Windows | Cross-platform

Configuration​

Input​

  • 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.
  • Sheet name - The name of the sheet where the autocomplete will be performed. This property supports String variables and string formatted values.
  • Rule range - The range you specify for the autocomplete process. This property supports String variables and string formatted values (enter your range in A1-style notation). The default value is A1:B2.
  • Fill length - The number of rows or columns you want to fill. This property supports Int32 variables and Int32 formatted values.
  • Direction - Specifies the direction on which the autocomplete will take place. Select from fouroptions: Up, Down, Left, or Right.