We are going to describe in here an automation idea that can be build in Studio Web with the help of UiPath.MicrosoftOffice365.Activities and UiPath.Gsuite.Activities.
Context: What mundane task are we to automate?
For this automation, we are looking to automate the situation where you have to sync files across different drives. Companies with multiple departments/teams often have their documents spread across platforms like OneDrive, Google Drive, Dropbox, Sharepoint etc.
Some documents are important, and need to be archived or kept in a central point, where anyone can have access to them. For example, Sharepoint serves well this purpose.
Let’s say you have to sync on a monthly bases the documents of your team from Google Drive to Sharepoint document library. Usually this takes a lot of time because you have to download all the files in the format type compatible with Microsoft applications, and after manually upload them to a Sharepoint folder.
Automation Steps
Step 1 - Create the destination folder in the SharePoint document library
Use the Create Folder activity of the Microsoft Office 365 package to create the SharePoint destination folder where the monthly files will be uploaded later.
If you want a custom name that indicates the corresponding month, feel free to use the configuration from the screenshot below.
Step 2 - Iterate through all the files in the Google Drive source folder
Use the For Each File/Folder activity from the GSuite package to iterate over all files in the Google Drive source folder. Make sure that the value for What to return
field is set to “Files”, so folders are not returned but only files. Limit to first
is left blank so all files are being returned.
Inside the body of this activity you will later add activities to download each file and then upload it to the SharePoint destination folder.
Step 3 - Download each Google Drive file locally
Add the Download File activity of the GSuite package to the body of For Each File/Folder . Then, configure the activity to download the Google Documents types as Microsoft compatible format types.
Step 4 - Upload each file to the SharePoint destination folder
Now use Upload Files activity of the Microsoft Office 365 package inside For Each File/Folder to upload each local file to the SharePoint destination folder created earlier.
Also add the name of the uploaded file to the listOfFiles text value that you can later include in the body of the email.
Step 5 - Send a notification email containing the list of all uploaded files
Finally, use Send Email activity of the GSuite package to send a notification email to an employee who should be aware about the sync of the files.
Now you have one less boring task for yourself, one new task that the robot is happy to perform.
Let us know what you think of this automation idea! Would you like us to share more of these?
- Yes, more automation ideas please!
- No, thank you.
0 voters