Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

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

Evan Knutson
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
November 30, 2022

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

1 answer

0 votes
milynnus
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 30, 2022

@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_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 1, 2022

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'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
December 2, 2022

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?

Screen Shot 2022-12-02 at 10.53.56 AM.png

mustafa sener _Hipporello_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 2, 2022

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
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 3, 2022

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

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events