You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.
View groupJoin the community to find out what other Atlassian users are discussing, debating and creating.
@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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@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:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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...
Connect with like-minded Atlassian users at free events near you!
Find an eventConnect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.
Host an eventYou're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.