The context of the scenario will be to capture the hours tracked in clickup for tasks in a folder and then place these hours in a spreadsheet. This is already working, but I need to divide this by folder (which are separate clients), that is, for each folder I need to identify the hours of that specific folder and then insert them in a specific line in the sheets based on the name of the folder (which will be the same in the sheets)
Hey there,
could you please share screenshots of your scenario and what issues are you currently facing?
As you explained it, this is entirely doable. We have implemented similar flows in the past, but the final output was back in ClickUp tasks instead of an external tool.
Thanks for the feedback Sloyan.
Currently my scenario looks like this:
Obrigado pelo retorno Sloyan.
Atualmente meu cenário está assim:
The steps are:
1 - I capture all the folders (clients)
2 - I capture the lists of each folder (client)
3 - I capture the tasks and their tracked hours
4 - Add up the total hours
5 - I add them to the spreadsheet
My problem is that I can’t automatically separate the hours by folder (client), it captures all the hours and not individually by client.
What I need is to separate by folder (client) their respective tasks and time tracked and then add them to the correct line in the spreadsheet.
Translated with DeepL.com (free version)
Os passos são:
1 - Capturo todas as pastas (clientes)
2 - Capturo as listas de cada pasta (cliente)
3 - Capturo as tasks e suas horas rastreadas
4 - Faço a soma das horas total
5 - Adiciono na planilha
O meu problema é que não consigo fazer de forma automatica a separação das horas por pasta(cliente), ele captura todas as horas e não de forma individual por cliente.
O que eu preciso é separar por pasta(cliente) as suas respectivas tasks e tempo rastreado e com isso, adicionar na linha correta dentro da planilha
So don’t aggregate on the list all folders module, aggregate on the list all lists. Then you will have the values per folder.