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