AI-Powered Contact Intelligence & Enrichment with OpenAI/Anthropic and Supabase

AI Contact Enrichment 📋 Template Description Overview Automatically enhance and enrich contact data using AI to fill in missing information, generate insights, and create detailed buyer personas. Supports multiple AI providers (OpenAI, Anthropic, etc.) with automatic logging to Supabase. Description This workflow transforms incomplete contact records into rich, actionable profiles. By leveraging AI, it can infer job roles, company information, likely pain points, communication preferences, and buying motivations from minimal input data. Perfect for sales and marketing teams looking to improve data quality and personalize outreach. Key Benefits: - Smart Data Completion: Fill in missing contact fields using AI inference - Buyer Persona Generation: Create detailed profiles from basic information - Universal AI Support: Works with OpenAI, Anthropic Claude, or custom providers - CRM Enhancement: Automatically enrich contacts as they enter your system - Lead Qualification: Assess lead quality and fit based on enriched data - Personalization Engine: Generate insights for tailored outreach - Data Quality: Maintain clean, complete contact records Use Cases: - Sales prospecting and lead enrichment - Marketing persona development - CRM data cleansing and completion - Account-based marketing (ABM) research - Lead scoring and qualification - Personalized email campaign preparation - Contact segmentation and targeting --- ⚙️ Setup Instructions Prerequisites 1. n8n instance (cloud or self-hosted) 2. AI Provider account (OpenAI, Anthropic, or custom) 3. Supabase account with database access Step 1: Configure Environment Variables Add these to your n8n environment settings: Recommended Models: - Cost-effective: gpt-3.5-turbo (fast, affordable, good for basic enrichment) - High-quality: gpt-4 or claude-3-sonnet-20240229 (better inference, deeper insights) - Premium: claude-3-opus-20240229 (best for complex persona generation) How to set environment variables: - n8n Cloud: Go to Settings → Environment Variables - Self-hosted: Add to your .env file or docker-compose configuration Step 2: Set Up Supabase Database Create the logging table in your Supabase database: To run this SQL: 1. Open your Supabase project dashboard 2. Go to the SQL Editor 3. Paste the SQL above and click "Run" Step 3: Configure Supabase Credentials in n8n 1. Go to Settings → Credentials 2. Click Add Credential → Supabase API 3. Enter your Supabase URL and API key (found in Project Settings → API) 4. Name it Supabase API 5. Click Save Step 4: Activate the Webhook 1. Import this workflow into n8n 2. Click the Activate toggle in the top-right corner 3. Click on the "Webhook Trigger" node 4. Copy the Production URL (this is your webhook endpoint) 5. Save this URL for integration with your applications Step 5: Test the Workflow Send a test POST request to the webhook: Successful Response: --- 📥 Expected Payload Format The webhook accepts JSON with basic contact information: Minimal Input Recommended Input Complete Input Example Field Guidelines: - At minimum, provide either email or name - More input fields = better AI enrichment quality - Include linkedinurl for best results - company helps with firmographic enrichment - Any additional context improves accuracy --- 🔄 Workflow Flow 1. Webhook Trigger: Receives basic contact information from your application, form, or CRM 2. Process Data: Adds unique ID and timestamp to the incoming data 3. Prepare AI Request: Configures AI provider settings from environment variables 4. Call AI API: Sends contact data to AI with enrichment prompt 5. Save to Supabase: Archives original data and enrichment results 6. Format Response: Returns success confirmation --- 🎯 Customization Tips Enhance AI Prompts for Better Enrichment Modify the "Prepare AI Request" node to customize enrichment: Add External Data Sources Enhance enrichment with third-party APIs: After "Process Data" node, add: 1. Clearbit/Hunter.io Node: Get verified company data 2. LinkedIn API: Pull professional information 3. Company Database: Query internal customer data 4. Web Scraping: Extract data from company websites Then merge all data before AI enrichment for best results Connect to Your CRM Auto-update contacts after enrichment: Salesforce Integration: HubSpot Integration: - Add HubSpot node to update contact properties - Map enriched fields to custom HubSpot properties Pipedrive Integration: - Use Pipedrive node to update person records - Add custom fields for AI insights Implement Lead Scoring Add scoring logic after enrichment: Add Compliance Checks Insert before AI processing: Batch Enrichment Process multiple contacts: 1. Add Spreadsheet File trigger instead of webhook 2. Add Split In Batches node (process 10-20 at a time) 3. Run enrichment for each contact 4. Combine results and export to CSV --- 🛠️ Troubleshooting Common Issues Issue: "Enrichment is too generic" - Solution: Provide more input data (company, job title, LinkedIn) - Use GPT-4 or Claude models for better inference - Enhance the system prompt with specific instructions Issue: "AIAPIKEY is undefined" - Solution: Ensure environment variables are set correctly - Verify variable names match exactly (case-sensitive) Issue: "Enrichment contradicts actual data" - Solution: AI makes inferences - always validate critical information - Add validation step to check enriched data against known facts - Use external APIs for verification Issue: "Too slow for real-time use" - Solution: Implement queue system for async processing - Use faster models (gpt-3.5-turbo) for speed - Process in batches during off-peak hours Issue: "Supabase credentials not found" - Solution: Check credential name matches exactly: "Supabase API" - Verify Supabase URL and API key are correct Debugging Tips 1. Test with known contacts first to validate accuracy 2. Compare AI enrichment against actual data 3. Check execution logs for API errors 4. Start with minimal prompt, then enhance gradually 5. Use "Execute Node" to test individual steps --- 📊 Analyzing Enriched Data Query and analyze your enriched contacts: Export Enriched Data --- 📈 Integration Ideas Form Integration Automatically enrich new leads from forms: - Typeform: Trigger on form submission - Google Forms: Use Google Sheets trigger - Calendly: Enrich after meeting booking - Webflow Forms: Webhook trigger from form CRM Integration Real-time enrichment as contacts enter CRM: - Salesforce: Trigger on new lead/contact creation - HubSpot: Enrich on form submission or import - Pipedrive: Auto-enrich new persons - Close: Webhook on lead creation Email Tools Enhance cold outreach campaigns: - Instantly.ai: Enrich before campaign launch - Lemlist: Generate personalization variables - Apollo.io: Supplement with AI insights - Mailshake: Enrich prospect lists Marketing Automation Power ABM and segmentation: - Marketo: Enrich leads for scoring - Pardot: Enhance prospect profiles - ActiveCampaign: Personalization data - Klaviyo: E-commerce customer insights Slack Integration Team notifications and collaboration: - Send enrichment summaries to sales channel - Notify reps of high-value leads - Share persona insights with marketing - Alert on key account contacts --- 🔒 Security & Compliance Best Practices Data Protection 1. Encrypt Sensitive Data: Use environment variables for all credentials 2. Access Control: Limit webhook access with authentication 3. Data Retention: Set automatic deletion policies in Supabase 4. Audit Logging: Track all enrichment activities Privacy Compliance 1. GDPR Compliance: - Get consent before enriching personal data - Allow contacts to request data deletion - Document legal basis for processing 2. CCPA Compliance: Honor do-not-sell requests 3. Data Minimization: Only enrich necessary fields 4. Right to Access: Allow contacts to view enriched data AI Ethics 1. Bias Awareness: Review AI inferences for bias 2. Accuracy Validation: Verify critical information 3. Transparency: Disclose use of AI enrichment 4. Human Oversight: Review before critical decisions --- 💡 Best Practices Input Data Quality - Always include email or full name as anchor point - Add LinkedIn URLs for 50% better accuracy - Provide company name for firmographic insights - Include any known details - more data = better results Prompt Engineering - Be specific about your ideal customer profile (ICP) - Request structured output (JSON format) - Define scoring criteria that match your business - Ask for actionable insights not just descriptions Post-Enrichment Workflow - Always validate critical information before use - Review AI inferences for accuracy and bias - Update CRM promptly to maintain data freshness - Track enrichment ROI (conversion rates, time saved) Performance Optimization - Batch process during off-peak hours - Use appropriate models (gpt-3.5 for speed, gpt-4 for quality) - Cache common enrichments to reduce API costs - Set rate limits to avoid API throttling --- 🏷️ Tags sales-automation, lead-enrichment, ai-automation, crm-integration, data-enrichment, contact-intelligence, buyer-personas, lead-scoring, webhook, supabase, openai, anthropic, b2b-sales --- 📝 License This workflow template is provided as-is for use with n8n. 🤝 Support For questions or issues: - n8n Community Forum: - n8n Documentation: 🌟 Example Output Input: AI-Generated Enrichment: --- 🔄 Version History - v1.0.0 (2025-01-14): Initial release with universal AI provider support