Rpa Projects
Rpa Projects
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.
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.
Use the above link and download the reports of all the companies in a folder on the
desktop using AA.
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.
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.
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.
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
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
If the marks of the student is greater than equal to 40, then overall result is pass otherwise
fail.
14. Excel to excel + email
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.
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
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.
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
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.
The Bot is used for calculating GST Rate, inclusive/exclusive to the item with respect
to its' amount. Consider all the items.
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.