Getting CEO Data to Flow Back into the Companies Table
Hi Clay team I’m stuck on a workflow and could use some help. I have a Companies table with Company Name, Domain, and LinkedIn URL. When I run Find People at These Companies, it creates a new People table (expected) — but I need the CEO’s Name, Title, and Verified Work Email back in my original Companies table. I’ve tried using lookup columns and running Enrich People (Waterfalls), but I can’t seem to get the CEO data flowing back into the Companies table. What’s the correct way to: Pull only the CEO (or highest executive) for each company, Get their work email enriched/verified, And have it show up inline in the Companies table instead of working from two separate tables? Appreciate any guidance or a step-by-step setup
