Automation pipeline
Contact pipeline for MCB’s CFO congress
Context
Menadžment Centar Beograd sells places at a congress for finance directors, and needed to reach the people who hold that role across Serbian municipalities. Until then the list was built by hand, with someone reading through public directories for weeks at a time.
Approach
- Scraped the Poverenik public-body registry 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

