AI search for B2B companies and relevance verification

Task
The client maintains a database of potential clients in Google Sheets and uses Apollo to find contacts, but managers were spending time on manual duplicate checks, company enrichment, and prioritization. It was necessary to automate: filtering new companies, enrichment through Apollo, prioritization using AI, and creating clear tasks in the form of updated rows in the table and notifications in Telegram.

Solution
I built a multi-step workflow in n8n that responds to any changes in Google Sheets. The automation checks whether the company is new or already in the database, calls the Apollo API for data enrichment, iterates through each record, and passes the information to the AI model (via OpenRouter) along with a prompt instruction. The AI determines the priority and generates a structured response, which is transformed into clear fields for updating the second sheet through the Structured Output Parser. After updating the row, the system sends a ready message with key information and status to Telegram, so salespeople can immediately see whom to prioritize.

Result
The client received a fully automated cycle: added/updated a company in Google Sheets — the system automatically checked for duplicates, extracted data from Apollo, evaluated the lead through AI, updated the structure in the table, and sent a clear task to Telegram. This eliminated manual routine, reduced the number of errors, sped up the response to new leads, and provided a transparent, reproducible process for prioritizing B2B contacts.