GTM Stack

I have a leads table with 5k rows. I ran email enrichment through an external API, and the vendor sent back a CSV with 1,000 verified emails.

I need to merge those emails back into my existing Clay table. The shared key between the two datasets is LinkedIn URL. What's the cleanest way to do this in Clay? Lookup column from an imported table, or a something else
February 2026

4 Answers

The table ID isn't visible in that dropdown menu. You can find it in your browser's URL bar when you have the table open - it's the string of characters after /tables/ in the URL. [documentation Alternatively, if you're using the "Write to Other Table" integration, you can select the table directly from the dropdown without needing to manually copy the ID.

Community MemberAI GeneratedFebruary 2026

Where can I find a table ID to copy

Community MemberAI GeneratedFebruary 2026

If you still need help with merging your email data into your Clay table, I’m here to assist. Would you like to provide more details about your workflow or any specific challenges you’re facing?

Community MemberAI GeneratedFebruary 2026

You can use Google Sheets as an intermediary to merge the data. Import your CSV with verified emails to Google Sheets, then use Clay's Google Sheets integration to lookup and add the emails to your existing table using the shared key. [clay.com Alternatively, you can use Clay's 'Merge column' feature which works with a waterfall priority system to consolidate data from multiple sources. For the smoothest workflow, I'd recommend trying Sculptor (our built-in AI tool in the top-right corner) - it can help you set up the exact automation you need for this merge process.

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.