I can't append multiple rows in google sheets

[Alexandre_Vanholder]

Hello everyone, I’m trying to build an automated process that would help me find a job as an assistant to a manager of some tourism destination in Europe.

The first step was to create a google sheets with the following columns: country, city and company, etc… (those are the important variables for now)

I made an AI Agent to give me the 10 best companies based on city and with the google sheet as a tool, so it wouldn’t duplicate the answers.

I then use an information extractor to classify the Agent’s input into parameters and the issue now is that I can only append one row to the google sheets.

My output from the information extractor looks like this so far:

{
“Country”: “Germany”,
“City”: “Berlin”,
“Employer”: “VisitBerlin”
},
{
“Country”: “France”,
“City”: “Paris”,
“Employer”: “Atout France”
},
{
“Country”: “Austria”,
“City”: “Vienna”,
“Employer”: “Vienna Tourist Board”
},
etc…

Thank you for your help in advance

[Sajid_Rasheed]

Can you provide Pics - Screeshots

[Alexandre_Vanholder]

of course, here is the outline of the model

and here is the output of the information extractor and input i have in the excel node

[Parintele_Damaskin]

Hey!

I think you have to use “upsert”.

[Sajid_Rasheed]

Click Shema and then Set Values

[Sajid_Rasheed]

when you execute what error comes , send pic of that too?

[Alexandre_Vanholder]

@Parintele_Damaskin

e “upsert

I fixed the issue by adding a code node and asking chatgpt to transform the output into 10 outputs

Thank you for your help everyone

[jabbson]

Hey @Alexandre_Vanholder hope all is good.

You didn’t have to use Code node. The most straighforward solution would be to use a split out node, which is exactly for that - taking 1 input of multiple items and creating multiple inputs of 1 item.

See above, we have one array of three items coming out of the set node, and then we split it by the output field, which results in having three separate items, which you could then feed into the sheet node to populate rows.