Generate columns in Google Docs from multiple bundles

Questions
, ,
1

:bullseye: What is your goal?

Google docs or excel sheet with rows for every bundle in the scenario

:thinking: What is the problem & what have you tried?

I am automating a quotation system.

Trigger: A Parent Task in ClickUp represents the “Quote”.

Source Data: The Subtasks under that parent task represent the “Products” (Items). Each subtask has custom fields for Width, Height, Price, etc.

I need to list all these subtasks and generate ONE single Google Doc containing a dynamic table with all the products listed as rows.

:clipboard: Error messages or input/output bundles

I can successfully list the subtasks using the ClickUp module, but they come out as separate Bundles. When I try to map them to the Google Docs “Create a Document from a Template” module, I am struggling to aggregate them correctly so the Google Doc recognizes them as a list/loop

I can’t seem to get the Google Docs module to accept the array as a single object to iterate over. It either asks for individual fields (creating 1 row only) or runs multiple times creating multiple documents.

Output of first array:
[
{
“array”: [
{
“id”: “86ae4hvqc”,
“name”: “Vano 2”,
“custom_fields”: {
“Ejecutivo Comercial”: [
{
“id”: 108609173,
“username”: “Cristobal Varas”,
“email”: “cristobalv1324@gmail.com”,
“color”: “”,
“initials”: “CV”,
“profilePicture”: null
}
],
“Tipo Vivienda”: 1,
“Tipo de persona”: 0,
“Precio Neto”: “50000”,
“Alto”: “4”,
“Ancho”: “5”,
“Cantidad Aperturas”: “1”,
“Subtipo Plegable”: 1,
“Tipo L”: “5”,
“Region”: 0
}
},
{
“id”: “86ae4hvn7”,
“name”: “Vano 1”,
“custom_fields”: {
“Ejecutivo Comercial”: [
{
“id”: 108609173,
“username”: “Cristobal Varas”,
“email”: “cristobalv1324@gmail.com”,
“color”: “”,
“initials”: “CV”,
“profilePicture”: null
}
],
“Tipo Vivienda”: 0,
“Tipo de persona”: 0,
“Precio Neto”: “40000”,
“Alto”: “5”,
“Ancho”: “13”,
“Cantidad Aperturas”: “9”,
“Subtipo Plegable”: 0,
“Tipo L”: “3”,
“Region”: 0
}
}
],
“IMTAGGLENGTH”: 2
}
]

Output of second array:
[
{
“array”: [
{
“id”: “86ae4hwc5”,
“name”: “Calado de muro”,
“custom_fields”: {
“Precio Neto”: “20000”,
“Alto”: “2”,
“Ancho”: “3”,
“Cantidad Aperturas”: “4”,
“Subtipo Plegable”: 4,
“Tipo L”: “5”
}
}
],
“IMTAGGLENGTH”: 1
}
]

:camera_with_flash: Screenshots (scenario flow, module settings, errors)

imagen_2025-12-26_172314046.png
imagen_2025-12-26_172314046.png1570Ă—233 42.9 KB

3

Hey Jose Luis!

Quick question, it seems that you might have nested subtasks on each ClickUp task, would it be possible to get a sample screenshot of the structure you are using on ClickUp?

Second question, is this the only way you can do it? I think you could probably save a lot of time if you use a form as a trigger instead, just putting it out there in case is a possibility

Third, have you considered using a text aggregator instead of an array aggregator? It might help you create text from an array.