Customer Code Validation Automation (UiPath)

This project is a UiPath automation that reads customer registration data from an Excel file, validates the submitted product codes, and sends email notifications based on the validation result.

---

Overview

The automation processes customer records and ensures that each submitted code follows a predefined format. Based on the validation outcome, it automatically notifies the customer via email.

This reduces manual verification effort and ensures consistency in handling registration data.

---

Validation Logic

The submitted code must follow this format:

PRD-1234AB

Where:

• PRD- → fixed prefix
• 1234 → numeric digits
• AB → uppercase letters

If the format is correct → Valid
Otherwise → Invalid

---

Workflow Steps

1. Read customer data from Excel file
2. Iterate through each record
3. Validate the registration code format
4. If valid → send success email
5. If invalid → send correction email

---

Sample Input

Excel file contains:

• Customer Name
• Code Submitted
• Email Address

---

Sample Output

• Valid → "Registration Successful" email
• Invalid → "Invalid Code" email

---

Key Features

• Excel data processing
• Format-based validation logic
• Automated email notifications
• Handles multiple records in a single run
• Structured and reusable workflow

---

Project Structure

• Main.xaml → Main workflow
• project.json → Project configuration
• Data/ → Input Excel file

---

Technologies Used

• UiPath Studio
• Excel Automation
• Email Automation (Outlook / Office 365)

---

Use Case

This automation can be used in:

• Product registration systems
• Customer onboarding validation
• Data quality verification processes

---

Author

Goutham K