Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Why is my google spreadsheet not uploading to trello?

Bailey Brown March 4, 2021

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?

1 answer

1 accepted

2 votes
Answer accepted
Iain Dooley
Community Champion
March 4, 2021

@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 March 4, 2021

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
Community Champion
March 4, 2021

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

2021-03-05 at 10.47 am.png

Or the new style editor like this:

2021-03-05 at 10.48 am.png

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

Like Michael Pryor likes this
Bailey Brown March 4, 2021

@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
Community Champion
March 4, 2021

@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

Like Michael Pryor likes this
Bailey Brown March 4, 2021

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

Bailey Brown March 4, 2021

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

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events