{"product_id":"ai-lead-gen-n8n-workflow-apollo-gpt-4-telegram-to-postgres","title":"AI Lead Gen n8n Workflow: Apollo + GPT-4 + Telegram to Postgres","description":"\u003ch3\u003eTurn voice or text into verified leads—automatically\u003c\/h3\u003e\n\u003cp\u003eThis AI Lead Gen n8n workflow converts your voice messages or text prompts into prospect search criteria, scrapes lead data from \u003cstrong\u003eApollo.io\u003c\/strong\u003e, filters for \u003cstrong\u003everified emails\u003c\/strong\u003e, and automatically stores clean results in \u003cstrong\u003ePostgreSQL\/Supabase\u003c\/strong\u003e. Powered by \u003cstrong\u003eGPT-4\u003c\/strong\u003e and delivered via \u003cstrong\u003eTelegram\u003c\/strong\u003e, it’s a streamlined way to build high-quality contact lists with less manual work.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cp\u003eHere’s the exact process:\u003c\/p\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAccept flexible input:\u003c\/strong\u003e Send a request through Telegram as a \u003cem\u003evoice message\u003c\/em\u003e or \u003cem\u003etext\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eConvert voice to text:\u003c\/strong\u003e Uses \u003cstrong\u003eOpenAI’s transcription API\u003c\/strong\u003e to translate audio into text.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtract search parameters with AI:\u003c\/strong\u003e An AI agent interprets your natural language request and pulls out criteria like \u003cstrong\u003elocation\u003c\/strong\u003e, \u003cstrong\u003eindustry\u003c\/strong\u003e, and \u003cstrong\u003ejob title\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerate Apollo scraping queries:\u003c\/strong\u003e The workflow builds search URLs dynamically from the extracted parameters and runs scraping using the \u003cstrong\u003eApollo.io API\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eVerify and clean results:\u003c\/strong\u003e Keeps \u003cstrong\u003everified emails only\u003c\/strong\u003e, prevents duplicates by comparing against your existing database, and ensures data quality control.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStore leads in your database:\u003c\/strong\u003e Automatically inserts structured contact profiles into \u003cstrong\u003ePostgreSQL\/Supabase\u003c\/strong\u003e with real-time updates.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eRequest “Find HR managers in Austin in tech” via Telegram and instantly populate your CRM table in PostgreSQL.\u003c\/li\u003e\n  \u003cli\u003eGenerate weekly prospect lists for outreach campaigns using GPT-4-based lead criteria parsing.\u003c\/li\u003e\n  \u003cli\u003eReduce manual lead research by automating Apollo.io lead scraping + verified email filtering.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n workflow nodes:\u003c\/strong\u003e set, code, no op, limit, filter, switch\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI:\u003c\/strong\u003e OpenAI transcription API (voice-to-text) and GPT-4 (parameter extraction)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Apollo.io (official API), Telegram, PostgreSQL\/Supabase for lead storage\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45742838251699,"sku":"N8N-5611","price":44.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/AD717d0c4PDcoe9Hc22vv_vdJR6JhC.png?v=1785403025","url":"https:\/\/buyflowscripts.com\/products\/ai-lead-gen-n8n-workflow-apollo-gpt-4-telegram-to-postgres","provider":"N8N Commerce","version":"1.0","type":"link"}