You need to enable a config to rename files, folders & descriptions from a Google Sheet. Select Add-ons → Drive Explorer → Configuration, check "Update folder name,..." and click on
Whenever you rename a file/folder or add/update a description, you will get a notification in the bottom right corner of the sheet. So, instantly you will know if the update is successful or not. Also, if the update fails, the cell will be updated with
UPDATE_FAIL value. You can press
Cmd/Ctrl + Z to get the old value in the sheet.
After listing the files you want in the sheet, you can directly edit any cell in the Filename column to rename the file.
You may need one extra step to rename folders. You need to bring folder link to the sheet. When you try to update the folder name, if the folder link is not already there in the sheet, you will see a dialog with instructions to bring it. You can check pick sheet columns section to know how to add new metadata columns to the sheet.
First, bring description field to the sheet by following this guide. Both files & folders in Google Drive have descriptions. You can add/edit both type of descriptions from the sheet. If you list only folders, you will be working with folder descriptions else file descriptions.
Renaming feature works by creating onEdit triggers on your Google Sheet. If you had used Drive Explorer in a tab once, you may continue to see pop-ups and notifications within the tab whenever you update certain cells. This can be avoided by selecting Add-ons → Drive Explorer → Clear Sheet as it deletes the triggers set by Drive Explorer on that particular sheet tab.