Trello image uploading issues with Google Drive

Hi ​@KBogga1234 

Screenshots do not show steps 7-8, so feedback below may be incomplete.

You should not need a Code step.

Make sure there is no leading/trailing whitespace around the URLs being used.

Zap action: Formatter > Text > Trim Whitespace

Try these Zap steps related to the Trello Card and Attachments. (Assuming you cal layer in your other Zap steps, such as for Slack, etc.)

1. Trigger: GForms - New Form Response
2. Action: GSheets - Lookup Row
   1. This step may be redundant if it is finding the same GSheet row from Zap step 1
      1. GForm responses are saved to GSheets
         1. Alternative is to use this Zap trigger: GSheets - New Row
3. Action: Trello - Find Card
4. Action: Looping - Create Loop from Text
   1. Split by: ,
   2. Map the variable with the GDrive file links from Zap step 1 or 2
5. Action: Formatter > Text > Replace
   1. Replace from: https://drive.google.com/open?id=
   2. Replace with: https://drive.google.com/uc?export=download&id= 
6. Actin: Formatter > Text > Trim Whitespace
7. Action: Trello - Add Attachment to Card

For us to have more info, post screenshots showing how your Zap steps are configured in the CONFIGURE tab while in EDIT mode, and showing the DATA IN/OUT for each step to help us trace the data flow, along with what the files with issues look like when uploaded to the Trello Card.

 

I have been running into problems with multiple images being uploaded to trello and was wondering if anyone could please help with this. To summarize the workflow in the image I attached:

1. I receive a Google form from client including all the images for their project. These images are stored in a public Google Drive folder and are listed in comma-separated links in a Google Sheet
2. I created a custom Python script that reformats the drive link into a downloadable image link (https://drive.google.com/open?id=1un2FDKA-T96Sv7etxaoJYs_j_YeDROL5 → https://drive.google.com/uc?export=download&id=1un2FDKA-T96Sv7etxaoJYs_j_YeDROL5)
3. To upload multiple image files to a Trello Card, I created a Looping Action to upload the images via. URL Attachment (The images CANNOT be thumbnails, they require full resolution)

Here is my issue and my attempts on fixing it:

1. The images are randomly being uploaded broken. If I re-run the Zap on a card with broken images, different images will be broken the second run.
2. Guessing it was an overloading issue, I added a 2 minute delay, but everything still uploads broken, just slower
3. I have tried alternative image links, but none have worked so far

Hello ​@KBogga1234 
 

This usually happens because Trello URL attachments are fetch based. Trello pulls each Google Drive link in the background and when multiple large images are fetched close together Drive can throttle or return partial files. That’s why images break randomly and reruns break different ones.

The most reliable fix is to upload the actual file instead of a URL. Add a Google Drive Get File step and map the file into Trello Add Attachment so Zapier uploads the full file.
 

https://help.zapier.com/hc/en-us/articles/8496295831821-How-to-upload-files-in-Zaps
 

If you continue using URLs make sure your loop sends exactly one image per Trello action run.