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

Add custom fields and synchronize data to Google Spreadsheet

Gabor Balatoni Jun 03, 2017

Hello, Can anyone help me please? Is Trello this much flexible, can this be done?

I would like to add custom fields to various cards in different trello boards (namely, number of trucks) and syncronize that info in real time to a google spreadsheet file.

3 answers

0 votes
Kaylin Murray Jun 03, 2017

Hey Gabor, 

I'm not 100% sure if this will work but I found this on Zapier and that might work for you! 

Hopefully, that is helpful!! 


0 votes
Francis Peixoto Community Leader Jun 04, 2017 • edited
The challenge is that custom fields aren't exposed to the API, which is what platforms like IFTTT and Zapier would use. 
To sync Trello with Google Sheets and transport custom fields, you would probably need to have sheets read a JSON stream. 
This gives an example of how Sheets can read a JSON stream. You could adapt the code to read the stream from your board :
Gabor Balatoni Jun 04, 2017

Hi, thanks, but this is "chinese" for me. Anyone who can implement this solution for us?

Francis Peixoto Jun 06, 2017

Hi, I can't make a specific recommendation, but most spreadsheet systems can interact with very minimal development/integration with JSON feeds. most developers who work with modern frameworks would be able to effort this out for a minimal cost.

0 votes
Borislav Bogdanov Jun 12, 2018

Hello Gabor,

Did you find a solution?
I want to export a board in google sheets where every custom numeric field is a different column. Edit the numbers and bring them back to trello.

Is there a way to do this?

I tried blockspring but it is not supporting custom fields.

I tried to automate this with butler again it was not supporting what I need.

I want to sum up several custom fields and write the result into a different custom field.

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published in Trello

My e-portfolio: using Trello to keep track of skills and experiences

The days are flying by so fast, I can’t seem to slow things down no matter how hard I try. My memory is great; however, I can’t seem to remember vivid details or even highlights from each year of my ...

7,718 views 15 25
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