Rename

[Ak_4]

I have 3 excel file in google sheet Now how to change File name of all 03 using uipath.

[johnfelix (John Felix Yesuraj)]

Hi @Ak_4

You can use Rename sheet activity in Google workspace package
for this task

Once you install google workspace package you can find this activity under

If you want to rename the file name then you can use Move file activity under google drive section

Move File (uipath.com)

Thanks
John

[Ak_4]

I want to change file name not sheet name

[johnfelix (John Felix Yesuraj)]

Hi @Ak_4

You need to use both Find Files and Folders activity and Move Files activity

Find Files and Folders (uipath.com)

Move File (uipath.com)

From the Find Files and Folders activity you can get File Id and Parent Folder ID as output

In the properties panel of Move File activity pass the new file name.
Since you are just renaming the file, you can pass the same folder id as parent folder id

If you know the file id of the file that you want to rename, then you can also use Get File Info activity to get the parent folder Id.

Get File Info (uipath.com)

Thanks
John

[johnfelix (John Felix Yesuraj)]

Hi @Ak_4

Depending on your Authentication mode, you can directly pass the account details or pass the client id and client secret

Rename_Google_Drive_Files.xaml (11.8 KB)

In this demo I have used file names, new file names and parent folder id as Input

If you want the parent folder id to be retrieved automatically. then you can get value from Result output of Find Files and Folders activity and it will be displayed like below

Parents=List(1) { “1sjLVbxZiyGU_hJVG85UcN2_4-UGDPDTb” }

Thanks
John