Array Aggregator to Google Sheet Bulk add raws

[Stanislas_Berteloot]

Hello
I have been strugguling for hours on issue:
I have an aggreagator whose output has 2 fields: Date Phrase and Date and I need them to populate a google sheet.
My issue is that I only see one field: the Phrase, in the google sheet

Here is the output of the aggregator

[
{
“IMTKEY”: “Marie-Claire ne vousOctobre 1954”,
“array”: [
{
“values”: [
“Marie-Claire ne vous”,
“Octobre 1954”
]
}
]
},
{
“IMTKEY”: “fenêtre, avec sesOctobre 1954”,
“array”: [
{
“values”: [
“fenêtre, avec ses”,
“Octobre 1954”
]
}
]
},
{
“IMTKEY”: “couleurs toujours recommencéesOctobre 1954”,
“array”: [
{
“values”: [
“couleurs toujours recommencées”,
“Octobre 1954”
]
}
]
},
{
“IMTKEY”: “sauterelles en bikini[No Date Found]”,
“array”: [
{
“values”: [
“sauterelles en bikini”,
“[No Date Found]”
]
}
]
},
{
“IMTKEY”: “tortue du jardin[No Date Found]”,
“array”: [
{
“values”: [
“tortue du jardin”,
“[No Date Found]”
]
}
]
},
{
“IMTKEY”: “rentrée dans l’ordreOctobre 1954”,
“array”: [
{
“values”: [
“rentrée dans l’ordre”,
“Octobre 1954”
]
}
]
},
{
“IMTKEY”: “rentrée des récoltesOctobre 1954”,
“array”: [
{
“values”: [
“rentrée des récoltes”,
“Octobre 1954”
]
}
]
},
{
“IMTKEY”: “Hier cigale, aujourd’huiOctobre 1954”,
“array”: [
{
“values”: [
“Hier cigale, aujourd’hui”,
“Octobre 1954”
]
}
]
},
{
“IMTKEY”: “femme : vous. HierOctobre 1954”,
“array”: [
{
“values”: [
“femme : vous. Hier”,
“Octobre 1954”
]
}
]
}
]

[DigitalCowboy]

Your Json doesn’t have multiple fileds, it just has one field which is combining the phrase and the date. The Json needs to be more like this.

{
“Phrases”: {
“Phrase”: [
{
“Text”: “femme vous. Hier”,
“Date”: “Octobre 1954”
},
{
“Text”: “rentrée des récoltes”,
“Date”: “Octobre 1954”
}
]
}
}

[Stanislas_Berteloot]

@DigitalCowboy

{
“Phrases”: {
“Phrase”: [
{
“Text”: “femme vous. Hier”,
“Date”: “Octobre 1954”
},
{
“Text”: “rentrée des récoltes”,
“Date”: “Octobre 1954”
}
]
}
}

Thanks,

I will try it soon

[Stanislas_Berteloot]

unfortunately the issue remains

I can see the 2 values up to the google sheet module but once in the module the only available module available is the Flow Control which is not showing me these value.

I am missing a module?

[Stanislas_Berteloot]

Hello everyone, any idea why Flow control is the only module available after ChatGPT?