Enrich Procurement Contacts from Company IDs with Apollo, Sheets & Telegram

This workflow automates the enrichment of procurement contacts using company IDs stored in a Google Sheet. Triggered on a schedule, it identifies unprocessed companies, retrieves Apollo Company IDs, applies smart filters for procurement roles (manager/head/lead/director), and queries Apollo's mixed_people/search and people/match APIs to fetch verified emails and phone numbers. Enriched data is written back to the sheet, processed companies are marked to prevent duplicates, and the team receives Telegram notifications for new leads.

Key benefits include massive time savings by eliminating manual research, cleaner data with title/seniority and email status filters to reduce noisy leads, and improved outreach success with ready-to-use contacts. It turns hours of scavenger hunts into minutes, providing a competitive edge for sales teams targeting procurement in e-commerce fulfillment.

Perfect for outbound/BDR teams needing outreach-ready contacts and data ops/growth teams maintaining lead pipelines. Ideal for e-commerce shipping & fulfillment by sourcing supplier/procurement contacts efficiently.

Setup involves configuring Google Sheets credentials, Apollo API key, and Telegram bot. The workflow uses code nodes for intelligent title conversion and filter building, ensuring precise, high-quality enrichment.