Import product list

Hi everyone,

i would like to import a product list from a business partner for who i build an API which allows me to import product list from their website into a GS sheet. However i’m wondering which way is the best to input those data into my glide app sheet, many columns are not labelled the same and they are not ordered the same into row.