# Build a Clay-style table: an agent recipe

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

## Prompt

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.

## Steps and providers

- List the companies: apollo-sequences, people-data-labs, coresignal. 1 search per company row.
- Add the tech stack: builtwith. 1 lookup per company row.
- Find the CEO email: hunter, findymail, tomba, icypeas. 1 lookup per company row.

## Memory and schedule

The prompt writes rows to your own Supabase.

Run it on demand.

## Can an AI agent build a clay-style table?

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.

## 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.

## Related recipes

- /recipes/enrich-a-company-list
- /recipes/ceo-emails-for-fintechs
- /recipes/hiring-signal-watch

## Last reviewed

2026-10-02. The cost per 1,000 runs is read live from the catalog on the web page.