Architect a Clay table before you burn the credits
Designs the Clay table before you build it: sources, column order, run conditions, waterfalls, outputs, and a credit estimate. Column ordering and gating are where most teams silently overspend, so the prompt enforces filter-first architecture and makes every paid column defend its run condition — typically cutting credit burn 40-70% versus enrich-everything builds.
You are a Clay architect who has built tables that process millions of rows — and audited plenty of workspaces where a month of credits burned on tables that enriched everything before filtering anything. Your first principle: cheap columns left, expensive columns right, and nothing runs before its gate. Design a Clay table architecture for the use case I describe. Output: 1. TABLE MAP — how many tables, what each does, and how they connect (source table, enrichment table, output table if needed). 2. SOURCES — where rows come from (Clay search, CSV import, webhook, HTTP API) and expected weekly volume. 3. COLUMN PLAN — an ordered column list; for each: provider or formula, rough cost, the run condition that gates it, and what it outputs. 4. WATERFALLS — where to use provider waterfalls, in what order, and why that order. 5. OUTPUTS — where clean rows push (Smartlead, Instantly, HeyReach, CRM, webhook) and the field mapping. 6. CREDIT ESTIMATE — approximate credits per 1,000 rows and the two biggest cost levers. Rules: every paid column must have a run condition; if one runs on all rows, justify it. Filter and dedupe before enrichment, never after. AI columns come last and never run on rows that failed validation. If the use case needs two tables instead of one, split it and name the join key. Before you design, interview me. Ask these questions ONE AT A TIME, waiting for my answer each time: 1. What is the end output of this table, and where does it get pushed? 2. Where do rows come from, and how many per week? 3. Which enrichment providers and credit plans do you already pay for? 4. What makes a row qualified versus junk for this campaign? 5. What is your monthly credit budget? Then produce the architecture, flagging any place where my qualification criteria can't be checked with available data.
How to use it
- 1
Copy the prompt into Claude, ChatGPT, or any LLM.
- 2
Answer the interview with real numbers — weekly row volume and credit budget change the architecture materially.
- 3
Build the table left to right following the column plan, setting each run condition before turning the column on.
- 4
Run 50 rows, compare actual credit spend to the estimate, and ask the chat to re-gate any column that overran.
Best practices
Be specific on question 4 — 'US SaaS companies, 20-200 employees, hiring SDRs' gates far better than 'good-fit companies'.
List every provider you already have API keys for; native Clay credits are often the most expensive path to data you already own.
Ask for the formula text of any conditional run column so you can paste it directly into Clay.
Revisit the architecture when volume changes 5x in either direction; the right design at 500 rows a week is wrong at 5,000.
Example: what this looks like in practice
A growth lead at a 35-person SaaS company is burning 90,000 Clay credits a month building lists for two campaigns. The interview reveals rows come from Clay company search at 3,000 a week, they already pay for Prospeo and a LeadMagic plan, and qualification means US-based, 11-200 employees, with a revenue role posted in 90 days. The architecture splits company and person tables joined on domain, moves the free jobs-check before any paid enrichment, gates email waterfalls behind title match, and orders the waterfall Prospeo, then LeadMagic, then Clay-native as last resort. Estimated spend drops to roughly 38,000 credits a month, and the two-table split lets them reuse the company layer for a second persona at near-zero extra cost.
Best fit
This prompt is one gear in a bigger machine. We orchestrate 20+ tools into outbound systems our clients own — and guarantee the results.
Apply for a Pilot Spot → →Frequently asked questions
Almost always column order and missing run conditions: paid enrichments running on rows that later get filtered out, waterfalls ordered by habit instead of cost, and AI columns running on unvalidated rows. Restructuring so filters run first and every paid column has a gate routinely cuts spend by half without losing a single qualified row.
More automation & workflow design prompts
Build a system prompt for an AI cold email reply agent
Interviews you about your offer, booking flow, and voice, then generates a complete production system prompt for an AI reply agent — classification taxonomy, response rules, escalation conditions, and a strict JSON output contract an n8n or Zapier workflow can parse. You get the artifact teams pay thousands to have written, tuned to how you actually talk.
Turn a manual sales process into an automation blueprint
Converts a fuzzy 'we do this by hand every week' description into a structured blueprint with a detectable trigger, labeled steps, edge cases, human checkpoints, and failure alerts. It forces the design decisions people usually discover mid-build, so what you hand to n8n, Zapier, or an ops hire is assembly work, not archaeology.
Audit your full sales tool stack for overlap, gaps, and waste
Turns your tool list into a capability matrix that exposes overlaps, gaps, and zombie subscriptions, then delivers cut/keep/consolidate verdicts with savings math and safe migration notes. Teams typically find 20-35% of GTM tool spend is redundant — this makes the case with a matrix, not a hunch.