I am wondering if it's possible to get the number of "associated members" from LinkedIn into my Clay table without wasting Clay credits. I've added a formula that appends the people page to the original LinkedIn company page. The link is now: https://www.linkedin.com/company/google/people/. On that page, I would like to extract the exact number of associated members listed.
π Hey there! Our support team has got your message - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in this thread so that we can help you as quickly as possible!
Hey, thanks for reaching out! π Just to confirm, are you trying to extract the βpeopleβ part of the URL? If so, you can use a formula like this: Extract the last /people/ part of the URL and return only the number in this column: /column. However, Iβm not sure of the exact details of this methods and if it would work, so let me know if this is what you need or if you have more specifics! π
I added the /people part with a formula myself. But now I want to visit that page in the table "https://www.linkedin.com/company/google/people/" with hopefully the end result in the number of associated members
Or on the /about page of the linkedin page, and there I need the same info: number of associated members
Hi Nick, thanks for reaching out. You can actually use Claygent to scrape this information. Here's how: https://www.loom.com/share/bf8615f8be5748689800224e21ec970f?sid=36cd033d-c8c1-42b2-8905-f291bd96ee07 Here is the prompt I wrote out below for you to use https://downloads.intercomcdn.com/i/o/1184747138/9637db9bc59123e55c621a9c/CleanShot+2024-09-18+at+14_27_07%402x.png?expires=1726686000&signature=28eed128868a36d06bb1fc21b36893c6e5aa46f52e0b86244af7e1b33d5c5c9d&req=dSEvEs56moBcUfMW1HO4zftbMwJ6j77rR2ToOzEUn9K8grNH7QzGSOmHsxXK%0Aty6e%0A Let me know if you have any other questions! π
Thanks for your help all! This is not really working with Claygent + OpenAI, tried it a couple of times but i am not getting the results I was expecting. If I enrich the company with the 'enrich company' feature I get the results i need. But that costs a credit per result. When having thousands of rows, that's expensive.
in this example you see the employee count of 74, which almost matches with the number on LinkedIn
Hey Nick! Thanks for reaching out. Can you share your table url? Happy to take a look at the prompt and configuration. Were you getting inaccurate results with Claygent?
You will see the Claygent result(s) are different than the one from when you enrich the company with the enrichment tool from Clay. But yea, that's expensive with the credits..
Hey there Nick thanks for reaching out, data points such as associated members is provided to Clay by 3rd Party providers who have their own processes, Clay itself does not scrape this data. This why using any of our tools to retrieve this data would generate a credit cost, since we have to rely on those service providers. The only option to retrieve this data without incurring credits cost, would be through Apify or Phantombuster.
We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!