Google sheet integration - values section with variables only sends strings and not array
Ive tested this multiple times yesterday with no luck. is there a way to get specified variables place in the values section (not the llm box either)
Currently anything i put in the values section gets sent out as a string which google sheets wont accept and throws an error
But when i have AI just map it by itself in the main llm box of the google sheets tool it sends it as an array with no issues
4 Replies
You can use a Set or JS step to turn a string ['hi'] into an array.
However, if you are using an API, it needs the array in a string.
Hi thanks for your reply,
I’m using the required variable on the exit condition to get them. Is that different from Set?
Wait, are you using the API step to send this to google sheets?
I’m using the sheets tool inside the agent window
Ive tried also tried it as its own send block with a bunch of different input for the default values section but each time it sends it as a string. But when i just put it in for AI to interpret it sends it correctly as an array