I have a table in clay with a company ID. I also have a google sheet that has the same company id field but also a phone number field. How can I pull in the phone number and match it to the right company in clay?
Use the Google Sheets "Lookup row" action to pull phone numbers into your Clay table. Click "Add enrichment" and search for "Google Sheets," then select "Lookup row." [1]
Set your Lookup Column to the company ID column in your Google Sheet and the Lookup Value to your Clay table's company ID column. This will find matching rows and return the phone number data. [2]
The lookup will match companies based on their IDs and pull the corresponding phone numbers into Clay. [3]
If you need any more help with pulling phone numbers into your Clay table or have other questions, I'm here to assist. Would you like to provide more details about what you're trying to achieve or any challenges you're facing?