Integrations / Baseloop / Lookup Single Record in Other Table

Lookup Single Record in Other Table

Search another table and return the first matching record

What this does

Joins one Baseloop table to a single record on another. Common patterns: dedupe checks against a master list, blocklist lookups against closed-won/churned accounts, finding the deal owner for a HubSpot company, attaching a webinar registrant to its parent account. Returns null when no match exists so downstream actions can branch on "found / not found" cleanly.

What this returns

A single matching record from the target table, joined by your lookup field. Returns null when no match is found, so downstream actions can branch cleanly.

How teams use this

Teams typically chain lookup single record in other table after an enrichment or scoring step: an inbound lead lands on the table, an enrichment action fills in the missing fields, a qualification step decides whether the lead is worth acting on, and lookup single record in other table runs only on the rows that pass. Because Baseloop maps each action's inputs to columns on your table, the same workflow can run on one record or on ten thousand without changing a thing.