Google Drive as footage folder

motvion

Hi,

I’ve tried to use a Google Drive folder as a Footage folder folder for my images (instead of using Dropbox).

I’m using a Google Form to get all the data: text, info and images. Everything is collected in a GoogleSheet, but for the image cell I just get the file ID that GoogleDrive sets when you upload an image or file.

And Templater doesn’t recognise this file ID url as it doesnt contain the file name + extension.

Do you know if there’s any solution to get the real footage url instead of the file ID?

I know it’s not a Templater issue rather than a Google Drive / Google Sheets files structure, but would be great to use Google services as the only place to get all data + footage.

Any eay to try to solve it?

Thank you so much for help!

Cheers,

Motvion

ariestav

Thanks for the question, and welcome to our forum. Templater needs a reference to the actual asset file, as opposed to some URL hash that Google Forms creates. It is likely that you could get the reference to the uploaded asset after submitting the form. If you can write custom code to retrieve the actual URL and the insert it into the same row, that should work. We do plan on supporting hashed URLs for footage asset refs. I apologize for the disappointing info here, but there may be a third party Forms plugin that might let you get the actual URL reference to the asset.

Please let us know if you have further questions!

Thanks again for coming to the forum to post! Shared knowledge is good knowledge