I am looking to set up a workflow that will check for new files (images and short mp4) and once new files are picked up in Google Drive I want to take that file to Airtable. I want the file itself, the file description and the file type. I can get the file from Google Drive but I can not seem to hand it over to Airtable. I have tried the “move binary data” node but I can not pass the file itself.
What am I missing?
Thank you in advance.
If I want to work with the file that is inside G drive would I be better off trying to use the “Share Link” rather than trying to download and upload? I am only using Airtable to schedule posts and keep track of content. I do not actually need the file as such inside Airtable.
Do you have any recommendations on how to do this?
But assuming you have a file ID already, you can use this as your HTTP Request endpoint: https://www.googleapis.com/drive/v3/files/FILE_ID?fields=webViewLink, where you’d replace FILE_ID with the actual ID
If you don’t have that, you can pull it from the Google Drive node and its list function, but remember to make sure to use something like the Item List node to only return one item. If you return multiple items, the request I gave you would fail But you could then use https://www.googleapis.com/drive/v3/files/{{json.id }}?fields=webViewLink to get the share link without needing to hard-code the value
Take a peek at this post for a workaround:
But you could then use 