How do I build a clay-style table with looot?

Paste the prompt on this page into your coding agent. It sets up looot, finds the endpoint for each step, checks the price and runs the cheapest one that fits. Edit the names and numbers first.

How much does it cost to build a clay-style table?

You pay per call, and the price depends on the provider the agent picks. The web version of this page reads the cheapest price for each step live from the catalog and shows the cost per 1,000 company rows when every step is priced.

Which providers can build a clay-style table?

The providers behind this recipe are apollo-sequences, people-data-labs, coresignal, builtwith, hunter, findymail, tomba, icypeas. The catalog shows each endpoint's price before you run it.

Can I build a clay-style table on a schedule?

No. Run it when you need it. Nothing is billed while your agent is idle.

Where does the data go when I build a clay-style table?

The prompt tells your agent to write one row per result to your own Supabase project, with the source, the endpoint, the cost and the time. looot returns the data and bills the call. It does not store your rows.

What can looot not do when I build a clay-style table?

looot returns data and does not do a spreadsheet grid. Your agent needs another tool for that part.

Sales

Build a Clay-style table

Fills a table of target companies with domain, headcount, tech stack and CEO email. Your agent needs another tool for a grid UI.

8 providers

Cost per 1,000 company row runs

$78.00

1 company row
one run: 3 calls
per company row: your Supabase
memory

Sales

Build a Clay-style table

Fills a table of target companies with domain, headcount, tech stack and CEO email. Your agent needs another tool for a grid UI.

8 providers

Cost per 1,000 company row runs

reading live price

1 company row
one run: 3 calls
per company row: your Supabase
memory

The prompt

Copy one prompt, give it to your agent.

Edit the names and numbers, paste it, and the agent runs the job and shows the cost.

One run is one company row.
3 steps across 8 providers.
Runs on demand, whenever you ask.

Prompt: Build a Clay-style table

Use looot to build a table of 100 Series A SaaS companies with columns for domain, headcount, tech stack and CEO email, and fill every cell. 1. Set up https://looot.ai/skill.md. 2. Connect my Supabase and create the table company_table. 3. Upsert on a natural key and never overwrite my edits. 4. Store source, endpoint, cost and fetched_at on every row. 5. Show any price over one cent first and stop at my daily budget. 6. Skip rows that are already there. 7. Report rows added, rows changed and total cost.

Give this to your agent

Setup command

set up looot - https://looot.ai/skill.md

Set up once

Then paste any recipe.

Paste one prompt into your agent

Set up looot

Done, looot is connected.

Copy one prompt from /connect into Claude Code, Cursor, or any MCP agent. No SDK, no dashboard click-through first.

Your agent finds the right operation

Hunter$0.0265

Exa$0.0090

Diffbot$0.0032

The agent finds the operation it needs and sees the price first. It calls nothing blind.

You watch what it cost

Hunter$0.0265

Exa$0.0090

Diffbot$0.0032

Total$0.0387

Every call settles for its quoted price and lands in the ledger. You always know what ran and what it cost.

Steps

The calls behind this recipe

Your agent picks each endpoint. Prices are the cheapest live endpoint for the step.

01
List the companies
Apollo (sequences)
People Data Labs
Coresignal
Cheapest$0.0196 / search
capability chosen by your agent, 1 search per company row
02
Add the tech stack
BuiltWith
Cheapest$0.0495 / lookup
capability chosen by your agent, 1 lookup per company row
03
Find the CEO email
Hunter
Findymail
Tomba
Icypeas
Cheapest$0.0089 / lookup
people.email.find, 1 lookup per company row

Cost

What company row runs cost

Your volume

1,000 company row runs cost about

$78.00

Cheapest live endpoint for every step. The provider your agent picks can cost more.

Price of each step, to scale

Find the CEO email$0.0089 / call
List the companies$0.0196 / call
Add the tech stack$0.0495 / call

Every run lands in your Supabase

The prompt tells your agent to write one row per result to your own Supabase and skip rows it already has. looot does not store them. See the build kit.

Keep going

- +3
Enrich a company list
Adds headcount, industry, HQ country and website to every domain in a list, using the cheapest provider that answers.
- +4
Find CEO emails for fintechs
Finds the CEO of each fintech, looks up a work email and drops any address that fails verification.
Hiring signal watch
Checks target accounts for new sales or data job posts and lists who just started hiring. Your agent needs another tool for alerts.

FAQ

Questions about this recipe

Yes. The agent runs 3 steps through looot: list the companies, then add the tech stack, then find the ceo email. You give it the prompt on this page and the inputs.

For agents

recipe: Build a Clay-style table
category: Sales
run: company row
memory: your Supabase
schedule: on demand
step: List the companies: apollo-sequences people-data-labs coresignal
step: Add the tech stack: builtwith
step: Find the CEO email: hunter findymail tomba icypeas
setup: https://looot.ai/skill.md
llms.txt: https://looot.ai/llms.txt
updated: 2026-10-02

markdown /recipes/build-a-clay-style-table.md

Try this recipe with your own agent.

Start your workspace, top up, and paste the prompt into the agent you already use.

Start your workspace See other recipes

Copy one prompt, give it to your agent.