# Auto Fill Range

> `UiPath.GSuite.Activities.AutoFillRange`

`UiPath.GSuite.Activities.AutoFillRange`

## Description

Fulfills the auto-fill functionality from the Google Sheets user interface.
:::note
This classic activity is in maintenance mode. Instead, use the modern equivalent, the [Auto Fill Range](https://docs.uipath.com/activities/other/latest/productivity/google-workspace-auto-fill-range) activity.
:::

### Scopes

This activity requires the following scopes:

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

OR

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

## Project compatibility

Windows - Legacy | Windows

## **Configuration**

#### Common

* **ContinueOnError** - If set, the remaining activities are executed if the current activity fails. This field supports Boolean values.
* **DisplayName** - The display name of the activity. This property supports `String` variables and string formatted values.

#### Input

* **FillLength** - The number of rows that you want to auto-fill. This property supports `Int32` variables and Int32 formatted values.
* **RuleRange** - Specifies the range of cells that you want to auto-fill. This property supports `String` variables and string formatted values (enter your range in A1-style notation). The default value is "A1:B2".
* **SheetName** - The name of the sheet that you want to auto-fill rows. This property supports `String` variables and string formatted values. The default value is "New Sheet".
* **SpreadSheetID** - The ID of the spreadsheet that contains the sheet you want to auto-fill rows. This property supports String variables and string formatted values. When entering your value, use the exact ID, or the output property variable from a previous [Find Files And Folders](https://docs.uipath.com/activities/other/latest/productivity/gsuite-find-files) or [Copy File](https://docs.uipath.com/activities/other/latest/productivity/gsuite-copy-drive-file) activity.

#### Options

* **Direction** - Specifies the direction you want auto-fill. Select one of the following options: **UP**, **DOWN**, **LEFT**, or **RIGHT**.

#### Misc

* **Private** - If selected, the values of variables and arguments are no longer logged at Verbose level. This field supports Boolean values.