@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?
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.
@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):
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:
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.
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