*What I built:*
A simple workflow that pulls leads from Apollo.io and drops them into a spreadsheet. Originally planned to layer in Google Maps data via SerpAPI, but given the ongoing legal gray area there, I decided it wasn’t worth the risk.
*What broke (and how I fixed it)*
Ran into API issues with Apollo—they renamed a key endpoint, which caused failures in the integration. After some troubleshooting, I standardized everything under a master API key to stabilize it.
*What I improved*
Built a simple internal search tool with a login layer. The team can select an industry and export leads on demand instead of relying on constant automation.
This solves a real issue: automated lead flow without accountability tends to create backlog, not revenue. Now I can track who’s pulling what, and get visibility into how pipelines are actually being filled.
*Takeaway*
Solid first pass. More importantly, it forced me to think through how automation fits into real workflows—not just how to generate leads, but how they actually get worked.