Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

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

Trello labels from Google Sheets via Automate.io ?

I'm having a hard time getting labels to transfer through from Google Sheets to my Trello cards.

Automate.io either doesn't add anything or gives an error, depending on the format I use.

I have tried using the label name (including making sure it's one word), the color, a number 1-9, and also the unique color ID.  Any suggestions on making this work?  

Zapier will bring in the label name but will add it as a new label with no color.  I would prefer to use Automate.io though, but just including this as a note.

 
Thank you,

Heather

2 answers

0 votes

Hi Heather,

Crystal from Trello Support here. 

Unfortunately as Automate.io is a 3rd party provider we don't have much information on their specifications. Perhaps Automate can run custom code? If so, you could use the API to add the label: https://developers.trello.com/v1.0/reference#labels

 

Let us know if there is anything else we can help with!

Hi,

 

I found the solution : you "inspect" the page in Chrome and copy the id-label of your label into the column labels of your Google Sheets.

In your bot you put "use custom value" and you use the column "labels" of your sheet. It works perfect.

Thanx Sebastien !
Could you please detail the way you call your personal label in google sheet please ?

  • I have a google sheet, a zap (I use zapier instead of automate.io) and a trello board
  • I import my labels with "custom labels", but a new label with "no color" is created (duplicate without color)
  • I tried to add my data-id-label="5f19cbff9e699828cc258026" with various syntaxes, but it doesnt work

🙏

Suggest an answer

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

📹 Favorite Trello templates

Hello Community!  My name is Brittany Joiner and I am a Trello enthusiast and Atlassian Community Leader. In this video, I'll share my favorite Trello templates. Templates mentioned in ...

1,418 views 12 32
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