Introducing Trellinator: Automate Trello with Google Apps Script

[Iain Dooley]

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

[Camiel_Wieme_SA]

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]

@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

[Lucas Fogolin]

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?

[Lucas Fogolin]

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? 

[Iain Dooley]

@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

[Lucas Fogolin]

@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:

[Iain Dooley]

@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:

[Lucas Fogolin]

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]

@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

[Dima_D]

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?

[Iain Dooley]

@Dima_D see my comment here: https://community.atlassian.com/t5/Trello-questions/Re-Re-How-to-automate-the-connections-between-two-cards/qaq-p/1332732/comment-id/23021#M23021

[Rob Schaerer]

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]

@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

[Rob Schaerer]

@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]

This tutorial is very clear. thanks. 

[Iain Dooley]

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

[aericio]

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

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

Thank you!

[Iain Dooley]

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

[aericio]

@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]

@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 

[aericio]

@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!

[aericio]

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

[aericio]

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]

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