Automation pipeline
Contact pipeline for MCB’s CFO congress
Context
Menadžment Centar Beograd is a Serbian management training and consulting firm. It sells places at a congress for finance directors, and needed to reach the people who hold that role across Serbian municipalities. The list was built by hand: interns going through public directories page by page, for weeks at a time. I was put on the same task, worked out roughly how many pages that came to, and took the view that it belonged to a script rather than a person.
Approach
- Scraped the national registry of Serbian public bodies (Poverenik) in full, turning scattered pages into one structured list of municipal contacts.
- Resolved organisation records into named contacts through the RocketReach API.
- Added a Gemini-based classification step to sort organisations by what they actually do, from their public descriptions.
- Wrote results straight into Excel with openpyxl, in the format the team already worked in.
- Generated the org-chart presentations automatically with Spire.Presentation, replacing manual slide assembly.
- Handled SEO configuration for mcb-online.rs alongside the pipeline work.
Outcome
Roughly a month of manual list-building removed. The team gets a finished spreadsheet and a finished deck, not an export somebody still has to clean up.
- Python
- RocketReach API
- Gemini
- openpyxl
- Spire.Presentation



