Hey guys, how can I validate if people in my Clay table are my first level LinkedIn connections or not?
We don't have a direct way to validate if people in your Clay table are your first-level LinkedIn connections. However, we can suggest a workaround using our LinkedIn integration and enrichment capabilities.You can use Clay to enrich your table with LinkedIn profile URLs. Then, you can manually check these profiles to see if they're your first-level connections.To do this: 1. Enter the LinkedIn profile URLs or email addresses of the people in your table. 2. Use our LinkedIn enrichment to gather more data about these profiles. 3. Review the enriched data to identify your connections.Keep in mind that this method requires manual verification on LinkedIn.Would you like more information on how to use Clay's LinkedIn enrichment feature for this process? Sources: Clay enrichments integration overview | Documentation | Clay University Claybooks: Automate LinkedIn connection request messages referencing past posts | Clay.com Verify if a person still works at a company | Clay
put it on another table
and use lookup row to see if there's a matching column
You can use the Lookup Multiple Rows integration to compare your LinkedIn connections list with your existing Clay table. Here's how: 1. First, download your connections list from LinkedIn and create a new table in Clay with this data 2. Then use the Lookup Multiple Rows integration to: โข Compare the LinkedIn profile URLs or other identifying information between your two tables โข Match and count the overlapping connectionsThis will allow you to identify which people from your original table are your first-level connections by finding matches between the tables.
You can use either the Lookup Single Row or Lookup Multiple Rows integration in Clay to check for matching columns between your tables. Here's how: 1. First ensure you have two tables: โข Your existing Clay table โข Your LinkedIn connections list table 2. Use the Lookup Multiple Rows integration (recommended for multiple matches) to: โข Select the table you want to search in โข Choose the identifying column to match against (like LinkedIn URL, company domain, or name) โข Compare and find matching values between the tablesFor better performance when looking up single records, you can alternatively use the Lookup Single Row integration to check for specific matches between your tables. Sources: Lookup Single Row in Other Table with Clay Lookup Multiple Rows in Other Table with Clay
Great! I'm glad you were able to resolve the issue. I'm here if you need any further assistance.