Automated Attendance WhatsApp Reporting

Заказчик: AI | Опубликовано: 22.02.2026

I rely on TimeTrack for biometric attendance, which lets me pull the raw log as a CSV file. Twice a day—at 9:30 am and again at 8:45 pm—I need that fresh CSV automatically fed into an existing Excel workbook that already contains a macro‐driven dashboard. After the macro updates the report sheet, only selected cells from that page must be copied and posted to a fixed WhatsApp Desktop group. Here’s the flow I expect the script to cover: 1. Launch or trigger the TimeTrack export and save the newest CSV to a known folder. 2. Open my Excel macro file, replace the old raw data with the latest CSV contents, then let the built-in VBA routine run so the report refreshes. 3. Capture the specific summary range I will indicate (it’s a small, fixed block—no dynamic ranges). 4. Open WhatsApp Desktop, locate the predetermined group, paste the copied range as plain text (formatting can be basic), and hit send. 5. Schedule the entire sequence for the two daily times above without any manual intervention. I am comfortable with Python, PowerShell, or any other reliable automation stack as long as it handles Windows, Excel, and WhatsApp Desktop smoothly. Robust error handling and a concise setup guide are essential so I can tweak file paths or timing later on. Deliverables: • Source script(s) with clear inline comments • A brief README covering prerequisites, setup, and how to edit the schedule • Optional: a lightweight UI or config file for paths, time slots, and group name Once it runs cleanly on my machine and posts the right snippet to WhatsApp twice a day, I’ll consider the job complete.