How can i make Google sheets to generate the image filename instead of URL link from Google Forms

Support
1

Im using Google Forms and Google Sheets to generate automated videos for my company. They way it works is that someone fills a Google form with information they want in the video and After Effects is connected to the Google sheets page. The only problem is that when an image is uploaded in Google Forms the image is converted to a URL link and this only works if it's the image name. For example: img_22354.jpg instead of a URL. I would be eternally grateful if someone found a solution to this.

Im a beginner in Google sheets and Google forms

Thanks!

2

Hi @Elias_Nilsson
welcome to the forum! Please introduce yourself here!

unfortunately currently it's not possible to change that behavior. There is a topic in Features I created recently Improve the way we refer media files in Google Sheets
I added your comment there to proof that there are more users who need changes in this area.