Is this workflow just not going to work? Image Attachment export to Excel/Sheet

Question

Hi,

I'm a social media director and I'm trying to use Trello to collaborate and create content and then export to an excel or google sheet for my contractors to use as a template with merge fields for fast editing.

So far we've had to just copy and paste one way or another. I'm wondering if there's something I'm missing to be able to export my board to a sheet and still be able to see the image attachment.

I've tried to convert the cells with the Trello image URL to =IMAGE("URL") in sheets, and that hasn't worked.

Is this workflow just not going to work?

Ek

milynnus · Answer

@Evan Knutson

From each attachment, there is an url. Within it there is the card_id and attachment_id.

If this in google sheet that you would be able to feed your endpoint to download the image automatically. The function to use would be something like :

=IMAGE("https://moklxc.deta.dev/get_attachment?api_key=14a....1d7&token=be9....6cb4&card_id=626d1.....a609f1&attach_id=6389a815f267.....ce6d40",1)

If you have a dedicated backend you can have the api key and token feed from the .env

Above endpoint is available for testing.

mustafa sener _Hipporello_ · Answer

I see. I was trying to bring another angle to do this job and collaborate with your external contractors without exporting to anywhere. You stay on your board and your contractors can interface a web application that takes its data from your Trello board instantly. As a result, you will not need to export and import again.

Evan Knutson · Answer

I think that solves a different problem. I don't want to share my Trello boards or cards; rather, I'd like to export the data with the images to a spreadsheet or a table in a google doc similar to the image attached.

The trouble I run into is that the images don't appear, only the links so then I have to manually copy all of those images into the sheet. Not a huge pain, but I need it to be so easy an intern can do it lol.

Any thoughts?