LinkedIn Profile to Spreadsheet

Scrape all the available data from LinkedIn profiles.

Table of Contents

• Demo Videos

• Chart Description

  • Fields captured by this chart

• Chart Configurations

  • Shortcut Configuration
  • Schedule Configuration

• Chart Status: Active

Demo Videos

Chart Description

You're only one step away from extracting leads, potential hires, and new contacts from your favorite professional social network!

This chart allows you to extract various details from a LinkedIn profile. These details can be used to build your business prospecting list. With the data this chart captures your prospecting task will be much easier. You can utilize person's location, company, school, title etc. You can even utilize the skills and interests to filter your lists.

To run this chart, simply visit the LinkedIn, URL of the person and press the shortcut key to get all the profile information in the designated spreadsheet.

As with every chart, this one also runs on your machine. LinkedIn has a limit of 80 profile visits a day. If you have LinkedIn premium, your limit increases to 150. You can also share your CoPilot credentials with your teammates and have them run the chart for you. That way you won't be limited to these limits.

Fields captured by this chart

• Profile URL
• Name
• TItle
• Location
• Company
• School
• About Text
• Most recent 3 experiences
  • Role
  • Company
  • Timeline
  • Duration
  • Location
  • Details
• Most recent education
  • Institute
  • Degree
  • Major
  • Dates
  • Activities
  • Details
• Top 3 endorsed skills
• Up to six interests

---

Chart Configurations

Shortcut Configuration

This chart is particularly helpful with shortcut configuration. The chart will run on all the LinkedIn profile pages. Once set up, you can run this chart to get the profile information from the LinkedIn profile page. Simply go the profile you want to get data from and press the shortcut key. The data will be extracted from the LinkedIn page and added to your specified spreadsheet.

{
  "shortcutKey": "g",
  "values": {
    "spreadsheetId": "1vCf3PBGbt5avDl53fyEyR8CfYgXz-ZZVk00ON8Jm0IQ",
    "range": "Sheet1!A1"
  }
}

This configuration will allow you to press g to get the data in the specified spreadsheet.

Schedule Configuration

If you want to keep an eye out for changes in a LinkedIn profile, you can set this chart up.

• schedule: Schedule based on which the run should start.
• startURL: The LinkedIn profile for which you want to watch for changes.

{
  "schedule": "0 10 * * *",
  "startURL": "https://www.linkedin.com/in/jeffweiner08",
  "values": {
    "spreadsheetId": "1vCf3PBGbt5avDl53fyEyR8CfYgXz-ZZVk00ON8Jm0IQ",
    "range": "Sheet1!A1"
  }
}

This configuration will get profile information from LinkedIn's Executive Chairman daily at 10am and add it to the specified spreadsheet.

Chart Status: Active

Let us know if you have feedback or ideas related to this chart on twitter.