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

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,456,779
Community Members
 
Community Events
176
Community Groups

Trello card to Google Sheet - does this exist?

Hi,

Many thanks in advance for any info...probably easier for me to walk through what I'm trying to achieve.

I want to centralise time spent on a card - request comes in, card moves to the 'in flight' stack, it's finished and then moved to the complete stack. In that card, I'd like to add some details - client, project, task (could be name of card), date, time spent. This then gets updated to a master spreadsheet that controls time tracking / billing etc.

Is this possible? Alternatively, is there a more elegant solution that doesn't require either an additional platform or a major change to that flow?

Cheers

J

3 answers

0 votes
Brittany Joiner Community Leader Mar 03, 2022

@John Barnes welcome to the community!

I see other answers about the time in list piece, but if you're curious about getting data from Trello into a Google Sheet, you can do that with Zapier or PixieBrix.

Thanks Brittany. There may be an issue with the approach I've just tested which may also apply to Zapier / PixieBrix.

When I add custom fields to track 'hours spent', they are not pulled through to Google Sheets via Coupler.io.

My assumption at this point is that these third party connectors only recognised the default databased schema and not any custom / power ups.

Do you know if that's the case?

So i think you can recognize custom fields with Zapier: 

image.png

 

(theme is a custom text field i have on a board, and it looks like zapier is able to pull it in and send to a sheet)

@John Barnes 

If your card progression is in one direction, you can use this variable {cardminutesinpreviouslist} to capture the value when card is moved to “complete”. Do note that if a card re-enters “in flight” then into complete that variable will be for the time spent following the re-entry back into in flight. Should you need the total time spent then you need to look back at all the actions and compute the time spent. For this you will need to use the Trello api. 
To write Google sheet from Trello you can call an endpoint via http request. 

I've tried the connection through Coupler, it works great. However, I'm tracking time via a custom field which Coupler seems to not recognise.

0 votes

Hi @John Barnes 

I wrote up the current state of Time Tracking options for Trello here https://www.bluecatreports.com/trello-reporting/time-tracking/

For data like client, project, task (could be name of card), date, time spent you could look to add custom fields to your cards. They're great :)

On the simple end of the spectrum a tool like Time in List can help with some basic tracking and includes an export option. 

Hope that helps :)

Robin

Hi Robin,

Many thanks for taking the time to respond. Some of the solutions look interesting but I don't think they are quite what I'm looking for.

I'll keep looking and see if there is a simple approach integrating cards with sheets.

Thanks again.

John

Like Robin Warren likes this

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events