Importing Linkedin Profile

Here PROFILE ID is the linkedin profile name with the target person’s username. It’s usually the person’s name without any spaces. For removing white spaces in name we can use Dewhitespace function in ImportXML with USERNAME.

=ImportXML("www.linkedin.com/in/" & Dewhitespace({PROFILE ID}), "//dd[@class='overview-connections']/p/strong")

Formula for getting the number of connections is as follows. The result will return a number.

=ImportXML("www.linkedin.com/in/{PROFILE ID}", "//dd[@class='overview-connections']/p/strong")

Formula for getting the number of Recommendations is as follows. The result will return a number.

=ImportXML("www.linkedin.com/in/{PROFILE ID}", "//dt[text()='Recommendations']/../dd/p/strong")

Formula for getting the Profile Summary is as follows. The result will return a brief profile .

=ImportXML("www.linkedin.com/in/{PROFILE ID}", "string(//div[@id='profile-summary']/div[@class='content']/p)")

Formula for Finding locality of a person is as follows. The result will return name of the locality.

=ImportXML("www.linkedin.com/in/{PROFILE ID}", "//span[@class='locality']")

Formula for Finding the Industry a Person Defined Themselves In as follows. The result will return an industry name.

=ImportXML("www.linkedin.com/in/{PROFILE ID}", "//span[@class='industry']")

Formula for Finding What the Person Wants to be Contacted For as follows. The result will return Contacted details.

=ImportXML("www.linkedin.com/in/{PROFILE ID}", "//div[@id='profile-contact']/div[@class='content']/div[@class='interested']/ul/li")

Formula for Getting a List Of This Person’s Interest is as follows. The result will return Person’s interests.

=ImportXML("www.linkedin.com/in/{PROFILE ID}", "//div[@id='profile-additional']/div[@class='content']/dl/dd[@id='interests']/p")

import linkedin profile

Leave a Reply

Your email address will not be published. Required fields are marked *