I feel like this is gonna be a tricky one but that is why I am asking for the help. We track all our enquiries in google sheets. We have multiple projects that concern different contractors so we keep a number of different workbooks. However, there is a master sheet that is an consolidated view of all of the sheets which can be found here:
I am wanting to create a new Trello Card whenever the follow up date becomes blank. That is probably the easiest trigger for it being 'booked' that I can think of. When it creates a card I want it to use the source column to figure out which 'list' to put it in the Trello Card. Additionally, by default I want each card to be titled with the clients Name and Date as on the spreadsheet and pre-populate with a template check list which we have for each client.
How possible is this? I understand it's very specific but would make our process much faster and most efficient! :)
Most of this should be possible by setting up some zaps in Zapier. Within Zapier, you can set up a zap which uses an update in a row (with your "Follow-up" trigger) to create a new card in Trello.
It won't be possible to get them sorted in to the right list immediately, but you could make sure that the relevant information from the Sheets rows are included in your title and description on the card.
Once the cards are being created from the zap, you could then set up a Butler rule within Trello which could pick up the text in the title to send it to the correct list. You would need to set up a separate rule for each list.
I hope this helps!
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