i'm trying to retrieve travel distance and travel time from this XML URL :
- For example, when you want to retrieve the values to the columns, please use
TRANSPOSE
like=TRANSPOSE(IMPORTXML(A1,"//*[local-name()='TravelDistance' or local-name()='TravelDuration']"))
.