Push Final Enriched Profile to CRM

Workflow Overview: Finalize and Archive Enriched Leads This workflow acts as the final stage in a sophisticated lead enrichment pipeline. Its primary function is to identify when a lead has been fully processed and enriched by other systems (likely including AI), and then transfer this completed profile from a temporary "working" sheet to a permanent, clean "master" database. It effectively automates the final data management step, ensuring the master CRM only contains complete and valuable lead information. Technologies Used - n8n: The core automation platform coordinating the data flow. - Google Sheets: Used as both the source "working" database and the destination "master" CRM. How AI Integrates Into the Flow While this specific workflow does not contain an AI node itself, it is designed to handle and process data that has been generated by AI in previous steps. The input data fields it maps—specifically Recent Posts Summary and Linkedin Profile Summary—are clearly the result of an AI model analyzing a lead's raw LinkedIn data and generating concise, human-readable summaries. This workflow's role is to act as a gatekeeper, waiting until the AI enrichment tasks are flagged as complete. It then takes this valuable, AI-generated intelligence and archives it into a structured, final database. In essence, the AI creates deep, personalized insights about each lead, and this automation ensures those insights are properly stored and organized for use in sales or marketing outreach. Node-by-Node Analysis H3: Google Sheets Trigger: On New Lead Entry - Node: Google Sheets Trigger5 - Purpose: This node initiates the entire workflow. It constantly monitors a Google Sheet named "apollo ai leads" for new rows. - Functionality: It polls the sheet every minute. When a new row is added (representing a new lead entering the enrichment pipeline), this workflow triggers. This ensures that the system immediately becomes aware of new leads that need to be monitored for completion. H3: Google Sheets: Find Fully Enriched Profile - Node: Get Completely Enriched Profiles - Purpose: This is the critical "gatekeeper" step.