Enter transactions into desktop application from excel file from Google Drive using Integration Services

Members only Use Cases Repository
, , , , , , ,
1

Enter transactions into desktop application from excel file from Google Drive using Integration Services

Use Case Description

Problem Statement:
Business uploads transaction files with xlsx format in a specific Google Drive folder. Currently Bot has to run every 5 minutes to check if there is any new file to process. It’s wasting bot license.

To Be Process:
Use of Integration Services to monitor Google drive folder for new transaction files. We will be adding a trigger which will monitor the event from Google Drive for specified Data Filters. Trigger will be setup for 5 minutes polling interval.
Trigger will trigger UiDemo app to process transaction file on unattended robot.

AS-IS WORKFLOW, TO-BE WORKFLOW

To Be Workflow.png
To Be Workflow.png902×603 32.3 KB

Other information about the use case

Industry categories for this use case: Finance, Operations, Banking

Skill level required: Beginners

UiPath Products that were used: UiPath Studio, UiPath Assistant, UiPath Studio Web, UiPath Orchestrator

Other applications that were used: Integration Services

Other resources: Code to enter transaction into Ui Demo App:

Integration Services Docs:

Google Drive Integration:

What is the top ROI driver for this use case?: Accelerate growth and operational efficiency

2 Likes