
The Your data section of the Tools panel.
Add a lookup column
1
Open the Tools panel and find Your data
Every one of your connected integrations that supports fetching a single record appears here.
2
Pick what to fetch
Each row reads Get, followed by the record type, for example a contact or a user.
3
Choose how to match the row
Under Look up by, pick the field that identifies the record, such as an ID or an email address.
What comes back
A lookup returns the whole record as one cell. Open it and give any field its own column once you know which ones you need.Good to know
Whose account does this use?
Whose account does this use?
Your own. The lookup runs on the connection you set up, not a Oneprofile-held account, so it only sees what that connection can see.
Does looking up a record cost credits?
Does looking up a record cost credits?
Yes, a small flat amount per row it successfully finds. A row where nothing is found, or a repeat of a lookup already run, is not charged.
What if I do not see the integration I want to look up?
What if I do not see the integration I want to look up?
Connect it first. See all connections on the Your data section opens the page where you add one.
Can I change what a lookup matches on later?
Can I change what a lookup matches on later?
Yes. Reopen the column and change Connection, Record type or Look up by in its settings.
Next steps
The integration directory
Browse every tool Oneprofile can connect to.
Field columns
See the other kinds of columns a table can hold.