Help Formatting a Google Sheets Array into a Markdown Table for a ClickUp Task Description

[Fabio_Moura]

Hello Make community,

I am building a scenario to integrate service order data from Google Sheets into ClickUp.

My goal is to create a new ClickUp task when a customer submits an order. The scenario is triggered by a new row in my “Orders” sheet (one row per order) and then uses the “Search Rows” module to find all the related line items from my “Order Items” sheet (which can have several rows per order).

This part works, and I’m successfully using the Array Aggregator to gather all the found items into a single array.

My problem is formatting this array into the ClickUp task description. When I map the array output directly to the task’s content field, the information appears as a raw, unformatted string, like this:

{"1":"Coroa em PMMA Fresada provisória CADCAM","2":11.12,"3":2}, {"1":"Coroa em Zircônia sobre implante CADCAM","2":13.14,"3":1}, ...

I want to organize this information into a clean Markdown table, with a separate row for each item. I have tried several things, like using the map() function, but nothing has worked so far.

Could anyone help me find the correct syntax or approach to transform this array of objects into a formatted Markdown table within the ClickUp module?

Thank you in advance!

[MaxW]

Hi there,

What is your exact preferred output?

Can you show an Clickup example of how it should look, and what data structure you are wanting to send to ClickUp.

[Fabio_Moura]

Hello MaxW,

Thank you for the follow-up question! This is very helpful. Here are the details:

1. The Input Data Structure

The data I need to format is the array coming directly from my Array Aggregator module. It is an array of objects, and it looks like this:

[
{
“1”: “Coroa em PMMA Fresada provisória CADCAM”,
“2”: “11.12”,
“3”: 2
},
{
“1”: “Coroa em Zircônia sobre implante CADCAM”,
“2”: “13.14”,
“3”: 1
},
{
“1”: “Modelo Impresso Parcial”,
“2”: null,
“3”: 1
}
]

2. The Desired Output (ClickUp Task Description)

My goal is to transform the array above into a clean, formatted Markdown table inside the ClickUp task’s description field.

Here is an example of how the final task description should look:

Services Requested:

| Serviço | Dente(s) | Quantidade | |—|—|—| | Coroa em PMMA Fresada provisória CADCAM | 11.12 | 2 | | Coroa em Zircônia sobre implante CADCAM | 13.14 | 1 | | Modelo Impresso Parcial | - | 1 |

So, my question is: What is the best formula or method in Make.com to map the input array from Step 1 into the formatted Markdown table shown in Step 2?

Thanks again for your help!

[MaxW]

You could use a text aggregator and structure it as Markdown:

Module Settings:

Then in the module that passes the data, add the table header:

Let me know if this helps.

[Fabio_Moura]

Hi MaxW,

That worked perfectly! Thank you so much for your help.

Best regards,

[MaxW]

Awesome! so glad I was able to help