Automatically assign images using entity ID

I’m currently facing an issue and would appreciate some guidance from the Yext community. Here’s the problem I’m encountering:

I have been exploring two methods to achieve my goal of automatically sorting uploaded images to the fields in the correct location entities using location/entity IDs.

The first method involves using the Google Drive connector/API to load images from my Google Drive. However, I’m facing limitations with this approach. The API implementation is quite basic, and it doesn’t allow me to choose specific folders where my image files are located. Additionally, I’m unsure about where from the Google Drive connection I should get the location/entity ID for the association.

The second method I considered is building an Excel sheet containing all the necessary data, including the image URLs and the corresponding entity/location IDs. This approach seemed promising initially, but I encountered an error: "Error uploading photo: image is invalid: does not start with valid magic bytes, starting string is <meta name=“g.” This error occurs specifically for Google Drive links where I uploaded the images. Furthermore, when I attempted using other images, I received an “Error: Context line exceeded” message.

I’m seeking advice on how to proceed with resolving these issues. I am aware that my approach to my goal (automatically assign images to entities using entity IDs) might be incorrect, and there might be a better solution for it. Any insights or recommendations from the Yext community would be greatly appreciated.