Help with Add to Sheet function
Hey I am trying to use add to sheet function in Agent step, but I get this error (below). I run out of ideas what should I fix at this point.
{
"time": 1753538409662,
"type": "debug",
"payload": {
"ref": {
"type": "integration-tool",
"nodeID": "6884d725cd9844c8e0c3442f",
"diagramID": "6884cfab462ee20007b0815e",
"integrationToolName": "google_sheets_append_spreadsheet"
},
"level": "warn",
"message": ""google_sheets_append_spreadsheet" failed",
"context": "Integration tool",
"metadata": {
"error": {
"name": "Error",
"message": "Validation failed for google_sheets_append_spreadsheet: values is expected array, received string"
},
"latency": 6,
"inputVars": {
"spreadsheetURL": "https://docs.google.com/spreadsheets/d/18CKcdRL0vg0Xms6840Sv5NLrJufsBWciAU8qBoFmSs8/edit?usp=drive_web",
"range": "search",
"values": "trener personalnyKraków"
}
}
}
}
2 Replies
That error just means the values field is arriving at the Google-Sheets integration as a plain string, but the action expects an array (one array = one row).
How to fix
1. Wrap the value(s) you want to write in square brackets.
• One cell →
[ "{{searchTerm}}" ]
• Several cells (one row) → [ "{{jobTitle}}", "{{city}}" ]
2. Put that array in the Values input of the Add to Sheet step.
– If you prefer to build it beforehand, drop a Code/Function step right before the integration:
Then map Values → sheetRow in the integration step.
Remember
• The integration validates the type, so a bare string like "trener personalnyKraków" will fail.
• values must be an array (or array-of-arrays if you’re appending multiple rows).
• The rest of your inputs (Spreadsheet URL & Range) can stay the same.
Once values is passed as an array, the "Validation failed – values is expected array" message disappears and the row will be appended to your sheet.
Docs: https://docs.voiceflow.comok, i created this set step (screenshot). This step creates new variable where my both current variables are combined into 1 squared bracket experession. Then I changed Values in google sheet funcitno into this variable but still i have the same error
