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