LinkedIn Data Scraping Tutorial | 1-Click To Save to Sheets

Summary

This video tutorial showcases an efficient method for extracting LinkedIn profile data to Google Sheets using a Chrome extension called 'Copy LinkedIn Profile Data to Google Sheets.' It demonstrates the use of the automation tool burden.ai, which includes a web scraper for seamless data transfer. The tutorial guides viewers on creating custom scraper templates, setting up automations for right-click triggers, and extracting data from LinkedIn search results. Additionally, it covers the use of 'Find That Lead' for email extraction and emphasizes the importance of ethical scraping practices.

Takeaways

• 🔍 The video demonstrates how to use a Chrome extension to automate the process of copying LinkedIn profile data to Google Sheets.
• 📝 The automation tool mentioned is called 'burden.ai' and it includes a web scraper for extracting data from websites.
• 📋 It's possible to create a new Google Sheet or select an existing one to store the scraped LinkedIn profile data.
• 🛠️ The video provides a step-by-step guide on configuring the automation to scrape specific data fields from LinkedIn profiles.
• 🔗 The 'add rows to spreadsheet' action is used to map the scraped data to a Google Sheet.
• 🎉 The process eliminates the need for manual copy-pasting, streamlining the data extraction and organization.
• 🔄 The automation can be triggered using a keyboard shortcut or a right-click action on a webpage.
• 🔎 There's an option to scrape more extensive information from LinkedIn search results using a pre-built automation.
• 🚀 The video also covers how to extract additional profile details like education and job titles using a deep scraper.
• ✉️ After data collection, the video suggests using a tool like 'Find That Lead' to find email addresses for mass emailing.
• 🛑 The video advises caution when scraping large amounts of data from LinkedIn to avoid violating their terms of service.
• 💡 Finally, the video shows how to create a custom scraper template for extracting different types of data from websites like LinkedIn.

Q & A

What is the main purpose of the video?

The main purpose of the video is to demonstrate how to use a Chrome extension to automate the process of copying LinkedIn profile data to Google Sheets without manual copy-pasting.

What is the name of the Chrome extension used in the video?

The name of the Chrome extension used in the video is 'burden.ai workflow automation tool'.

How can one access the automation tool mentioned in the video?

The automation tool can be accessed by downloading the Chrome extension from the link provided in the video description.

What is the name of the pre-built automation that the video demonstrates?

The pre-built automation demonstrated in the video is called 'Copy LinkedIn Profile Data to Google Sheets'.

How does the automation tool create a new spreadsheet in Google Sheets?

The automation tool creates a new spreadsheet in Google Sheets by selecting the 'Create a new spreadsheet' option and naming it, such as 'leads', and then hitting 'Enter' to confirm.

What is the shortcut used to trigger the automation in the video?

The shortcut used to trigger the automation in the video is 'Option + B'.

How can the automation be customized to perform different actions?

The automation can be customized by opening the automation builder, configuring the actions such as the scraper template and the Google Sheets action, and then saving the changes.

What is the purpose of the 'right-click' trigger in the automation?

The 'right-click' trigger allows the user to right-click anywhere on the webpage to initiate the automation, making it more convenient to save LinkedIn profile data to Google Sheets.

What is the name of the tool that can find the email address of a LinkedIn profile?

The tool that can find the email address of a LinkedIn profile is called 'Find That Lead'.

How can one extract more information from LinkedIn search results using the automation?

One can extract more information from LinkedIn search results by using a pre-built automation called 'Get data from LinkedIn search', which uses a deep scraper to extract additional details from each individual's profile.

What is the recommended limit for scraping profiles from LinkedIn to avoid enforcement issues?

The recommended limit for scraping profiles from LinkedIn is a couple of hundred profiles per day to avoid running into enforcement issues.

How can one build a custom scraper template for extracting specific information from a website?

One can build a custom scraper template by using the 'Create New Scraper Template' option in the automation builder, visually selecting the elements to extract, and then mapping the data to the desired action, such as adding rows to a Google Sheet.

Outlines

00:00

🔄 Automating LinkedIn Profile Data to Google Sheets

This paragraph introduces a Chrome extension that automates the process of transferring LinkedIn profile data to Google Sheets. The user can select an existing spreadsheet or create a new one called 'leads' to store the extracted information. The process involves zero copy-pasting and is demonstrated by the presenter, Renat, who shows how to use the Burden.ai workflow automation tool with its built-in web scraper. The automation is configured to map data fields and save them to a specified Google Sheet, making prospecting from LinkedIn more efficient.

05:02

🛠 Building and Customizing LinkedIn Data Scraper Automation

The second paragraph delves into the customization of the automation process. It explains how to use the Burden.ai tool to create a scraper template that identifies the specific data fields to be collected from LinkedIn profiles. The automation includes a trigger for right-click actions, enabling users to easily add profiles to the specified Google Sheet with a single click. Additionally, the paragraph discusses the possibility of extracting more comprehensive data from LinkedIn search results using a pre-built automation, which can handle scraping of individual profiles to gather additional information such as education and job titles.

10:04

📊 Extracting and Utilizing LinkedIn Data for Prospecting

The final paragraph discusses the practical applications of the extracted LinkedIn data. It suggests using the data for prospecting by mass emailing the selected profiles in a personalized manner. The paragraph also introduces a tool called 'Find That Lead' for discovering email addresses associated with LinkedIn profiles. Furthermore, it guides users on creating a custom scraper template for different types of data, such as job listings, and demonstrates how to save this information to Google Sheets. The automation is positioned as a user-friendly, code-free solution for data extraction, and the paragraph concludes with an invitation to try the free tool and join the community for support.

Keywords

💡Prospecting

Prospecting refers to the process of searching for potential customers or clients, typically in a business context. In the video, prospecting is associated with finding leads on LinkedIn, which is a professional networking platform. The script describes how to use a tool to automate the extraction of profile information from LinkedIn, which is a form of prospecting aimed at identifying potential business opportunities or partnerships.

💡LinkedIn

LinkedIn is a social networking platform that is primarily used for professional networking. It allows users to connect with other professionals, share content, and find job opportunities. In the video, LinkedIn is the source from which profile data is being extracted for the purpose of prospecting. The script mentions using a Chrome extension to automate the process of copying LinkedIn profile data to Google Sheets.

💡Google Sheets

Google Sheets is a web-based spreadsheet program that is part of Google's suite of productivity tools. It allows users to create, edit, and share spreadsheets in a collaborative environment. In the context of the video, Google Sheets is used as the destination for the extracted LinkedIn profile data, enabling the organization and analysis of the collected information.

💡Automation

Automation refers to the use of technology to perform tasks without the need for human intervention. In the video, automation is the central theme, with the script detailing how to automate the process of copying LinkedIn profile data to Google Sheets. This is achieved through the use of a Chrome extension and a workflow automation tool called burden.ai.

💡Chrome Extension

A Chrome extension is a software module that adds functionality to the Google Chrome web browser. In the video, the script mentions a specific Chrome extension that facilitates the automation of copying LinkedIn profile data to Google Sheets. This extension is part of the process that allows for the efficient extraction and organization of data.

💡burden.ai

Burden.ai is a workflow automation tool that is mentioned in the script. It is used to create automated workflows that can perform tasks such as web scraping and data entry into applications like Google Sheets. The video demonstrates how to use burden.ai to automate the process of extracting data from LinkedIn and saving it to Google Sheets.

💡Web Scraper

A web scraper is a tool that extracts information from websites. In the video, the script describes using a web scraper built into the burden.ai tool to extract profile data from LinkedIn. This scraper is part of the automation process that helps in collecting and organizing data without manual copy-pasting.

💡Playbook

In the context of the video, a playbook refers to a pre-configured set of actions or steps within the burden.ai tool that automates a specific task. The script mentions creating and using playbooks to automate the process of extracting LinkedIn profile data and saving it to Google Sheets.

💡Data Mapping

Data mapping is the process of defining how data from one system or application will be transferred to another. In the video, the script describes mapping data from the web scraper action to the 'Add Rows to Spreadsheet' action in Google Sheets. This ensures that the extracted data is accurately and appropriately entered into the spreadsheet.

💡Leads

In a business context, leads refer to potential customers or clients. The script mentions creating a new spreadsheet named 'leads' to store the extracted LinkedIn profile data. This data is used for prospecting purposes, identifying individuals who may be interested in the products or services offered.

💡Personalization

Personalization refers to tailoring communication or content to the specific needs or preferences of an individual. In the video, the script suggests using personalization in the context of mass emailing the leads collected from LinkedIn. This could involve adding a personalization column in the spreadsheet to facilitate a mail merge, ensuring that the emails sent are customized and relevant to the recipients.

Highlights

A Chrome extension automates the process of copying LinkedIn profile data to Google Sheets with minimal effort.

The automation tool is named 'Copy LinkedIn Profile Data to Google Sheets' and facilitates easy data transfer.

Users can select an existing spreadsheet or create a new one for storing the extracted LinkedIn data.

The data from LinkedIn profiles is neatly organized in Google Sheets without any manual copy-pasting.

The video demonstrates prospecting from LinkedIn and saving profile information using burden.ai workflow automation tool.

The tool includes a web scraper and can integrate with various apps like Google Sheets, Notion, or Airtable.

The automation builder allows configuring the scraper to collect specific data fields from LinkedIn.

An argument is used to specify the spreadsheet for saving data each time a profile is added.

The automation can be triggered using a keyboard shortcut, streamlining the data extraction process.

A right-click trigger can be set up for automation, allowing for easy data extraction with a simple mouse click.

The tool can extract more extensive information from LinkedIn search results using a deep scraper.

The deep scraper visits each profile link to extract additional details like education and job titles.

LinkedIn enforces restrictions on scraping; it's advised to limit the number of profiles scraped per day.

The extracted data can be utilized for prospecting and personalized mass emailing.

A tool called 'Find That Lead' can find email addresses associated with LinkedIn profiles.

Custom scraper templates can be created for different types of data extraction from websites like LinkedIn.

A step-by-step guide on building a custom scraper template for LinkedIn jobs is provided.

The newly created scraper template can be used to extract job details and add them to a new Google Sheet.

The automation tool is free to use and offers a Slack community for support.

Transcripts

if you do prospecting from linkedin

today your dream is going to come true

we're going to copy information from

linkedin to google sheets without any

copy pasting in just a few clicks and

let's get started right now here i have

14.8 chrome extension installed you're

looking for the automation that's called

copy linkedin profile data to google

sheets just like this you're going to

pick the spreadsheet you want to add the

information to i can also create a new

spreadsheet

and call it leads

hit enter hit enter one more time and

the new spreadsheet is going to create

it with all the information from this

profile extracted directly to google

sheets let's click on view and you'll

see all of the data neatly organized

zero copy pasting

hello my name is renat and in this video

i'm going to show you how to do

prospecting from linkedin and save

profile information and a bunch of other

data to google sheets very easily with

just a few clicks so we're going to be

using burden.ai workflow automation tool

and it has a web scraper built in as one

of the actions and then you can add

another layer of automations and other

actions such as google sheets it can be

notion airtable or any other app where

we are going to store this information

so in order for us to build an

automation like this we're going to do

the following so open the chrome

extension you can download it in the

description below and here we have the

automation again you'll have access to

it when you click on the link in the

description and we can configure this

automation to do what we want it to do

so if you open this automation and

builder you can see the scraper action

it uses a scraper template that knows

which data fields you want to collect

and then it uses also another action

that adds information to a specific

google sheet so here we have an argument

that we're going to be asked every time

we want to save a person to google

sheets so instead of us specifying which

spreadsheet we want to add information

to we can just

add an existing spreadsheet it's called

leads and we're going to map the data

from the previous action to this add

rows to spreadsheet action so coming

from the scraper to google sheets and

let's save this automation we're going

to close the builder

here we have the automation let me

delete the duplicate so it doesn't show

and you can click on another profile so

here we have artem i'm going to hit

option b shortcut click on the

automation and this lead is going to get

added again to our spreadsheet

right here

and then i can

click on another person

let's

go to matthias

and let's save matthias to that same

spreadsheet that was specified so here's

matthias and you can go ahead and do

exactly the same thing for pretty much

any person on linkedin and now let's

have a little bit more fun with it you

can trigger the automation with this

shortcut option b and click on the

playbook card you can also collapse the

view so it shows in the side panel but i

actually want to make it a right click

automation and i'm going to show you

exactly what this means so let's open

this automation in the builder and i

want to

add a trigger that's called

right-click

right here and we're going to give it a

name let's name it

leads

that's the option that's going to show

up when we right click on something hit

done

save this playbook close it

enable the automation just like this and

now if we want to go to another person

here we have pascal for example i'm

going to right click

anywhere on the website and here i have

an automation that's called leads so i'm

going to hit it and the data is going to

get extracted and saved to google sheets

automatically it's that easy and now you

might be thinking what if you want to

extract a lot more information at once

from say linkedin search there's an

option for us to do that as well it's a

pre-built automation that you will also

have access to by going down to that

link in the description below let's open

burden with a shortcut over here

expand the view and then here in the

explore section you'll be able to find

pre-built automations we have that one

pre-built so i can create a new playbook

browse through playbooks that are

pre-built so they have pre-built scraper

templates and i have linkedin search

somewhere okay get data from linkedin

search

right here and what that is going to do

is going to find

all of the people on the list here in

linkedin i already have gone to people

in linkedin search and typed in go to

market we're hiring and now let's do

option b shortcut to reopen the builder

and here we have two actions it's the

deep scraper meaning that it's not only

going to scrape the list that's

currently visible it's going to go

through each one of the links and going

to extract a little bit more information

finally we want to add that information

to a spreadsheet so let's find google

sheets let's add rows to google sheet

let's find

leads that's the spreadsheet that we've

created in the beginning map the data

from the second action

that's

additional data that we're getting from

each individual page

hit save and call this automation

linkedin search

to sheets

okay that's our automation let's hit

save

close the builder click on the

automation and it's going to ask us how

many results we want to scrape

for the demo purposes i want to scrape

let's do five results and i'm going to

run this playbook you can go ahead and

do whatever you want to do essentially

what the south nation does it gets the

five list items from this list and then

it scrapes each individual item in the

background so the scraper goes to every

one of those links and opens each page

so you can extract additional

information that's just not visible here

on the list such as somebody's education

and current job title and things like

that and when done you can click on the

chrome extension over here you can

click on the activities and view the

results it's going to show that specific

spreadsheet so here we have all of the

information with five additional

profiles

obviously be wary of scraping too many

profiles this is something that linkedin

enforces they don't want you to be doing

this type of stuff so maybe limit your

results to a couple hundred max a day

it's up to you and now you might be

wondering what to do with all of this

information well if you do prospecting

you can also mass email the people

you've just hand-picked and selected in

a personalized way of course is the best

i would usually put a personalization

column so you can do like a mail merge

of some sort but you cannot do this if

you do not have somebody's email so here

is what we're going to do pick a profile

that you're interested in let's get

artem's profile copy it and i have a

tool that's called find that lead and

here in social you can just paste the

url over here

and magically it finds the email of the

person you can also upload in bulk your

entire list and get emails for all of

the leads that you just collected and

finally i want to show you how you can

build your custom scraper template to

extract information from linkedin or any

other website to google sheets very

easily so we're going to be building our

own scraper template option b shortcut

as you're already

used to create a new playbook and find

that scrape action we can scrape data on

the active tab meaning on the currently

open tab and we're going to create a new

scraper template here we have create new

scraper template over here we're going

to pick the tab from which we're going

to be grabbing the data

single page scraper

and here visually you can click on the

elements that you want to extract so for

this example we're going to be scraping

linkedin jobs and i want to grab the

title of the job i'm going to call it

job let's get some additional

information how many applicants it

already has location

just like this description

get this data and

that's probably everything i want to get

there's some information about the

company itself so i want to pick a

different data type and grab the link of

the company that has posted the job

link to the company it's called company

link and finally we're going to grab the

url to this job so this field is not in

the body of the page it's right there so

we can pick here

page link

and it's going to grab this this link

here you have the data preview save the

template

and just like this we've created a

scraper template for jobs

finally we're going to add this

information to

google sheets

over here

let's add rows to a spreadsheet we'll

need to create a new spreadsheet let's

do ask me every time argument

it's going to be called sheets

and map the data from the previous

action to

the google sheets action save collect

jobs to sheets

save

close the builder

and from here let's minimize the window

and let's create this job we're going to

create a new

sheet we're going to call it jobs

and let's get the information

a new sheet has been created

so here is the information

we need it and just like this you can go

ahead and click on another job that you

are interested in

and

run the section again

jobs

run this playbook the information is

going to get extracted and added to this

spreadsheet

so now you're literally a click away

from using this automation it's in the

description below so go try it out and

let us know how you use boarding to

extract information to sheets without

any code the tool is free right now so

make sure to give it a try and if you

need any help join us in our slack

community i'm going to see you in the

next video cheers

[Music]