Create a Program that compares data on a website and Updates a google Sheet (Excell)

Job ID: 36257289

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.