this scrapes using python you will need python 3.12 which you can download on marketplace on any windows machine then you will have too download pip

• pip install pip
  

and you will also need some other packages

• pip install pandas
• pip install requests
• pip install python.dotenv
• pip install beautifulsoup

this can have a small change too have google sheet api support please read the documentation
https://cloud.google.com/docs/authentication?_gl=1*lyvsbd*_ga*NDk3NDI0NTYwLjE3MjI2MDEzNjU.*_ga_WH2QY8WWF5*MTcyMjg0MTQzMS4zLjEuMTcyMjg0MTQzMS42MC4wLjA.


as for extentions i use
- python debugger
- python
both from microsoft

you use the locations