Hello: I am new to python programming and was trying to webscrape to pull comparable values into zillow

for example if I have the URL link for a Zillow property address in cell A1 in an Excel file:

In Cell A2, I am trying pull the Zestimate amount and loop through the worksheet following the same process for all properties on the sheet.

Any code/assistance achieving this would be greatly appreciated.