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.

Best answer

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

  • 29 November 2023
  • 4 replies
  • 260 views
P
Userlevel 1

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!

 

icon

Best answer by Troy Tessalone 29 November 2023, 22:08

View original

4 replies

Troy Tessalone
Userlevel 7
Badge +14

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 | Premier Certified Zapier Expert | #1 Zapier Community Contributor
P
Userlevel 1

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
Userlevel 7
Badge +14

@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 | Premier Certified Zapier Expert | #1 Zapier Community Contributor
P
Userlevel 1

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

Reply


Terms & Conditions