Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

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 Atlassian Team Feb 17, 2020

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
TAGS
Community showcase
Published in Trello

📹 What is Trello?

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...

233 views 7 14
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