Can I include animal photos in my transport list?

  • Updated

Since the transport list generates a CSV file, the initial download will only provide you with a URL where you can access an animal's cover photo. However, if you copy and paste the transport list into a Google Sheet you can turn the URL into a formula which will populate the image into your transport list. 

When a transport list is generated, the photo URL will look something like this:

https://www.shelterluv.com/sites/default/files/animal_pics/59/2019/09/12/14/20190912140919.png

Once you have copied and pasted your transport list data into a Google Sheet, you'll want to use the Find + Replace function to edit your photo URL's in bulk to include the additions shown in bold below:

=image("https://www.shelterluv.com/sites/default/files/animal_pics/59/2019/09/12/14/20190912140919.png")

Once you have done this you will notice animal photos populate where the link used to be. You can then resize your cells so the photos appear larger, and the animal's faces can clearly be seen.

Click here for a video walkthrough of this process. If you need assistance, please feel free to contact help@shelterluv.com