Why is my google spreadsheet not uploading to trello?

[Bailey Brown]

Usually we have people fill out a Google Form, that info goes into a Google Spreadsheet, and that info automatically makes a card in Trello.

Now they have stopped uploading to Trello. I'm not sure where the connection got lost. Can anyone help?

[Iain Dooley · Accepted solution]

@Bailey Brown when you write stuff to a Google Sheet, it's added to Trello either via a trigger in Google Apps Script, or by some other automation such as Zapier.

Do you know which automation was being used to create the Trello cards?

[Bailey Brown]

I believe it is a trigger. It has to be considered a "new row" in Google Sheets. It happened before and my colleague had said something about the color formatting?? I'm just not sure what that means or how to fix it.

[Iain Dooley]

@Bailey Brown well if it's a trigger that was running in Google Apps Script, then it's probably a form submit trigger. These do spontaneously disappear from time to time, and it's a bug that has been causing frustration in the Google Apps Script community for the past 6 years. You can check by opening your spreadsheet and going to Tools -> Script Editor, then you need to look at the project triggers. You will either see the old style editor like this:

Or the new style editor like this:

If you don't see any triggers, then nothing is going to happen when your form is submitted. If you see a trigger, then it should be calling a function, and might show you some errors.

If you don't see the error, then you need to create it again and choose which function to run (there should be a function in the script editor for creating the Trello cards from form submissions) or you'll need to figure out how to fix it.

I can't really do much more than that in this forum, but this is also a service I offer professionally so if you'd like me to fix it for you you can email me on team@benkoworks.com

[Bailey Brown]

@Iain Dooley I appreciate this very much! However, when I go to the Script editor, it says that I do not have access to the file so nothing will load. Is there a way to fix this?

[Iain Dooley]

@Bailey Brown could be a lot of things. If you know who set it up for you in the first place you can get in touch with them, otherwise I can help you but I've reached the limits of the support I can provide for free in an unrelated product forum ;) feel free to email me on team@benkoworks.com

[Bailey Brown]

@Iain Dooley Okay, I figured out that problem. There are no triggers so I will need to create a new one correct?

[Bailey Brown]

@Iain Dooley Okay, no problem! Thank you for your help this far! I appreciate it.