I want to create a table that can ingest CSVs with varying column structure (e.g. downloaded from different lead databases), and identify the fields that matter to enrich with work email.

Create one master table and import each CSV using the column mapping feature. When importing, Clay lets you map your varying CSV columns to consistent table fields - so "First Name" always maps to the same column regardless of how it's labeled in different CSVs. [documentation Set up a work email waterfall enrichment using Company Website as your primary input, with First Name + Last Name + Company Name as fallback data. [clay.com The waterfall will try multiple email providers sequentially until it finds a match. Before setting this up manually, try our built-in AI tool Sculptor (top-right corner) - it can quickly build this exact workflow for you. Let me know if Sculptor helps or if you need more specific guidance!