I have an app with a field IMAGE1. User can take a picture with a phone. The file is stored in a drive folder and the path is in the column value a the google sheet.
Filenames are weird: ex: 063713226396.Photo 1.013339.jpg
I wanted to copy the image to our server and link to it on our shopify store but the url not working because of the . and space.
Can I do something about it? I have over 3000 images, I really don’t want to do it manually.