I have a sheet with multiple rows. For each row I do a postgres query and I want to store the response in the sheet ‘is_client’ column for the corresponding row.
I can’t figure a way to use the “update” in google sheets:
Example data:
Hi @tthias, the Update operation of the Google Sheets node would try to find the correct row using a key column with a unique value. So assuming your Submission ID column values are unique identifiers, you could use a Set node after your Postgres node to add this column to your items coming from PostgreSQL.
You can then specify the Key in your Google Sheets node as Submission ID for n8n to find the correct row for each update. Just keep in mind that your sheet would also need a count column to write the respective values into.