Best answer

Error when saving multiple images to Google Drive, from one Airtable attachments field

  • 12 May 2021
  • 5 replies
  • 267 views

Userlevel 1

I have a Zap that is throwing an error “The app returned “Access Denied” when I try to upload images from my airtable record to a google drive folder.

It only happens when there are multiple images in the airtable field.

What do I need to do to correct this?

icon

Best answer by Troy Tessalone 12 May 2021, 18:47

View original

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

5 replies

Userlevel 7
Badge +14

Hi @Keri2004 

Try using Looping to handle 1+ possible Airtable attachments into GDrive: https://zapier.com/apps/looping/integrations

Userlevel 7
Badge +14

@calebgonzalez Here’s a use case for Looping.

Userlevel 1

Thank you, I’ll give it a shot!

Userlevel 1

This worked for me!!!
 

Instructions:

https://zapier.com/help/create/other-functions/loop-your-zap-actions


Tips (things I didn't understand but muddled my way through it)

1. Used Action "Create Loop from Text"

2. VALUES TO LOOP: Wrote the Airtable field name "Attachments URL"
Then mapped that field in the next form field, with my Airtable field.

3. Left text delimiter as a comma.

4. Then in my next Action, "Upload File in Google Drive" make sure to use the fields from the Create Loop From Text action for your File, not the original fields from your Airtable record.  This frustrated me up for a good 45 minutes, lol.

Userlevel 7
Badge +11

That’s awesome to hear, @Keri2004 :) Thanks for sharing with the community!