Skip to main content

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

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions 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.

Answer

“Failed to create an upload file in Google Drive The app returned "Forbidden"

  • November 29, 2023
  • 4 replies
  • 664 views
P

Hello! 

 

I’m just diving into Zapier so please bare with me. I read this support page and tried to replicate this zap - 

But I keep running into an error at the end that just says “Failed to create an upload file in Google Drive
The app returned "Forbidden". I made a Loom Video I made to walk through my Zap so hopefully that’s helpful. 

 

Ultimately I’m trying to upload the CSV file from the URL that the formatter is grabbing. Once I have the file uploaded to Google Drive I’d like to use another zap to upload the file to my Mailchimp account so I can automate updating my customer data (I own and operate several restaurants and order data is very valuable for marketing). 

 

I hope this is all clear and that someone call help me out!

 

Best answer by Troy Tessalone

@Pizzaman420 

Make sure to check the link in a new/different private browser to make sure there are no existing sessions for related apps.

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

4 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Troy TessaloneZapier Orchestrator & Solution Partner
  • Zapier Orchestrator & Solution Partner
  • November 29, 2023

Hi @Pizzaman420 

Good question.

The GSheet column header is “Links”. (plural)

Can there be multiple links in 1 cell?

If there is only 1 link in a row cell, then you won’t need the Formatter as Step 2.

The GDrive field expects a file url that is a public direct download link.

You can test this by copy/paste into a browser to see if it initiates a file download immediately.

If not, then the link can’t be used.

 

Help article about sending files in Zaps: https://help.zapier.com/hc/en-us/articles/8496288813453

⚡ Troy Tessalone - AutomationAce.com | Platinum Zapier Solution Partner | #1 Zapier Community Contributor
P
  • Pizzaman420Beginner
  • Author
  • Beginner
  • November 29, 2023

Hi @Troy Tessalone - thank you for your reply. When I click the link it immediately initiates a download to the download folder on my computer… I guess actually it downloads to the download folder on my chrome browser… 

 

Let me try removing the formatter step and see if that changes anything.

 

thank you,

Marc

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Troy TessaloneZapier Orchestrator & Solution Partner
  • Zapier Orchestrator & Solution Partner
  • Answer
  • November 29, 2023

@Pizzaman420 

Make sure to check the link in a new/different private browser to make sure there are no existing sessions for related apps.

⚡ Troy Tessalone - AutomationAce.com | Platinum Zapier Solution Partner | #1 Zapier Community Contributor
P
  • Pizzaman420Beginner
  • Author
  • Beginner
  • November 30, 2023

ahhh @Troy Tessalone this is why you’re an expert! yes there was an existing session which required a log in

Troy Tessalone
Terms & ConditionsAccessibility statement