I have been trying to import some metadata from Cloudinary to Google sheets. Unfortunately, not all metadata is found for all images. This proves to be a challenge as metadata is obtained for each image - and therefore the metadata for the same property is placed in different columns.
I have thought about using some fixed columns.
In the example below I would use three columns: Make, Orientation and Exposureprogram.
As it can be seen in the example the Orientation would be empty for image 2
Based on the importJSON script
|Apple||Horizontal (normal)||Program AE|