Add custom fields and synchronize data to Google Spreadsheet

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.

2 answers

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 vote
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 : https://medium.com/@paulgambill/how-to-import-json-data-into-google-spreadsheets-in-less-than-5-minutes-a3fede1a014a
 
 

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

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.

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Bridget Sauer
Published Feb 02, 2018 in Trello

Atlassian User Groups: Trello edition

You’re invited to our first ever Trello User Groups   Good news for current and aspiring Trello enthusiasts! We’re launching Trello User Groups so that you can network, share ideas, solve ...

1,741 views 14 14
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you