Clay Icon

Matching Clay Industry Data with Salesforce CRM Picklist Values

ยท
ยท

Hi, I have the Industry and company description data in Clay table, and I need to create a record in Salesforce CRM with the appropriate Industry value. However, in Salesforce CRM, we have predefined picklist values for the Industry field. I'm wondering if there's a way to compare the Industry and company description from Clay with my CRM picklist values (perhaps by using a list in Google Sheets) and then return the closest match from the picklist.