A dedicated highlight for my strongest automation project: a Python-powered data collection workflow for Seattle Government Permit Data Automation System records, built to reduce manual research, increase weekly data volume, and prepare the data for CRM use.
I built an end-to-end automation that collects active Seattle Government Permit Data Automation System permit/conveyance data, opens each record, extracts key record details, captures related links and status information, then writes structured results into Google Sheets. The workflow is designed for checkpoint/resume runs and can later connect into HubSpot once CRM access is provided.
Reads Government Permit Data Automation System record links from the source list or Google Sheet input so the workflow can process batches consistently.
Uses browser automation to visit each Seattle record page and wait for the record detail sections to load properly.
Captures structured fields such as record information, status, related record URLs, inspections, and attachments where available.
Normalizes the extracted data into clean rows and columns, ready for review, reporting, filtering, and weekly tracking.
Designed with a next phase for HubSpot or CRM transfer once account access and field mapping are provided.