Rpa Projects

Download as pdf or txt
Download as pdf or txt
You are on page 1of 7

RPA PROJECTS

(CA2)
1. Input form on rpachallenge.com
(Download the excel file from the site)
1.The goal of this project is to create a workflow that will input data from a
spreadsheet into the form fields on the screen.
2. Beware! The fields will change position on the screen after every submission
throughout 10 rounds thus the workflow must correctly identify where each
spreadsheet record must be typed every time.
3. The actual countdown of the challenge will begin once you click the Start button
until then you may submit the form as many times as you wish without receiving
penalties.

2. Movie Search on rpachallenge.com

1. The goal of this project is to create a workflow that will check which movie review
is positive or negative.
2. Add 3 movies to your list in order to start the challenge. You can either search for
them or get a list of 3 popular movies
3. Click on each movie in your Movie List in order to see the reviews. Check each
review and see if it is positive or negative. Once you have checked all the reviews,
press on Submit in order to see your score.

3. Download Reports from NSE


(https://nseindia.com/corporates/content/eq_research_reports_listed.htm)

Use the above link and download the reports of all the companies in a folder on the
desktop using AA.

4. Find out the best price of items from e commerce websites.

1. Use any three ecommerce websites- jiomart, big basket, grocers etc.
2. Create an excel as shown below, price of item from 3 sites and find out the best
price
5. Extract book names from Amazon
Type the name of the book and extract the details of the book available only in Kindle
edition and save in excel file.

6. Sales ordering Processing


Organizations generate a sales order (SO) on receiving a purchase order (PO), which is
an intent to buy one or more items. The PO specifies the product or service that a
customer would like to purchase. The SO is used for inventory and order management.

For this automation project, we will take order data from an Excel spreadsheet and
input it into the Orders app in Apptivo – cloud-based business management software.

7. File copy
Create 7 folders names as ABCD, EFGH, IJKL, MNOP, QRST, UVWX, YZ
There is one folder containing 26 files. First file name starts from A, second B and last
file Z. Files should be copied into the folders where first character of file matches with
the characters present in the folder.

8. Find out the best price of hotel names from websites.

1. Use any three ecommerce websites- booking.com, makemytrip.com etc.


2. Create an excel as shown below, price of hotel rooms from 3 sites and find out the
best price

9. PDF to excel
You are given 5 pdf files that contain data of employees, copy the data from those files
into an excel file. Make the form fields like Given name, address etc as column names
of the excel and values of the form will be used as the data in the rows.

10. Get File and Folder Information

Create a bot that displays information about a file or a folder, such as modification date
and time, sub-folders count, file size, and more

11. Course Selection


Create a bot that helps you to find out the best course on Udemy on machine learning,
data science and data structures and algorithms based on rating, if rating is same, then
on the basis of max. enrollment.

12. Notepad to excel

You are given one txt file, first line contains the name of the person, second line
contains the email address and last line password.

Copy the complete data into an excel file for all persons as shown below:
Then use the data of first person to do sign up on surveymonkey.com.
Username name will be initials+ todays date

13. Notepad to excel

Take one notepad containing data in the following format.

Copy this data into the excel in the given format.

If the marks of the student is greater than equal to 40, then overall result is pass otherwise
fail.
14. Excel to excel + email

You are given an excel sheet in the following format

Add one column after date column Total sale which will take the multiplication of unit sold
and sale price. Last row of this column should contain the total sum of the total sales.
Group all the data based on segment like all midmarket data should come first, then all small
business, government, Enterprise into four excels named as midmarket, small business,
government, enterprise and mail each sheet to 4 different concerned people.
15. Car Buyer Bot - CarGurus.com
CarBuyerBot was created to allow users to compare vehicle listings across model
years by using a Price Per Remaining Mile formula on each listing. Read search
criteria from a CSV file. Search CarGurus.com for vehicle listings matching input file
criteria. Record all matching search results to spreadsheet. Apply
"PricePerRemainingMile" formula to each listing.

16. SMS Weather Alert


Daily weather notification bot with custom SMS message functionality using Twilio.
Send daily automated weather updates for your office location on phone.

Tasks
Uses an API to get current location. Retrieves current weather data from an
open-source weather API.Sends text messages directly from your bots using the Twilio
SMS platform. Use of Python script to send the SMS. This bot retrieves the current
weather report and sends the report to employees via SMS. Gives the Weather Data
Report. Automatically detects the office location where BOT runs. Sends SMS to
employees with current weather data. Daily Weather Notification with Custom SMS
message functionality

17. Nearest Place Search using Google Maps

The bot fetches place information on a variety of categories such as establishments,


points of interest, geographic locations, etc using Google Maps Places API

Tasks
Takes input from user (Search query string and Zip code). Queries Google Maps Place
Search API.Fetches results in a message box. Indicates the end of search result through
a message box. Stores all search results in an excel file

Input: Bot prompts the user to enter the query string such as establishments,
prominent points of interest, geographic locations, and Zip code.

Action: Bot queries Google Maps Place Search API, retrieves the results nearest to the
Zip code entered, and displays in a message box, also show a message box indicating
the end of search results.

Output: Bot stores all the results in an excel spreadsheet. The results are quick,
efficient, and accurate. Instead of searching for places manually just provide the type
of place that you are looking for and the Zip code, the bot instantly searches for the
area and also saves the result into an excel spreadsheet.

18. Calculate the First and Last Day of Last Month

This bot calculates the first and last days of the previous and next month and outputs
them to the clipboard.
Input – Enter the month
19. Image Scraper Bot
This Bot will download images from Google Images Search. It takes 3 inputs from the
end-user, how many images to download, where to put then and search keywords

20. Linkedin DailyPost

This Bot will get the post image and read the post content from the folder and create a
new post in linkedin on daily basis.

21. Update a PowerPoint Presentation


This bot helps to generate new or update exiting presentation using Microsoft
PowerPoint.
Tasks
Bot reads the existing presentations and command required to be inserted in PP. Bot
updates the presentation as per the input. PowerPoint facilitates the need for focused
and well-defined presentations. Presentations can be a visual treat with the accurate
usage of multimedia. This bot helps to generate the presentation using Microsoft
PowerPoint within not time. This bot can add text, shapes, and images to the PPT.

22. GST Rate Calculator

The Bot is used for calculating GST Rate, inclusive/exclusive to the item with respect
to its' amount. Consider all the items.

23. Gathering Data on Indiamart.com by Keyword

The bot can monitor a mailbox. Once there is an incoming mail in a certain format, it
will trigger the bot to collect info online according to a given keyword.

24. Covid-19 Vaccine Information Extraction


This bot extracts information regarding the availability of the Covid-19 vaccine, such
as the date, center ID, address, state, slots, count of dose 1 & dose 2, via the user's pin
code.

25. Youtube Downloader


This bot is designed to download Youtube videos to your system's specified location
using Python script
Tasks
Fetch the Youtube URL from the Excel file using loop command. Passes the URL as
argument to the Python function. Easily download multiple videos to provided output
folder.

You might also like