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.
@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:
You can read more about Trellinator here:
Hi Toni, thanks for the response. Archiving the cards would work, but they would all need to be archived each day. Using Zapier, would it be possible to archive all of my cards, then import the data from my spreadsheet? This would only need to be done once a day.
Would I manually trigger the archive process and the import process? Could I write one workflow that would do both functions?
Hi @Troy_Sherven ,
I am afraid you can not do that with Zapier since is not reading from an spreadsheet in bulk and neither filtered depending on parameters.
Nevertheless changing the status of your tasks in excel could be a trigger in Zapier for archiving a card in your Trello board. What do you think?
Hope it helps!
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.
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 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