Case Study

Power Automate Desktop RPA Web Scraping Bot

Our client was manually visiting a website, extracting candidate information record by record, and downloading associated files one at a time. This process consumed enormous staff hours, introduced frequent errors, and simply could not keep up with their daily data volume. They needed the entire workflow automated so it could run hands-free. To transform this bottleneck into a completely hands-free, automated workflow, they teamed up with Artesian Software Technologies.

We built a fully automated Robotic Process Automation (RPA) solution using Power Automate Desktop. The custom bot automatically launches Microsoft Edge, logs into the system, navigates candidate records, and extracts required data via web scraping. It then downloads associated files into a dynamically created local folder structure, handling errors instantly with On Block Error mechanisms and Office 365 email alerts. It now runs 24/7 without any human involvement.

RPA Platform

Power Automate Desktop

Browser Automation

Microsoft Edge (Web Scraping)

Email Notifications

Office 365 Outlook

Web Interaction

UI Element Detection & Emulated Typing

File Management

Dynamic Local Folder Structure

Error Handling

On Block Error & Try/Catch Flow

The Challenge

  • Massive Volume of Data: Manually opening profiles, copying details, and downloading files took hours daily and simply could not scale with the growing data volume.

  • High Human Error Rates: Staff copying data manually frequently missed fields or pasted wrong values, making the data unreliable and requiring constant correction.

  • No Automated Session Management: Every session required a manual login and mid-session role switching, with no automated way to handle credentials or timeouts.

  • Disorganized File Storage: Downloaded files landed in a disorganized pile with no consistent naming or per-candidate folders, making retrieval slow and error-prone.

  • Zero Failure Detection: Missing files, page timeouts, or login failures went completely undetected until someone manually noticed that data was missing.

Our Solution

  • Automated Edge Authentication: Configured the bot to launch Microsoft Edge, authenticate using a CSV table via emulated typing, and handle role switching in under 60 seconds.

  • Continuous UI Web Scraping: Utilized UI element detection to scrape candidate fields and loop through records continuously, running 24/7 without manual pagination.

  • Dynamic File System Routing: Implemented automated file downloads that instantly generate structured local directories for each candidate on-the-fly.

  • On Block Error Telemetry: Wrapped the flow in an On Block Error handlers to cleanly close failed sessions, capture exact error logs, and send immediate Office 365 SMTP alerts.

  • Resilient Conditional Architecture: Architected the flow with conditional branching and DOM-aware wait states to effectively manage asynchronous page loads and varied URL parameters.

Business Impact

  • 85% Reduction in Data Extraction Time: The bot completes hours of manual browsing in a fraction of the time, running continuously without breaks or speed limits.

  • Near-Zero Data Errors: Automated UI detection and typing completely removed copy-paste errors, ensuring perfectly accurate candidate extraction every run.

  • 24/7 Continuous Operation: Data and files are pulled day and night without human involvement, guaranteeing the team always has the most up-to-date information.

  • Instant Failure Alerts: Office 365 email notifications immediately flag exact error messages, completely eliminating silent data gaps and missed extractions.

  • Perfectly Organized File Storage: Dynamic per-candidate folder creation ensures every downloaded file is instantly structured, requiring zero manual file management.

Client Testimonial

Our team was burning through hours every single day just manually downloading files and scraping data. The bot the Artesian team created completely took that off our plate. It signs in, fetches all the records, and sorts the files without us lifting a finger. It runs quietly in the background, and we only get pinged if there’s an issue. We honestly don’t even have to think about it anymore! — Head of Data & Candidate Operations

Project Screenshots

Automated Workflow & Power Automate Projects

Here are our proven automation solutions, showcasing robust workflow designs and cross-platform integrations.

Transform Your Ideas into Reality

Your creativity inspires endless possibilities for what we can build together!
Talk to our experts
Scroll to Top