Guide

LeadMarmot to Clay

Pull the morning's leads into a Clay table and enrich from there.

What you get

A Clay table with one row per lead, refreshed every weekday, ready for the enrichments and the sequences you already run in Clay.

Option 1: the CSV

Import the CSV from the morning email as a new table or into an existing one. Every column comes through, including the evidence columns (what ChatGPT answers, the pages it reads, analytics, blog, customer proof, hiring).

Option 2: an HTTP API column

The JSON API returns the same rows as the file. Your key is in every LeadMarmot email.

GET https://leadmarmot.com/api/leads?key=YOUR_KEY            latest file
GET https://leadmarmot.com/api/leads?key=YOUR_KEY&need=GEO   one need only
GET https://leadmarmot.com/api/leads?key=YOUR_KEY&date=2026-11-02
GET https://leadmarmot.com/api/leads?key=YOUR_KEY&company=hyperbolic.ai

Each lead carries: date, company, website, signal, hook, needs, top need, contact email with type and verification, LinkedIn, contact form, X handle, the evidence behind each need, round, amount, country, sector, what they sell.

In Clay, add an HTTP API enrichment that calls the URL above with your key once a day, or use a webhook source that a Zapier or Make scenario posts the rows to every weekday morning. Each lead becomes a row; website is the natural key for the rest of your enrichments.

Option 3: the agent

The MCP server turns the file into tools your agent can call. Add https://leadmarmot.com/mcp?key=YOUR_KEY as an MCP server in Claude or ChatGPT, then ask for this morning's leads by need, the opener for one company, or a draft in your voice. The sample_leads tool works without a key.

Which columns matter in Clay

top_need tells you which service to pitch. hook is the first line. buyer_question and rival_chatgpt_names explain a GEO need. analytics, content_engine, customer_proof explain the rest.

Which leads to send

Every lead lists its needs, strongest first. If you sell GEO, send the ones whose top_need is GEO: their buyer asked ChatGPT a question and got a rival's name, and the hook says so in one sentence. If you sell content, paid or PR, filter on that need instead. One service, one need, one line: that is the whole pitch.

Keep your sending domain clean

Send only to addresses with a value in email_verified, skip helpdesk mailboxes, and keep daily volume where your tool's warm-up plan puts it. Where there is no address, the file still gives you the LinkedIn page, the contact form or the X handle, and the opener works the same way there.