nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Trello card to Google Sheet - does this exist?

John Barnes_lbh0vv

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

Accepted answers

All comments

Robin Warren _Blue Cat Reports_

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

John Barnes_lbh0vv

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

milynnus

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

Brittany Joiner

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

John Barnes_lbh0vv

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?

John Barnes_lbh0vv

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.

Brittany Joiner

So i think you can recognize custom fields with Zapier:

(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)

Sam Dixon_f5cu3w

Yes! Unito's 2-way Google Sheets Trello integration is great! it’s much easier than the alternatives

Chandrashekhar Pandey

Hi JB,

If you are looking to integrate Trello with google sheets without using any additional platforms then I would suggest you to use apps script to achieve this.

This will enable you to have 2 way sync between Trello and google sheets.

Along with this it is highly affordable and completely secured since no third party is involved.

For more details you can go through this video https://www.youtube.com/watch?v=ZJuXMA29y6I

Please let me know if it helps.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Unanswered
Groups
Help

Find more posts tagged with

trello