Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

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

Why is my google spreadsheet not uploading to trello?

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

1 vote
Answer accepted
Iain Dooley Community Leader Mar 04, 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?

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 Leader Mar 04, 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

@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 Leader Mar 04, 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

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

@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
Community showcase
Posted in Trello

Taco Tuesday: Your favorite Trello blog takeaway

Hello friends! From the community that brought you Welcome Wednesday, Throwback Thursday and Friday Fun, welcome to Taco Tuesday, a weekly discussion about all things Trello. The best part? One Tac...

374 views 14 12
Join discussion

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