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

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,460,904
Community Members
 
Community Events
176
Community Groups

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

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 Nov 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 

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

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

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 Dec 03, 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

Atlassian Community Events