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

File created from Google Docs template can’t be opened after uploading to Dropbox

  • 26 January 2022
  • 5 replies
  • 52 views
D
Userlevel 1

I have a zap that takes information from a Google Sheet row and uses the information to create a set of folders in Dropbox with a specific name. All works great!

I have a step to upload a template file to one of the newly created folders. The file URL is a Dropbox file link. The file is a template Google Doc created in Dropbox that is copied to the new folder and renamed. The only problem is the file won’t open when clicked.

If I were do this outside of Zapier. I’d create the folder, copy and paste the Google Doc Template file and paste it into the folder then rename. This changes the URL address and effectively creates a new file. I’m wondering if the upload process isn’t quite getting this right.

icon

Best answer by justin.vanos 26 January 2022, 12:39

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

J
Userlevel 3
Badge

Hey @daveaudio !

This is a great question here, do you know if the Dropbox URL for your file is password protected?

Even though the Dropbox step is authenticated, it’s pulling the file from a (at least from its perspective) 3rd party source. So the file needs to be publicly accessible. 

At the moment, it’s likely uploading a text file of some sort which isn’t a gdoc file, is that the case?

Let me know if you need anymore help!

- Justin
D
Userlevel 1

Thanks for your reply. The file link has no password and is set to allow access to anyone with the link.

The file created is a Google Doc, however it’s worth noting that the created file size is bigger than that of the file being copied from. Original template file is 200 bytes (4KB) and the Zapier “Upload” is 153 KB.

 

J
Userlevel 3
Badge

Hey @daveaudio 

Thanks for the reply here, I took another look and I think I know what the issue is. 

The download flag in your URL is set to false or ‘0’. 

This integration needs a URL where if you plug it into a browser, it will automatically be set to download. With the flat set to ‘0’, it’s not automatically downloading so it’s possible it’s just grabbing the html page. 

Would you mind setting this flag to ‘1’ or true to see if that works?

 

https://cdn.zappy.app/62e6e72385f82c7f3702abe47e16f0de.png

 

 

- Justin
D
Userlevel 1

Amazing! This fixed the issue. Great insight. Changing the URL dl= from 0 to 1 and running a test generated the file and it will now open as a Google Doc.

Thank you for the speedy troubleshooting.

 

christina.d
Userlevel 7
Badge +9

Yay! 🎉Thanks for keeping everyone updated on what did the trick, @daveaudio!

Terms & Conditions