I know this is novice question, but trust me first i tried it myself and it's been almost 2 hours now, for some reason I am not able to insert output from chat model in JSON format to a google sheet in each column.
For e,g.Google Sheet has 2 columns, "Title", "Link". From chat model I am getting JSON output.
[{
"output": [
{"Name": "XYZ",
"Link":"xyz[dot]com
},
{"Name": "ABC",
"Link":"abc[dot]com
},]
}]
I want to take first name and link from this JSON and insert it to google sheet and then another record.
currently i connect my LLM agent directly to Google sheets which only insert 1st record in respective fields of google sheet.
Somebody please help. Tried using loop node but i might be using wrongly, did not help much.