Free Simple Company Search

Run in Enrichment Spreadsheet

Use this function as a column step in deepline enrich.

deepline enrich --input leads.csv --output leads.enriched.csv --with 'result=deepline_native_free_simple_company_search:{"sql":"{{sql}}"}' --json

Map payload values to spreadsheet columns with {{column_name}} placeholders.

Name	Type	Required	Default	Description
`payload.sql`	`string`	Yes		Single read-only SQL statement against the companies table (~35M rows). Columns: normalized_domain, domain, company_name, industry, location, linkedin_url, employee_count (integer), year_founded (integer), updated_at. Prefer exact normalized_domain lookups first. If exact domain lookup misses, use company_name ILIKE or normalized_domain ILIKE to generate fallback candidates, then verify the match. Supports SELECT, aggregates, GROUP BY, CTEs, EXPLAIN. SQL must include LIMIT <= 100000. Best for company retrieval, shortlist building, exact segment counts, and domain-to-company recovery. Example: SELECT * FROM companies WHERE company_name ILIKE ‘%nestle%’ OR normalized_domain ILIKE ‘%nestle%’ LIMIT 10

Use direct execution for single payload debugging.

deepline tools execute deepline_native_free_simple_company_search --payload '{
  "sql": "string"
}' --json

Flag	Description
`--json`	Print machine-readable output.
`--wait`	Wait for terminal provider status when supported.
`--debug`	Enable wait mode with additional status/log output.
`--wait-timeout SECONDS`	Max seconds to wait in wait mode.
`--poll-interval SECONDS`	Polling interval in seconds during wait mode.
`--timeout SECONDS`	Request timeout in seconds.
`--connect-timeout SECONDS`	Connection timeout in seconds.