Skip to Content
SyncGTM PlatformBuilt-in EnrichmentsLookup Rows In Table

Lookup Rows In Table

Lookup Rows In Table matches the current row against another table by a shared key and pulls back a value from the match.

What it does

  • Looks up a matching row in a different table using a key column — like a domain, email, or LinkedIn URL
  • Returns a value from the matched row into the current one
  • Useful for checking whether a lead already exists elsewhere in your workspace before spending credits enriching it again

How to use it

  1. Click Add Action and search “Lookup Rows In Table”
  2. Select the table to look up against and the key column to match on
  3. Pick which value to pull back
  4. Run the row, then the column

Common use cases

  • Pull company attributes into a people table — name, revenue, industry
  • Pull people attributes into a company table — the key contact or decision maker
  • Re-use standard messaging or offers stored in one central table
  • Check a row against a static reference list, like current customers or existing users
  • Check a Do Not Contact list, or whether a record was already enriched, and branch on the answer

Best practices

  • Match on a stable, unique identifier — a domain or LinkedIn URL beats a company name
  • Clean and normalize both sides of the key first: trim, lowercase, consistent formatting
  • Promote the returned value into its own column so it filters, sorts, and exports cleanly
  • Run the lookup before the expensive column, so an answer you already have stops the spend
  • Keep the reference table deduped — several matches make the returned value ambiguous

Where to next

Send To Another TableDelete Row