conditional-logic

Conditional Logic & Clayscript

You help users write Clayscript formulas, set up conditional runs, and build credit-saving logic in Clay.

References

• Read {SKILL_BASE}/resources/formulas/clayscript-guide.md for syntax, libraries, and AI formula generator.
• Read {SKILL_BASE}/resources/formulas/copy-paste-formulas.md for ready-to-use formulas (name cleaning, domain extraction, email waterfall, seniority check, employee buckets, table layout).
• Read {SKILL_BASE}/resources/expert-tips-eric-noski.md for Rule 1 (conditionals on all paid integrations) and Rule 5 (formulas over AI).

Core Rule: Formulas Cost 0 Credits

Formulas are FREE. Always prefer formulas over AI columns for:

• Cleaning/formatting data
• Combining fields (first + last name)
• If/then logic and scoring
• Abbreviations (New Jersey --> NJ)
• Extracting domain from email
• Any standard JavaScript operation

Syntax

• Describe mode: Use /field_name to reference columns
• Raw mode: Use {{FieldName}}
• Libraries available: Lodash (_), Moment.js (moment), FormulaJS (VLOOKUP, IF, SUM)
• Null safety: Always add || "" to avoid errors on empty cells

Essential Conditional Run Formulas

// Only run if field is empty (most common)
/email is empty

// Only run if previous enrichment completed but returned nothing
Clay.getCellStatus(#{{field_id}}) == "completed" AND {{previous_column}} == ""

// Only run on high-value leads
/lead_score > 70 AND /industry equals "SaaS"

// Only run if email is valid
/email_validation equals "valid" OR /email_validation equals "catchall valid"

// Skip already-enriched rows
/revenue is empty AND /domain is not empty

// Combined: CRM push only if ready
/email is not empty AND /email_validation equals "valid" AND /lead_score > 50

Common Data Manipulation Formulas

// Extract domain from email
{{email}}.split("@")[1] || ""

// Combine first + last name
({{first_name}} || "") + " " + ({{last_name}} || "")

// Capitalize first letter
({{name}} || "").charAt(0).toUpperCase() + ({{name}} || "").slice(1).toLowerCase()

// Bucket company size
{{employee_count}} > 1000 ? "Enterprise" : {{employee_count}} > 200 ? "Mid-Market" : {{employee_count}} > 50 ? "SMB" : "Startup"

// Clean LinkedIn URL
({{linkedin_url}} || "").replace(/\/$/, "").split("?")[0]