Creating and deleting Trello cards from Excel data

Question

I'm looking at using Trello to display our daily production schedule in a manufacturing facility.  Trello would contain lists for each piece of manufacturing equipment, and I would like to have a card displayed for each task for each machine.

I have all of my data in an Excel spreadsheet.  The spreadsheet is updated one time per day.  I want the ability for Trello to delete all previous cards, and update it by pulling in the data from the spreadsheet.  Basically, once a day, I want Trello to display the contents of the spreadsheet.

I looked at Zapier to automate the process.  It wasn't able to delete the cards in Trello.  It was only able to add new ones.

Any ideas?

Thanks.

Antonio Panea · Answer

Hi @Troy_Sherven ,

sorry but I couldn’t give you a better solution with Zapier. Nevertheless what @Iain Dooley said it will solve your problem for sure! Thanks @Iain Dooley for jumping here to help!

Stay safe!

Toni

Iain Dooley · Answer

@Troy_Sherven you could do this with Trellinator by importing your data into a Google Sheet, and then using that to trigger an import from the spreadsheet into each list. The code would look something like:

https://gist.github.com/iaindooley/a8f5f90ba46b52eaac05505a4b0ffca7

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

Troy_Sherven · Answer

The issue I have is that I'm planning on using Trello just to display my daily tasks.  Every day my spreadsheet will have new tasks.  The tasks from the previous day will not be listed on my spreadsheet.

Trello will be on a large monitor for workers to view.  No one will have any interaction with the cards to mark them as complete.

Even if I can't automate the process of archiving the cards, is there a way to bulk archive all cards directly in Trello?  I've found a way to archive all cards on a list, but not all cards on a board.