ASVP Automation Bot (n8n + Google Workspace)
I created a bot that automates data collection from the ASVP government portal, which is protected by a CAPTCHA. The bot reads case numbers from Google Sheets, opens the site, solves the CAPTCHA manually (with a pause), and logs in. It scrapes decisions and documents, saves them in Google Sheets, and uploads files to Google Drive with clickable links.
I added smart delays to avoid IP blocking (40s per file, 5min per case) and error detection for login and download issues. This replaced a repetitive manual process with a safe, automated solution.
I added smart delays to avoid IP blocking (40s per file, 5min per case) and error detection for login and download issues. This replaced a repetitive manual process with a safe, automated solution.