ROCKGOWTHAM – 73772114187
Digital ID Card Automation project using UiPath:
1. Set up your project environment:
- Install UiPath Studio and configure necessary settings.
- Create a new project and set up the necessary folders.
2. Read Student Details Excel File:
- Use the "Read Range" activity to read the details of students from the Excel file.
- Store the data in a DataTable variable.
3. Iterate Through Each Row:
- Use a "For Each Row" activity to iterate through each row of the DataTable.
4. Fill Details in ID Card Template Excel File:
- Inside the loop, use activities like "Excel Application Scope" to open the ID card template Excel
file.
- Use Excel activities to fill in the details from the current row of the DataTable into the template.
5. Convert Excel to PDF:
- Utilize activities to convert the filled Excel template to PDF format.
6. Send Email with PDF Attachment:
- Use the "Send SMTP Mail Message" activity to send an email to the student.
- Attach the generated PDF to the email.
- Retrieve the student's email address from the current row in the DataTable.
7. Check for Errors:
- Implement error handling to check if there are any issues in the generation of the ID card.
- If there's an error, send a Google Form link for corrections.
8. Google Form Correction Process:
- Use the "Send SMTP Mail Message" activity to send the Google Form link to the student for
corrections.
9. Web Scrape Google Form Responses:
- Set up web scraping activities to extract responses from the Google Form.
- Store the responses in a DataTable.
10. Iterate Through Form Responses:
- Use a "For Each Row" activity to iterate through each response from the Google Form.
ROCKGOWTHAM – 73772114187
11. Repeat ID Card Generation for Corrected Responses:
- Repeat the process of filling details in the ID card template, converting to PDF, and sending
emails for corrected responses.
12. Finalize and Document:
- Implement any necessary finalization steps.
- Document your workflow, including variables, activities, and dependencies.
13. Test the Workflow:
- Perform thorough testing to ensure the workflow functions as expected.
14. Run the Automation:
- Execute the automation to process all student details, generate ID cards, and handle corrections.
15. Monitor and Maintain:
- Monitor the automation process and make any necessary updates or adjustments.
- Ensure that email, PDF, and Google Form services are accessible and functional.
SCREENSHOTS :-
ROCKGOWTHAM – 73772114187
ROCKGOWTHAM – 73772114187
ROCKGOWTHAM – 73772114187
ROCKGOWTHAM – 73772114187
ROCKGOWTHAM – 73772114187
INPUT :-
ROCKGOWTHAM – 73772114187
OUTPUT :-
ROCKGOWTHAM – 73772114187
AFTER ERROR CORRECTION :-
