If you still need help setting up your table to handle varying CSV column structures and enrich work emails, I’m here to assist. Would you like to provide more details about your specific setup or any challenges you’re facing?
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.
2 Answers
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!
Disagree or spot an error? Submit a correction here. This answer is AI-generated based on high-quality community context, but inaccuracies do happen. Your feedback helps us maintain the best information.
Add your take
Have experience with the tools discussed here? Share your honest opinion.