It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Automating cards based on values in google sheets

Hey guys, 

 

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: 

https://docs.google.com/spreadsheets/d/1uywwr0D3WfinvxclpZ5uJGZvxNS1lexhe7NscCnkjeE/edit?usp=sharing

 

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! :) 

 

Thanks heaps. 

 

 

1 answer

0 votes
Ryan Anderson Atlassian Team Monday

Hi Peter,

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!

Ryan

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Trello

Are Atlassian tools a good fit for your marketing team? Find out.

When I got appointed as the Marketing Specialist at TechTime in October 2019, I was introduced to the world of Atlassian. Working in tech, I knew about the tools - but never been exposed to it. At f...

384 views 6 5
Read article

Community Events

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

Events near you