Structured Contact Database from a Telegram Chat in 15 Minutes

Problem

A professional HR community in Telegram – 7000+ members. Hundreds of people posted introductions: who they are, where they work, what they do. The client needed these contacts for outreach, but extracting them manually from a stream of free-text messages meant hours of tedious copy-paste work – with inevitable duplicates and gaps.

Solution

AI-powered processing of the chat export:

• Export chat history from Telegram as JSON
• AI extraction – each message analyzed for name, position, company, city, and profile link
• Filtering – automatic removal of non-relevant messages (chat rules, ads, questions without introductions)
• Ready-made CSV – one-click import into Google Sheets or any CRM

Result

• 761 verified contacts from 1115 messages
• 7 fields: name, position, company, city, username, date, link
• 15 minutes instead of ~5 hours of manual work
• CSV ready for import into any CRM