[Help] Scrape the number of followers from Twitter and LinkedIn from profile link and username in google sheets

CooLi

Member
Aug 25, 2022
78
10
8
Hello guys, I have managed to extract the usernames and profile links of LinkedIn and twitter accounts, but I want to extract the number of followers for each of the accounts using the google sheets import function or another way and copy and paste it to google sheets? would appreciate any help thank you.
 

Piyu03

Active member
Trusted Seller
Trusted Uploader
Feb 24, 2019
366
212
43
India
How you're extracting it? Which programming language you're using?
I also scrapped Udemy a few weeks back using Selenium and Python.

There while scrapping Udemy content It wasn't required to add the things in an excel file.
I directly added the entries in the MySQL database.

But If by any chance I want to put all the entries in an excel sheet I can use the XSS, and ApachePOI libraries to prepare the excel file.

Not sure if you only need the export to google sheets only or if preparing an excel and importing it manually to google sheets will work.
 
  • Like
Reactions: CooLi

Piyu03

Active member
Trusted Seller
Trusted Uploader
Feb 24, 2019
366
212
43
India
Also, I hope you're already aware of it but just informing you that nowadays there are a lot of things going on with LinkedIn scrapping, and botting. Make sure you're not violating the policies. Play wisely.
 

CooLi

Member
Aug 25, 2022
78
10
8
How you're extracting it? Which programming language you're using?
I also scrapped Udemy a few weeks back using Selenium and Python.

There while scrapping Udemy content It wasn't required to add the things in an excel file.
I directly added the entries in the MySQL database.

But If by any chance I want to put all the entries in an excel sheet I can use the XSS, and ApachePOI libraries to prepare the excel file.

Not sure if you only need the export to google sheets only or if preparing an excel and importing it manually to google sheets will work.
I haven't used python or selenium, I just used google sheets import HTML function to get Twitter and LinkedIn links by using a google search query from first name and last name, then I got my result. But now I need to scrape the follower count from those links from Twitter and LinkedIn and get results of each profile's followers count. I am sure there will be a way to use the import HTML function again or maybe it is not possible. Am lost.
 

Piyu03

Active member
Trusted Seller
Trusted Uploader
Feb 24, 2019
366
212
43
India
If you can share the sample entries sheet then maybe I can help.
 
  • Like
Reactions: CooLi

Latest posts

Forum statistics

Threads
69,229
Messages
908,448
Members
237,068
Latest member
iraqi9292

About us

  • Our community has been around for many years and pride ourselves on offering unbiased, critical discussion among people of all different backgrounds. We are working every day to make sure our community is one of the best.

Quick Navigation

User Menu