You can, with this: https://www.labnol.org/google-maps-sheets-200817
Of course this requires Script, but at least you don’t have to write a new one.
The formula I am talking about is GOOGLEMAPS_REVERSEGEOCODE.
You can alter the script to only show post codes, or split the address to read only the post code in the final column.