About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Question

Help with transferring Airtable attachments to Google Drive?

  • 6 January 2023
  • 3 replies
  • 660 views
S

I’m trying to use Zapier to link New/Modified Records in Airtable with Multiple Attachments to Upload the Attachment Files to Google Drive. This way, we can have all the file attachments we collected via an Airtable Form in one google drive folder.

I’m using the Loop functionality, but am having a hard time getting it to work.

 

I have this workflow:

1 New or Updated Record in Airtable » 2 Create Loop from Text in Looping » 3 Upload File in Google Drive.

 

In using Create Loop from Text, is the Values to Loop just the name of the Airtable Field of the Attachments, which in my case is just “Attachments”? Then its mapping is the “Attachments Url” from Airtable?

Then in the Google Drive Upload File, under File (required), I would choose the 2. Attachments URL of the Loop?

I’ve tried the above dozens of times, but I just cannot transfer the files in Google Drive.

 

Any help is appreciated.

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

SamB
Rank
Userlevel 7
Badge +11

Hey there @soadg, welcome to the Community! 

I did some checking and Airtable sends the attachments over as line items. So I’d suggest setting the Looping by Zapier step to use the Create Loop from Line Items action instead. Then select the Attachments Url field for the Values to Loop in the Looping by Zapier step. On the Google Drive step, select the field, from the Looping by Zapier step, that contains the attachments (don’t select the Attachment Url field from the Airtable step). That should allow the Zap to loop through the line items and upload them to Google Drive.

One thing to note on this is that if you’re testing this out in your Zap, the Google Drive step would only upload the first item in the loop. When the Zap is switched on though it should run through all the files.

Hope that helps. Let us know if that does the trick! 😀

S

This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.

Thanks so much for your reply.

I just tried this about a dozen times, but keep getting the “This URL has expired” when testing in Zapier. 

Regardless, when running the Zap, I get message that “Create Loop From Line Items” was successful, and Google Drive “Upload File” was successful.

However, on the Google Drive folder, I just got abstract files with long names, probably the url. 

 

So I edited the Zap to include filename (of name of person submitting Airtable form) and the Airtable Record ID, and added the extension of JPG, and now yes, some of the files are passing through to Google Drive.

 

However, I’m getting only file per Airtable record, even if the record has multiple file attachments in the Attachment field. So the Zap doesn’t seem to be looping…. I also tried appending the Loop ID in the file name, but still no looping (as shown in attached screenshot).

 

Would you have any idea how to make sure the Zap loops to account for multiple files in the Airtable attachment field?

 

Just to make sure, I attach 2 screenshots showing the 2 steps of the Zap.

Thanks so so much for your help!

2 Attachments
shalgrim
Userlevel 6
Badge +8

Hey soadg!

Looking at the values in the attachments list from Airtable, it looks like not all of them have a URL field. They all do have a File field, though. Do you want to try that instead?

Terms & Conditions