Field names come from Cornersight's real webhook payload. Not yet built and tested in a live Clay workspace.
Clay has no file you can import a table from, so this is a build sheet. About 15 minutes. (Estimate, not measured.)
CORNERSIGHT_CLAY_TABLE_STARTER.csv has one fake example row if you want to see the columns before you connect the webhook.
1. Create the table
- In Clay: New table → Import → Webhook (Clay docs). Copy the webhook URL.
- In Cornersight: open the source → webhook settings → paste the URL. Choose ICP only under "Select the leads to push" if the source has an ICP filter.
- Wait for the first lead, or press test. Clay creates one column with the whole payload.
2. Map the fields (Formula or "Add column from JSON")
| Column | From payload |
|---|---|
| Lead ID | data.leadId (use this to spot duplicates) |
| Name | data.name |
| Job title | data.jobTitle |
| Company | data.companyName |
| Domain | data.companyDomain |
| Industry | data.companyIndustry |
| Size | data.companyStaffRange |
| Country | data.country |
data.linkedinUrl |
|
| Email (Cornersight) | data.email (only filled if you connected your own email finder in Cornersight) |
| ICP | data.isIcp |
| Signal | data.engagementType (Like, Comment or Author) |
| Comment | data.commentText |
| Post URL | data.postUrl |
| Post text | data.postText |
| Source | data.trackedProfile (creator handle, or the keyword) |
3. Enrich
- Work email: run your email waterfall only when
Email (Cornersight)is empty. Saves credits. - Final ICP check (optional): a Clay AI column with prompt 3 from
../prompts/CLAUDE_CODE_PROMPTS.md, or your own title and size rules. - Personalised first line: Clay AI column. Use prompt 2 from
../prompts/CLAUDE_CODE_PROMPTS.md.
4. Send
Add a send column only when: ICP = true AND email found AND not sent before.
Send to your sequencer (PlusVibe, Instantly, Smartlead) or HeyReach. Full walk-through: EVERGREEN_SIGNAL_CAMPAIGN_CLAY_PLUSVIBE.md.
Tips
- One Cornersight source = one Clay table (or one webhook URL per source). The payload does not say which source fired, beyond
trackedProfile. - Clay webhook limits: 10 records per second per workspace, 100KB per payload (Clay docs).
- Don't mention in the email that you saw their engagement. Relevant, not creepy.