Output from Iterator is ok, but not showing in google sheets

I’m trying to get information from an array to multiple rows on google sheet with no success. in the spreadsheet I got only the first collection duplicated.



Iterator Output
[
{
“nome”: “PATRICIA FERNANDA RIZZI”,
“qual”: “49-Sócio-Administrador”,
IMTINDEX”: 1,
IMTLENGTH”: 2
},
{
“nome”: “THIAGO BERNARDES DA SILVA”,
“qual”: “49-Sócio-Administrador”,
IMTINDEX”: 2,
IMTLENGTH”: 2
}
]

Goggle Sheets Input
1st Operation
[
{
“from”: “team”,
“mode”: “select”,
“values”: {
“4”: “PATRICIA FERNANDA RIZZI”,
“8”: “49-Sócio-Administrador”
},
“sheetId”: “Sócios”,
“sharedDrive”: “0AC7CemX2fHVKUk9PVA”,
“spreadsheetId”: “/17Heuh9jqlCjyCe6NEsSk9LnBnFFT9rw0/1WnDMjAGcpqLSU7ntktyHrN3M4H7hMTfY/1vh-LCNLZ9r7_hEvywbWGk8IBuNmk5sImaXtv691uMO0”,
“includesHeaders”: true,
“insertDataOption”: “INSERT_ROWS”,
“valueInputOption”: “USER_ENTERED”,
“insertUnformatted”: false,
“useDomainAdminAccess”: false
}
]

2nd Operation
[
{
“from”: “team”,
“mode”: “select”,
“values”: {
“4”: “PATRICIA FERNANDA RIZZI”,
“8”: “49-Sócio-Administrador”
},
“sheetId”: “Sócios”,
“sharedDrive”: “0AC7CemX2fHVKUk9PVA”,
“spreadsheetId”: “/17Heuh9jqlCjyCe6NEsSk9LnBnFFT9rw0/1WnDMjAGcpqLSU7ntktyHrN3M4H7hMTfY/1vh-LCNLZ9r7_hEvywbWGk8IBuNmk5sImaXtv691uMO0”,
“includesHeaders”: true,
“insertDataOption”: “INSERT_ROWS”,
“valueInputOption”: “USER_ENTERED”,
“insertUnformatted”: false,
“useDomainAdminAccess”: false

Hi there,

I don’t see where you’ve mapped “Nome” from Iterator, but it’s mapped from another module.

You get both names when you map from Iterator.

Thanks! :slight_smile:

2 Likes

You are totally right, I made this silly mistake. I was not mapping the iterator module.

Thanks a lot

1 Like

I am glad to help! :slight_smile:

3 Likes