G
GTM Vault
Browse
  • Dashboard
    • Automations
    • Skills
    • Prompts
    • Makers
  • Sign in
All Automations

AI-powered lead generation with Apollo, GPT-4, and Telegram to database

Converts voice commands to verified prospect lists using Apollo.io scraping, AI extraction, and automated database storage.

workflowlead_generation
Paulby Paulon n8n
Nodes

28

Triggers

1

Platform

n8n

Tech Stack
Telegram
Telegram
OpenAI
OpenAI
AI Agent
Postgres
Postgres
Supabase
Supabase
Apify
Apify
How It Works

This workflow processes voice or text input to extract lead generation criteria using AI, automatically scrapes Apollo.io for prospects, and stores verified contact data in your database. The system filters for verified emails only and prevents duplicates by checking against existing records.

1

Process voice or text input via Telegram

Receives voice messages or text commands through Telegram and converts audio to text using OpenAI transcription API.

2

Extract search parameters with AI

AI agent analyzes the input to identify location, industry, job titles, and other search criteria for lead generation.

3

Build Apollo.io search URL

Constructs dynamic search URLs based on extracted parameters to query Apollo.io for matching prospects.

4

Scrape prospect data from Apollo.io

Retrieves contact information, job details, and company data using Apollo.io API integration.

5
Attached Files
workflow.json

Filter and verify contact information

Filters results to include only verified email addresses and checks against existing database to prevent duplicates.

6

Store leads in database

Saves new prospects with complete profile information to PostgreSQL or Supabase database and sends confirmation notification.

What You'll Need

TelegramOpen AiPostgreSQLApify
  • Telegram bot token and account setup
  • OpenAI API key for transcription and AI processing
  • Apollo.io account with API access
  • PostgreSQL or Supabase database credentials
  • Apify account for web scraping capabilities

This automation has 6 configurable settings you'll customize during setup.