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.

Hey Everyone! First time posting here so please go easy on me 😀

 

I am in the process of creating a workflow for my trainers and in the workflow we are basically looking to do the following in the following order:

1.  Complete a Google Forms questionnaire with the following fields: Name, Logo, Company ID, Services Signed Up Form. THIS IS DONE

 

2. After the form is submitted, create a google drive folder. The folder name will be the Name from the form. The logo needs to be uploaded to the folder. The Company ID needs to be added to the Google Drive Folder Description. The services will be used later on.

 

For now, I need to figure out how to have the logo uploaded to the folder, and I need to figure out how to update the folder description to what the company id is from the form submission.

 

When I try to upload the logo from the Google Form to Google Drive, it provides me with a 504 server error which Zapier is saying its a timeout because it can’t find the image. When I look in the spreadsheet from the form responses, the image URL is not an Image URL but rather a shortcut link to the Google Drive file.

Hi @VAIRKKO 

For us to have more info, post screenshots with how your Zap steps are outlined and configured in EDIT mode along with the encountered error.

Help link for sending files in Zaps: https://zapier.com/help/create/basics/send-files-in-zaps

I apologize @Troy Tessalone for not including these things again, first time here. 

Below is my current steps that are good in Zapier. First when a Google Form is submitted by my trainers, a folder for that client is created. Afterwards, I added a find folder action so I have the folder ID for other needs later on. Then the following 2 actions are to just simply create a couple of folders within the new client folder for Documents and a folder for Training Videos.

 

Below this is where I keep running into an error. My next step is I want to take the image of the company graphic that was uploaded to the Google Forms and add it to my Client’s folder. I have tried the traditional Google Drive File Link as well as the “downloadable” link both with no success. I have tried uploading the file, copying the file, and moving the file and nothing has worked so far.

 

@VAIRKKO 

We need to see how your Zap step 6 is configured in EDIT mode for the ‘Action’ tab section to have more context about the encountered error.

 

 

Step 3 is redundant.

Step 2 returns the created Folder ID.

 

@VAIRKKO 

Tool to help you understand the correct GDrive File link to use to upload: https://sites.google.com/site/gdocs2direct/

NOTE: The GDrive File needs to be publicly accessible, so you may have to adjust the file sharing preference.

 

@Troy Tessalone Thank you for the quick response!

 

This link you sent actually helped with the image step(step 6) I was stuck on: https://sites.google.com/site/gdocs2direct/

 

Now the question I have is, how can I format or “create” my image link (https://drive.google.com/open?id==FILEID]) from my Google Forms response to be in the format from the link you provided so it looks like this(https://drive.google.com/uc?export=download&id=pFILEID])

 

Lastly, if the file has to be publicly accessible to everyone, is there a way to automate that process as well within Zapier?

 

@VAIRKKO 

If the file has to be publicly accessible to everyone, is there a way to automate that process as well within Zapier?

Zap action: GDrive - Add File Sharing Preference

 

@VAIRKKO 

How can I format or “create” my image link (https://drive.google.com/open?id=aFILEID]) from my Google Forms response to be in the format from the link you provided so it looks like this (https://drive.google.com/uc?export=download&id=dFILEID])

 

Use a Formatter > Text > Replace

 

Hi there, @VAIRKKO 👋

Just checking in to see how things are progressing on this? 

Let us know if you’re still stuck at all or have any further questions - eager to ensure you’re all set! 🙂

Reply


Terms & Conditions