Need script to be created to scrap data

write a python script which is a browser automation so it will follow all the steps that the human does on the browser

use a csv file that has the data of the "IndirectName" column as input and send each cell in the sheet to search

then we will extract the data of the search and once we collect all the data of the input file, we will export the data in csv file and you can merge it with the original data.

I will need to own the script once completed and script will be run a remote windows server.

I can provide link of video for reference.