# Cornersight → Clay table: column-by-column setup

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
1. In Clay: New table → Import → **Webhook** ([Clay docs](https://docs.clay.com/enrichments-and-providers/sources/import-data-from-webhook)). Copy the webhook URL.
2. 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.
3. 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` |
| LinkedIn | `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
1. **Work email**: run your email waterfall only when `Email (Cornersight)` is empty. Saves credits.
2. **Final ICP check** (optional): a Clay AI column with prompt 3 from `../prompts/CLAUDE_CODE_PROMPTS.md`, or your own title and size rules.
3. **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.