Populate Postcode Data in a spreadsheet

I have a spreadsheet with 40k address entries. Most of these addresses do not have a postcode included. I need you to write a script that selects each address from the spreadsheet, enters that address in a postcode lookup website, retrieves the postcode, then writes the postcode back to the same spreadsheet. I have attached the spreadsheet which has the steps explained in it.