Google Sheets cell update

Hi @lfilippi, when updating a sheet, the Google Sheet node would first try and find the correct row using the value specified in the Key column. This is typically an ID of some sort or another unique value (such as an email). It would then update each field using the incoming data.

So assuming you have a Google Sheet like this:

image

And your n8n data looks like so:

An Update operation would need to look like this:

This would be the result, with only the row with the correct ID being updated using the data of the incoming n8n item:

image

2 Likes