Most of the times we face this in real life that the laptop that we carry goes down on battery, or we forget some file in our PC which is in our Office/Home.

It was required that we could get some files like sales figures, reports that we have already prepared from our PC to our mobile while on the move. Also from our mobile we could give commands to our PC to prepare charts, reports etc, while we moving, and get back on the mobile as attachment.

What it does

It send an email, which is received by outlook configured on the PC. These emails are read by the UiPath automation framework and then it takes the appropriate action based on the subject/body it receives in the email. Like

  1. Send any file from PC as attachment
  2. Prepare the excel report
  3. Prepare any chart from excel data received in email body etc.

How I built it

  1. Used the Outlook to configure the email.
  2. Used the c#/.NET to build custom activities for creating chart
  3. Using Uipath, which keeps reading the emails activities get activated and response is sent by email

Challenges I ran into

It was planned and thought very deeply, but still got many challenges like:

  • How to Open and manipulate the excel activities
  • How to send the file back as attachment
  • How to decide the commands which should be easy to use

Accomplishments that I'm proud of

  1. Workflow, that could be very beneficial for the organizations
  2. This could be useful for colleges/students
  3. Used the Excel application scope to build custom activities, so excel manipulation tasks were streamlined.

What I learned

  1. Integration of Uipath with Outlook
  2. Integration with Excel
  3. Designing an automation workflow
  4. Creating charts using custom activities

What's next for Zima workflow

  1. Want to make it work by voice.
  2. Incorporate more an more commands

Want to deploy it in an organization for easily assessing the:

  1. Salary slips
  2. Leave details
  3. Business reporting
  4. Access employee PF
  5. Project statuses etc.

Built With

Share this project: