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

Introducing Trellinator: Automate Trello with Google Apps Script

52 comments

Iain Dooley Community Leader Nov 19, 2019

@Camiel_Wieme_SA the error "Getting Trello member ID invalid token" means that you haven't pasted your api key and token properly into the configuration sheet. The rest of the errors are caused by that as well.

Hi Ian, 

Thanks for helping out. 

I managed to get the helloWorld script working.

Now I'm trying to move on, but it has been a while since I did some programming in Java(script). Are there anymore example of functions and stuff?

I would like to create a script that count the cards with a specific label in a pipeline. So if a pipeline has 5 cards with label "must" and 3 with "nice", I would like to automatically create a card with a sort of report saying:

Must : 5 

Nice: 3

The trigger can be adding a new card or preferably a Butler Board Button. 

Hopefully you can help me again. 

 

regards, 

 

Camiel 

Iain Dooley Community Leader Nov 20, 2019

@Camiel_Wieme_SA firstly if you want to trigger this with a butler board button, then you'll maybe need to add a label using the button then use that as the trigger to execute your function (then you can remove the label from the function to reset it). You could also use the ExecutionQueue to do a recurring trigger in Trellinator:

https://www.theprocedurepeople.com/trellinator-automate-trello/docs/module-TrellinatorCore.ExecutionQueue.html

There's a reference API for Trellinator:

https://www.theprocedurepeople.com/trellinator-automate-trello/docs/

But if you want to get a feel for how to solve typical problems and a sense of "idiomatic" Trellinator with lots of examples just browse through all the gists I've made while posting comments here on the community, there are hundreds of examples:

https://gist.github.com/iaindooley

With the combination of those examples and the reference documentation you should be able to get a handle on it.

To give you a head start the function to do what you want executed hourly would look like this:

https://gist.github.com/iaindooley/adcdbcda0eaf4c634b9bf4127f445f88

Hi there!

@Iain Dooley listen, I'm facing a bit of trouble with a new installation, followed exactly your steps here but keep getting an unknown error, look:

["helloWorld executing from queue...","Error executing function: Exception: Invalid argument: https://api.trello.com/1/tokens/58397c7961017570ed9127475e7055da397cbe3c29e21d06bf9fc71c83e3d0fd\r/member?key=d7678894c4045f2aa42e6e9c81f3e541&token=58397c7961017570ed9127475e7055da397cbe3c29e21d06bf9fc71c83e3d0fd","helloWorld executing from queue...","Error executing function: Exception: Invalid argument: https://api.trello.com/1/tokens/58397c7961017570ed9127475e7055da397cbe3c29e21d06bf9fc71c83e3d0fd\r/member?key=d7678894c4045f2aa42e6e9c81f3e541&token=58397c7961017570ed9127475e7055da397cbe3c29e21d06bf9fc71c83e3d0fd"]

This invalid argument is troubling me. Can you shed any light?

Ian, I can't get it to work with a new account. It says invalid argument to very request, even the simplest one, this Hello World example you posted here. Can you help? 

@Lucas Fogolin see that "\r" at the end of the token before "/member" in the URL? My guess is wherever you copied the token from snuck a carriage return in there, you just need to delete that from the configuration tab

@Iain Dooley actually no, there's no '\' in any part of the key nor the token, but doing some digging In this new account, I realized that,different from my previous one, when I generate the API key the whitelisted URLs do not have the wildcard "*" and I can't add it there. Would, maybe its something to do with this issue? I took a print:
trello.png

Iain Dooley Community Leader Nov 28, 2019

@Lucas Fogolin that origins thing is only for OAuth2 authorisation flows afaik. It's not relevant to Trellinator setup, I've never used it before. Have a look at this screenshot:

2019-11-29 at 10.35 am.png

Yes, I understand what you're saying, but I've checked the keys and they don t have this added there, no '\r'. I've  tried twice, following the setup here from scratch, but it generated the same results both times. Won't you try it from scratch with a new account just so you can see what I'm talking about?

Iain Dooley Community Leader Nov 28, 2019

@Lucas Fogolin I've set it up from scratch like 6 times today ;) If you share your spreadsheet with iain@benkoboard.com I can take a look for you

Dear Colleagues, when I try to Initialize utilities I have to give permissions to App, and then I receive notification "sign in with Google is temporarily disabled for that app. This ass has not yet been verified yes with Googe..." Same warning I receive when I publish script as an app.... 

Had anyone experienced that?

Hey @Iain Dooley , Google has changed the way that they send posts back because currently I'm unable to set up a webhook since GAS is not sending a proper response to the initial webhook initiation.  Is there any insight that you might be able to give on this? I know that the webhook is working b/c I have tested it in postman, and it's not that it's not a permissions issue -- it's just that it's not sending the proper response back.  I have literally tried about everything (almost everything, I'm hoping).  Any insight you might be able to give?

Iain Dooley Community Leader Jul 27, 2020

@Rob Schaerer this has always been the case and is one of the reasons you need a buffer in between Trello and GAS. GAS doesn't respond to a HEAD request, so the buffer has this nginx config that will do it:

https://github.com/iaindooley/trellinator-buffer/blob/master/nginx_template.txt#L2

@Iain Dooley I have no idea how I had it set up at one time then -- I actually had it working directly to GAS somehow for a while and then it just stopped.  Thanks for that -- I've been playing around on AWS for a while now, might as well play a bit more.

Sam I'm New Here Oct 05, 2020

This tutorial is very clear. thanks. 

Iain Dooley Community Leader Oct 05, 2020

@Sam cool thanks, you're the only one who has ever complimented this tutorial on its clarity ;)

@Iain Dooley Hey, this looks really promising. I was looking for something to help me do things that Butler couldn't... like simply counting how many cards are in a list.

Slight issue however, this is what happened after this step:

Now choose “Tools > Script Editor”. Once the Script Editor opens choose “Publish > Deploy as web app”.

image_2020-11-17_013712.png

Any ideas? Would like to add that "Trellinator Utilities > Initialize" worked fine but that's probably unrelated.

Thank you!

Iain Dooley Community Leader Nov 17, 2020

@aericio did you see that after publishing the web app and then trying to open the published URL in a web browser? If so, try publishing again -- there seems to be something odd maybe to do with free accounts where the script ID changes the second time you publish it ... sometimes :S it doesn't seem to be consistent and may be a change that crept into GAS since I wrote this article. 

@Iain Dooley Neither, that showed up right after I clicked on "Script Editor". Sorry about that, just realized the step I copied was misleading. I was never able to publish.

Here's a video of what happens https://streamable.com/3qr6qi

Iain Dooley Community Leader Nov 18, 2020

@aericio weird :S Is Apps Script available in other spreadsheets? I'm afraid that's something that looks like a problem with your Google account rather than with Trellinator specifically 

@Iain Dooley Yup, it shows up on other spreadsheets. If I click on "Script Editor" on the new sheet, I get the same error...

Anyways, I think I'll just give up and try again in the future. Thanks for your help!

Ah whoops, just realized "Script Editor" is a separate thing from AppSheet lol.

Looks like this is my exact issue. https://support.google.com/docs/thread/13014914?hl=en

So I opened up another web browser with only one account signed in and now the "Script Editor" is able to open without any issues. 

Iain Dooley Community Leader Nov 18, 2020

@aericio ah yes, I've seen that with quite a few of the cloud and drive URLs. For that reason, I never use Google's multiple login feature, I only ever keep separate accounts in entirely separate Google Chrome profiles.

Comment

Log in or Sign up to comment
TAGS
Community showcase
Published in Marketplace Apps & Integrations

Do Not Lose your Customer’s Trust

Missing deadlines is one of the biggest problems every team lead wants to avoid when dealing with managed services. When the customer contracts your company to help with IT services it is expected th...

299 views 0 2
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