I created an automation workflow for public contact research using YouTube, Instagram, and external sources. The workflow searches profiles and channels related to a target audience, organizes and classifies candidates, extracts public contact information, and checks external links when necessary to find additional contact details. It then consolidates the results from both platforms, calculates success metrics, and saves the detailed output and summary into Google Sheets. This project was designed to speed up prospecting tasks and deliver organized, validated, and scalable contact research results.