Taking Files From GDrive To Airtable

Describe the problem/error/question

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.

Please share your workflow

Share the output returned by the last node

Information on your n8n setup

  • n8n version: Cloud
  • Operating system: Windows

HI @Zac_Magee :wave:

I’m afraid you’re running into a limitation of Airtable’s API :see_no_evil: Take a peek at this post for a workaround:

1 Like

Hey There!

Thank you very much!

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?

Thank you!

Hi @Zac_Magee , no problem!

You’d have to use the HTTP Request node instead for a custom API call, and retrieve the webViewLink. You can read more about the metadata you can access from a file here: REST Resource: files  |  Google Drive  |  Google for Developers

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 :sweat_smile:

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 :bowing_man: 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 :+1:

I did something like this:

1 Like

Hey there!

When I get home tomorrow I will implement this!

Thank you very much, I never would have worked that out haha.

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.