I’m afraid that the location column will still require you to use geo-code data in order to fill in the details. Using just the address will not work for this column type.
This is something Integromat can handle better, at this time, as they do have a module that allows you to connect to Google Maps API in order to get geo-code data. You can find more info on this in the following community discussion:
Location column - move address into it from a text column
I hope this helps, although I understand this is not what you were looking to hear. This is still something for us to improve upon.
-A,ex