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

[Evan Knutson]

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]

@Evan Knutson 

There are several power up that allows you to share content but perhaps not in the way you wanted.

Recently, I have been exploring Hipporello and it has a pre built Share Card that allows you to share content. You external party gets a "Share with me" link on the portal to view and download the attachment. 

@mustafa sener 

[mustafa sener _Hipporello_]

Hi @Evan Knutson @milynnus 

As @milynnus mentioned, you can use Trello Card to share the card with your third parties. You can customize this Trello Card sharing app according to your needs to allow your end users to edit certain card properties and attach. 

You can contact us if you need any help or detailed information via support@hipporello.com

Also, you can check our website and get live support https://www.hipporello.com

[Evan Knutson]

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?

[mustafa sener _Hipporello_]

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.

[milynnus]

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