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

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Excel Spreadsheet Embed

We run radio stations....and we use EXCEL to create announcer schedule. 

 

I would like to make this spreadsheet visible to announcers who use trello for their shift preparation. 

 

is this possible? 

 

 

 

2 answers

0 votes
Iain Dooley Community Leader Jun 16, 2020

@Larry If you just want to make the spreadsheet visible to them, you could upload the excel file to a card in Trello and they can all click on it to download it. However, do you mean that you'd like to import all the data from the spreadsheet and map those rows/columns onto cards in Trello?

make it visible....but i dont want to upload. i want it to LIVE update. If i change spreadsheet and it be visible there

This means that there will be 2 level of automation - (1) detect change on the spreadsheet (2) trigger change to Trello.

In the platform that I used, there used to have the ability to detect a change in Google sheet but more when adding a new line. Need to check whether that is still there. 

Alternatively, store a copy of the Google sheet as a python pandas as a global variable. Use a timer trigger to check periodically to detect change in any row and then trigger the update to Trello. 

i can also check whether the Airtable module can trigger an automation even if you use an Airtable instead of excel. 

Like Iain Dooley likes this
Iain Dooley Community Leader Jun 16, 2020

@Larry I've done a couple of implementations like this for clients but using Google Sheets rather than Excel, if you were happy to open the document in Sheets to make your edits then they could be translated live into Trello. Here's an example of one I did where rows are linked to a card in Trello (a new card is created if one doesn't already exist, then the link to the card is stored in the row so it will update on edit):

https://gist.github.com/iaindooley/87e4e4077544f3b206fd582ad04ec769

It would need to be customised for your purposes though, you wouldn't be able to just copy/paste it. You can read more about Trellinator here:

https://community.atlassian.com/t5/Marketplace-Apps-Integrations/Introducing-Trellinator-Automate-Trello-with-Google-Apps-Script/ba-p/925271

Screen Shot 2020-06-17 at 8.41.23 AM.png

This is just a demo of Google Sheet (spreadsheet) to Trello via Wayscript. If you have custom fields, the card_id is immediately available for you to use py-trello to capture the CF into the card or add more attachments. These can be brought into the script but not used in the initial creation of the card.

You probably need to use some automation tool to do it. One that takes in data from a spreadsheet, do some magic with it and populate and create your card with data field in row of the spreadsheet. A timer trigger would be useful so that you can focus on working on the schedule. You want to auto delete the old schedules. I suspect matching members and member to card will be required.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Trello

📹 What is Trello?

Hello Community!  My name is Brittany Joiner and I am a Trello enthusiast and Atlassian Community Leader. I'll be sharing with you a series of videos with my top tips on how to best use Trello...

793 views 13 30
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you