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.
-
You MUST read the Babiato Rules before making your first post otherwise you may get permanent warning points or a permanent Ban.
Our resources on Babiato Forum are CLEAN and SAFE. So you can use them for development and testing purposes. If your are on Windows and have an antivirus that alerts you about a possible infection: Know it's a false positive because all scripts are double checked by our experts. We advise you to add Babiato to trusted sites/sources or disable your antivirus momentarily while downloading a resource. "Enjoy your presence on Babiato"
[Help] Scrape the number of followers from Twitter and LinkedIn from profile link and username in google sheets
- Thread starter CooLi
- Start date
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 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.
Similar threads
