AutoDoc: RTO Document Upload Automation

Job ID: 40286010

Budget: ₹10,000 – ₹12,000 INR

Project Title: RPA Automation for RTO Document Upload (Excel to Web)
Project Description:
I need a robust automation (RPA) solution, preferably using Power Automate Desktop (PAD), to automate the document uploading process on an RTO (Regional Transport Office) portal. The bot needs to handle data from an Excel sheet, match it with local PC folders, and upload documents to the website.
Detailed Workflow:
1. Data Input (Excel Integration):
The bot should read an Excel file containing two primary columns: Vehicle Number and Chassis Number.
It must iterate through each row one by one.
2. Web Navigation & Search:
Open the RTO portal and log in (if required).
Input the Vehicle Number and Chassis Number from Excel into the website's search fields to fetch the specific vehicle's details.
3. Dynamic Folder & File Mapping:
There is a Main Directory on my PC. Inside, there are sub-folders named after each Vehicle Number (e.g., folder "GJ01XX1234").
The bot must enter the corresponding folder for the current vehicle and identify files (RC, Insurance, Fitness, etc.).
4. Conditional Upload & Error Handling:
Successful Upload: If all required documents are found in the folder, upload them to their respective fields on the website and click Submit.
Missing Documents Logic: If a specific document is missing from the folder, the bot should NOT stop. It should:
Upload the available documents.
Trigger a Popup or Log Message identifying which document was missing (e.g., "Insurance missing for GJ01XX1234").
Continue to the next vehicle.
5. Loop & Reporting:
After finishing one vehicle, the bot should automatically move to the next row in Excel.
Status Tracking: Update the Excel sheet in a new column (Status) as "Completed," "Pending," or "Missing [Document Name]" after each process.