Google Sheets : Update or add data in a specific cell

Hey,

I have data in a google sheets (column A to W) : name, firstname, phone…

I want to create person in Pipedrive with those data ; i get an URLid for each person created

Then i want to add this URLid from Pipedrive into google sheet file in the column X

My idea was to paste data in Range : Feuille1!X:X

That does not sem to work or data are added at the end of sheets : last raw of my list.

What am i doing wrong ?

I did not manage to use “Update” fonction in the node neither.

Thanks for your help !

Damien

PS:
n8n Version = 0.158.0

1 Like

Hi @damienOp, the Update operation would require a key to identify which row to update. Both the Google sheet to update and the item in n8n would need to have same field names/column headers.

Let’s imagine we have a sheet like this:
image

No let’s assume we want to replace William with James in this sheet. We would need an n8n item with two fields:

  • My ID with a value of 894
  • Name with a value of James

Now the Sheet can be updated as expected by putting our column name My ID in the Key field of the Google Sheets node:

This is the result:
image

Is that what you had in mind?

1 Like

It doesn’t work. I followed all the steps and executes them successfully, but nothing updates in Google Sheets. Create and append work perfectly though.