Data Migration into CRM Apps
This repository contains RPA (Robotic Process Automation) solutions developed using UiPath Automation Platform. The three types of RPA solutions, constructed in REFramework, Modern design, and Classic design, respectively, are tailored to automate repetitive and time-consuming data entry tasks, streamlining customer data entry into both CRM web and desktop applications simultaneously. This project significantly improves efficiency and accuracy, reducing hours of manual data entry efforts to just a few minutes.
Web Scraping for Real Estate Data
This repository contains an RPA (Robotic Process Automation) robot that is designed to scrap up to 500 pieces of property information for a given location from the real estate website, zillow.com. The extracted data includes price, number of bedrooms, number of bathrooms, area (sqft), and address. The data is then intelligently organized, filtered, and sorted according to user-defined criteria before being seamlessly integrated into an Excel file named output.xlsx.
Scraping PDF Invoices
This repository houses an automation solution that harnesses the power of UiPath Automation Platform to effortlessly scrape data from a substantial batch of 1000 invoices issued to different customers. The extracted data is then intelligently compiled and stored in the invoices_data.xlsx Excel file. Additionally, the RPA solution categorizes the successfully and unsuccessfully scraped invoices into separate folders. Impressively, this RPA robot completes the process in just approximately 130 minutes, achieving nearly 100% accuracy.
Scraping Scanned Docs using OCR
This repository houses efficient automation solutions designed for extracting text from a series of scanned PDF documents sharing identical layouts and formats. Leveraging the built-in Tesseract OCR engine, the UiPath RPA robot extracts relevant information from each scanned document and consolidates it into a single text file. This RPA robot offers a rapid automation solution, significantly reducing the time-consuming manual effort required for such tasks.
Gmail Automation
This repository hosts a robust automation solution that showcases the seamless integration of the UiPath Platform with the Gmail. It orchestrates various email operations, including Email Reading, Email Saving, Email Attachments Downloading, Email Forwarding, and Email Deletion, effectively enhancing productivity and organization. Additionally, it generates and sends an automated email summary report to designated recipient(s), providing insights into the mailing activities that have taken place on each target email.
Outlook Email Automation
This repository showcases the seamless integration of the UiPath Platform with the Desktop Outlook Application, demonstrating how automation can streamline email operations. The UiPath robot automatically retrieves and saves the 10 most recent unread email messages, along with attachments, from the Desktop Outlook App onto the local machine. Also, it sends an automation report to specified recipients, keeping them informed about the mailing activities that have taken place.
Invoice Extraction with OCR
This repository houses a UiPath automation solution tailored for Invoice Extraction in RPA workflows. Tasked with reading each table row and extracting invoice details from each invoice photo through Optical Character Recognition (OCR), the solution outputs a CSV file with the extracted data alongside the table's ID and Due Date, specifically for two individual business suppliers.
Coronavirus Stat-Alert Bot
This repository contains an automation solution for developing a Coronavirus stat-alert bot. The bot scrapes Coronavirus statistics (Total Cases, Total Deaths, and Total Recovered) from a user-inputted country on https://www.worldometers.info/coronavirus/ and sends an update email with the data to specified contacts. It utilizes Input Dialogs, Table Extraction Wizard, For Each Row activities, and Send Outlook Mail Message activity for efficient automation.
IP Address to Location Converter Bot
This repository hosts an automation solution to convert IP Addresses in an Excel spreadsheet to their corresponding physical locations (Country, Region, City) using whatismyipaddress.com. It reads data from "IPs.xlsx," navigates to the IP Lookup page, extracts location information, and writes it back to the spreadsheet. The solution employs activities like Navigate To, Delay, Anchor Base, Find Element, Get Text, and Write Cell for seamless execution.
Image Background Remover Bot
This repository houses an automation solution aimed at removing backgrounds from images in a specified folder using the online AI tool https://www.remove.bg/. The bot loops through the images, uploads them to the tool, saves the edited images in a separate folder, and closes the browser. This streamlined process is facilitated by activities like Click, Type Into, Move File, and Close Application, ensuring efficient image background removal.
Calendar Picker Bot
This automation solution creates a bot to search for locations on Booking.com and select start and end dates from the calendar picker. With dynamic selectors and fine-tuned actions, the bot navigates the website, enters the location, and accurately selects the specified check-in date and clicks the next chevron icon if needed for future check-out date selection.
Roulette Bot
This repository hosts a bot that employs martingale roulette strategy in an online roulette game. As the game is recognized as an image by UiPath, traditional selectors are not applicable, requiring alternative interaction methods. The bot bets $1 on Even, spinning the wheel, and doubles the bet upon loss until the balance is exhausted. OCR is utilized to analyse the previous spin's number, determining subsequent betting actions based on its odd or even status.
Input Forms Challenge (Modern)
This repository contains a RPA workflow developed with Modern Design in UiPath Studio that is capable of transferring data from a spreadsheet onto dynamic form fields on the screen. The automation challenge requires us to create a workflow that will input data from an Excel spreadsheet into 50 forms where the fields and their labels will dynamically change position on the screen after every submission of a form. My solution in this repository successfully conquered the challenge, achieving 100% accuracy in a mere 262.282 seconds.
Input Forms Challenge (Classic)
This repository contains a RPA workflow developed with Classic Design in UiPath Studio that is capable of transferring data from a spreadsheet onto dynamic form fields on the screen. The Input Forms challenge requires us to create a workflow that will input data from an Excel spreadsheet into a set of forms where the fields will dynamically change position on the screen after every submission of a form. My solution in this repository successfully conquered the challenge, achieving an impeccable 100% accuracy in a mere 16,173 milliseconds.
ACME Invoice Check Bot
This repository hosts a UiPath automation solution structured to tackle a REFramework exercise. The solution comprises two distinct sub-processes: a Dispatcher, entrusted with the task of adding queue items to the Orchestrator queue, and a Performer, adept at searching invoices on the system, extracting relevant invoice data, and comparing it against the queue item data. Leveraging UiPath REFramework, this solution ensures robust automation of invoice checking tasks on the acme-test.com platform, all while adhering to best practices.
ACME Vendor Check Bot
This repository hosts a UiPath automation solution tailored to meet the requirements of a REFramework exercise, including navigating through acme-test.com, extracting full vendor data, searching for vendors through Tax ID, scraping vendor details from the search results, checking if values match, checking for correct city, and ultimately compiling the results into an Excel worksheet. Utilizing datarow as a transaction item within the REFramework, this solution offers a robust workflow for automating vendor checking tasks.
ACME Work Items
This repository contains a robust UiPath automation solution crafted to meet the specified requirements of a REFramework exercise. Utilising URL strings as transaction items within the REFramework, the solution navigates through acme-test.com, scraping data from each page of the Work Items list, applying filtering criteria to extract relevant records, and appending the results into an Excel worksheet, all while ensuring robust error handling and recovery mechanisms are in place.