Create a Program that compares data on a website and Updates a google Sheet (Excell)
Budget: £20 – £250 GBP
We are looking for a developer that would be able to create a program that would be able to login and search a website for certain data and update a google sheet with the information found.
The program will need to be able to:
1- Login to the website
2- Navigate to a specific client profile
3- Compare data on the client profile with the spreedsheet
4- Update the spreadsheet
Here are some guidelines for the skills that may be needed
-> Knowledge of web scraping and programming.
Identify the website and the client profile pages that you want to extract data from.
Determine what data you want to extract from the client profile pages.
Choose a programming language, such as Python, and install the necessary libraries for web scraping, such as BeautifulSoup or Scrapy.
Write a script to log in to the website using the requests library or a headless browser like Selenium.
Write code to navigate to the specific client profile pages and extract the data using web scraping techniques.
Parse the extracted data into a format that can be written to an Excel spreadsheet using a library like Pandas.
Finally, write the extracted data to an Excel spreadsheet.
The program will need to be able to:
1- Login to the website
2- Navigate to a specific client profile
3- Compare data on the client profile with the spreedsheet
4- Update the spreadsheet
Here are some guidelines for the skills that may be needed
-> Knowledge of web scraping and programming.
Identify the website and the client profile pages that you want to extract data from.
Determine what data you want to extract from the client profile pages.
Choose a programming language, such as Python, and install the necessary libraries for web scraping, such as BeautifulSoup or Scrapy.
Write a script to log in to the website using the requests library or a headless browser like Selenium.
Write code to navigate to the specific client profile pages and extract the data using web scraping techniques.
Parse the extracted data into a format that can be written to an Excel spreadsheet using a library like Pandas.
Finally, write the extracted data to an Excel spreadsheet.