Clay API for New User Enrichment

Clay doesn't offer an API, but you can simulate an API via Val Town by listening to webhooks, enriching data in Clay, and having Clay send an HTTP request back when enrichment is complete.

This demo uses Clay like an API to automatically enrich new user signups and send notifications to Discord.

Here's an example:

Here's the underlying Clay Table (feel free to zoom in to see the exact setup for debugging):

1. Create a new Clay workbook called "New User Enrichment"

2. Click Add → Pull in data from source at the bottom

3. Select Pull in data from a Webhook Table

4. Click Edit source on the Webhook column to copy the webhook URL

5. Update the webhook URL in your main.tsx file:

"https://api.clay.com/v3/sources/webhook/pull-in-data-from-a-webhook-YOUR_ID"

Note: Setting up the webhook like this lets you transform / filter the data before sending it over to Clay. It also helps with error handling and give you logs in Val Town for observability. Otherwise, you could set up the webhook directly from the source ie. Clerk, Stripe etc.

Add whichever enrichment columns you want. This example uses:

• Enrich Person → Name, Title, Org
• LinkedIn Profile → LinkedIn URL

1. Click Add Column → Add Enrichment → search for HTTP API
2. Add HTTP API column to your Clay table
3. Click Edit Column and fill in the following:

• Set endpoint to your HTTP URL: https://your-val-url.com/clayEnrichmentWebhook (Note: you need the /clayEnrichmentWebhook!)
• Set method: POST
• Configure request body:

{
  "email": "{{email}}",
  "profile_image_url": "{{profile_image_url}}",
  "Name": "{{name}}",
  "Title": "{{title}}",
  "Org": "{{org}}",
  "LinkedIn": "{{LinkedIn Profile}}"
}

• Enable Remove empty values
• Here's what my final column looked like:
• 

1. Click Environment Variables in your val's sidebar
2. Add: DISCORD_WEBHOOK_URL with your Discord webhook URL

This is what triggers a new row in the Clay table, hook up your source system (Clerk, Stripe, etc.) to send webhooks to your val's HTTP URL: https://your-val-url.com/newUserSignup (Note: you need the /newUserSignup!)

For Clerk, you can find it here:

Enriched profiles (with ⭐):

⭐ New user! John Doe • Software Engineer @ Tech Corp • john@example.com • https://linkedin.com/in/johndoe

Basic signups:

New user! user@example.org • [profile_image_url]