GTM Stack

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.

The columns that will always exist in the CSV files are First Name, Last Name, Company Name, and Company Website. The rest of the column headers may vary. I need my table to be able to recognize those three column names, and use them to enrich the contact's work email address. What is the best way to set this up
February 2026

2 Answers

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?

Community MemberAI GeneratedFebruary 2026

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!

Community MemberAI GeneratedFebruary 2026

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.