Hello UiPath Community,
I would appreciate your support and guidance for a UiPath automation project I am building.
Objective:
Extract attendance information only from a WhatsApp exported chat file stored in OneDrive, then generate a structured Excel attendance report.
Current Process:
- WhatsApp group chat is exported manually.
- Exported .txt file is automatically saved into OneDrive.
- UiPath starts the process by reading the file from OneDrive.
- UiPath should extract only attendance-related information.
- Final output should be a clean Excel report.
The WhatsApp group is used mainly for:
- Attendance updates
- Leave notifications
- WFH notifications
Examples of attendance codes:
- AL = Annual Leave
- SL = Sick Leave
- USL = Unscheduled Leave
- EL = Emergency Leave
- MC = Medical Certificate
- WFH = Work From Home
Expected Excel Output Columns:
- Date
- Employee Name
- Attendance Type
- Details/Remarks
- Time (optional)
Important:
- Ignore non-attendance chat messages such as congratulations, greetings, photos, general discussions, etc.
- Some messages contain mixed text and attendance details.
- Attendance messages are not always standardized.
Sample examples:
29/04/2025, 11:58 am - Taylor White:42 pm - Group creator created group " Accounting Team"
29/04/2025, 11:59 am - Chris Wilson: Hey colleagues. Very Happy to join the team
29/04/2025, 1:33 pm - Avery Brown: USL (pm)
30/04/2025, 9:41 am - Morgan Brown:52 am - Drew Clark added Alex Martinez
30/04/2025, 4:41 pm - Drew Lewis: Beautiful photos. Thank you @~Alex Brown
30/04/2025, 9:07 pm - Jamie Harris: Apologies. I flew to India on Saturday that’s why I have forgotten to update the WhatsApp group.
AL 28TH APRIL 2025 TO 9TH MAY 2025 TO ALMOST NO INTERNET CONNECTION.
02/05/2025, 2:55 am - Alex Brown: AL
02/05/2025, 6:41 am - Hayden Lewis: AL
02/05/2025, 8:00 am - Cameron Lee: USL
03/05/2025, 4:22 pm - Cameron Lee: hi everyone, please come if you guys are free 
03/05/2025, 4:23 pm - Alex Martinez: Congratulation Nadia!
03/05/2025, 4:24 pm - Taylor Jackson: Congratulations @Cameron Lee
03/05/2025, 4:24 pm - Drew Wilson: Congratulation haLewis
03/05/2025, 4:24 pm - Hayden Lewis: Congrates @Cameron Lee
03/05/2025, 4:24 pm - Jamie Jackson: Congratssss Nadia
03/05/2025, 4:26 pm - Cameron Lee: thank you
03/05/2025, 4:28 pm - Riley Smith: @Cameron Lee congratulations!
03/05/2025, 4:47 pm - Morgan Moore: Tahniah @Cameron Lee
03/05/2025, 5:07 pm - Casey Lee: Congratulations Lewis !
03/05/2025, 5:08 pm - Drew Clark: Congratulations Cameron Leeh , May Allah bless you and grant you happy marriage .
03/05/2025, 5:13 pm - Morgan Martinez: congrats Lewis 
03/05/2025, 5:18 pm - Riley Moore: Congrats Lewis!
03/05/2025, 5:25 pm - Cameron Lee: thank you all
03/05/2025, 5:26 pm - Alex Brown: Congratulations Lewis
03/05/2025, 5:53 pm - Drew Lewis: Congratulations @Cameron Lee 
03/05/2025, 5:58 pm - Cameron Lee: thankss
03/05/2025, 6:30 pm - Casey Davis: congratulations @Cameron Lee 
03/05/2025, 6:45 pm - Jamie Harris: Congratulations @Cameron Lee
03/05/2025, 7:02 pm - Taylor Smith: Congratulations @Cameron Lee 
03/05/2025, 7:05 pm - Cameron Lee: thankss
05/05/2025, 5:49 am - Casey Davis: AL 5-6/5
05/05/2025, 6:35 am - Jamie Jackson: AL
05/05/2025, 8:22 am - Riley Moore: AL
Questions:
- What is the best UiPath approach for this scenario?
- Should I use:
- Regex
- Document Understanding
- Communications Mining
- IXP
- Generative AI
- What is the best way to filter only attendance-related messages?
- How can I normalize inconsistent attendance text?
- What is the best architecture for:
OneDrive TXT File → UiPath → Attendance Extraction → Excel Report - Any sample workflows or reusable components available?
I attached an anonymized sample WhatsApp export file.
Thank you very much for your support.