Hi , I have a sheet with Candidates (150+) and their info including their Name, LI profile, company, CURRENT TITLE etc. I want to know if Clay has an enrichment function as to where I can run the enrichment in the table and it gives me all their past titles based on their LI profile ? What would this enrichment be called or how do I do this?
You can use Clay's "Enrich Person from Profile" feature to retrieve comprehensive details about candidates, including their past titles. Here's how:1. Start with your existing sheet containing LinkedIn profile URLs 2. Use the "Enrich Person from Profile" feature, which will pull detailed information from their LinkedIn profiles 3. This enrichment will retrieve comprehensive details about each individual, including their work history and past titlesThis process is particularly effective for tracking job changes and determining whether contacts have switched positions over time. Source: Enrich prospects after they book meetings with you | Clay
Great! I'm glad I could help. I'm here if you have any more questions.
Great! I'm glad I could help. I'm here if you have any more questions.
Thanks! We've reopened this thread. You can continue to add more detail directly in this thread.
Once I have the info from their profiles using "Enrich Person from Profile" how do I export this sheet so I have all the info included in the profile info?
You can export your enriched data to Google Sheets. After using the "Enrich Person from Profile" feature, you can set up your Clay workflow to:1. Create a new Google Sheet 2. Add the appropriate headers 3. Push the enriched data to the sheetThis will allow you to have all the enriched profile information in an easily accessible Google Sheets format. Source: Enrich people's profiles of who commented on a LinkedIn post | Clay
Thanks I want to take action on the list then write each item to new row in other table. How do I do this correctly without it giving me an error
Looks like you're still looking for help. We're escalating this over to our support team and someone should be in touch soon. In the meantime, feel free to include any other information that may be helpful in solving your issue!
Hi Ineska, thanks for reaching out. Taking a look at this now!
The best tool to achieve what you're trying to do here is our write to other table integration. 1. Make sure your Clay API key is linked correctly. 2. Find and set up the write to table enrichment column by clicking on Add Column > Add Enrichment > Search and select "write to table" https://downloads.intercomcdn.com/i/o/1198904361/3f67448e206777df45b95b0c/CleanShot-2B2024-09-04-2Bat-2B22_37_07.gif?expires=1736256600&signature=833460456129d5bdf2f75f5d4ae8f16cf0caceaf74fa26794de243a99410f3e2&req=dSEuHsB%2BmYJZWPMW1HO4zUOGxNpGcTza3XP6pls40EVrBg%3D%3D%0A 3. You can now choose to parse your arrays into an existing table or create a new blank table for them, by clicking on "new table": https://downloads.intercomcdn.com/i/o/1198904362/2d0802e8f2b400ae2661cfc6/CleanShot-2B2024-09-04-2Bat-2B22_45_05.gif?expires=1736256600&signature=30c96b4e541afeb9b6fb2134fc6c23b65ebf3cd7ba8d1758fda513856f50beea&req=dSEuHsB%2BmYJZW%2FMW1HO4zeoz8kM4xbmOqPOJ9fQhK2na6g%3D%3D%0A 4. We can now neatly write our array of objects into individual rows by inserting a column in the 'Select a List from a Column' field. Type a forward slash, choose the column containing the arrays, open its properties, and click "insert all items". https://downloads.intercomcdn.com/i/o/1198904363/5b8ff331300c2f7d8c10a39f/CleanShot-2B2024-09-04-2Bat-2B22_53_01.gif?expires=1736256600&signature=78b7ca1e6b22cc1b7a493a95b4777405a2709cab132d8d0c8d8ea5e5ca4a45db&req=dSEuHsB%2BmYJZWvMW1HO4zT205zaCwlcZR2g4Gfhv9uXCIg%3D%3D%0A 5. Now the last thing we'll have to do is specify which objects from the array we want to write to the new table, and to which columns we want to map them. We'll be able to select columns which are existing or create new ad-hoc columns for this purpose: https://downloads.intercomcdn.com/i/o/1198904365/cd63b467ff32f8730cae429a/CleanShot-2B2024-09-04-2Bat-2B22_55_01.gif?expires=1736256600&signature=b208a36f7dbcdfda08e6872eb4694760f639acb49cbe757c050adfb80c43e980&req=dSEuHsB%2BmYJZXPMW1HO4zRXCYeYgoPD4gs3r2grz9eMSgA%3D%3D%0A 6. You can also add other column values to the table, which is useful when transferring lead data from one table to another using the 'Write to Table' column. This setup can work independently, without the list feature configured in step 4. https://downloads.intercomcdn.com/i/o/1198904364/78c2e80597d41d589143e455/CleanShot-2B2024-09-04-2Bat-2B23_00_35.gif?expires=1736256600&signature=e96c36f03058a39da35b3a1e260ba5c5546471f9c4e13636b862802ae2bdc8cf&req=dSEuHsB%2BmYJZXfMW1HO4zWjfjMRFJpHOLP7nTaI26NkFUA%3D%3D%0A You're all set! You can now save and run your 'Write to Table' column.
Thank you I will try this and give feedback :)
Sounds great!
Hi Bruno, I think I am doing something wrong. Going to send a recording and screen shots. I am getting invalid credentials So basically I just want their experiences which is listed under the "enrich person from profile" column. Maybe I am putting in the wrong details when you add to colums I am not sure. I basically just want their experiences to be listed next to their full names.
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.