Hello. I am new to n8n world, trying to get some things done.
I want to update some information into a google sheet.
The problem I am founding is the Update command just updates some of the rows in my sheet because some of them we’ll have the same information as others (it’s searching in another sheet for a specific code for specifics of a product we are selling)
This is the last part of the workflow where I am having trouble with:
Sadly we treat the ID as being a unique identifier when doing the search so it will only match the first item, Without using unique IDs I am not sure what else could be done on this one sadly. Do you have a field that is unique?
That makes things tricky, I can’t think of a way we could do it without overwriting all IDs with the same data. Any attempt to change the node to support this though would need to go through as a feature request for a future release.
Does it need to update the sheet or is it adding to the sheet? We could just write the data including the IDs that may solve the problem or maybe Create or Update will do the job.
It could be something that works just when a new row is added?
If it just looks for the information on that specfic row it must update the other columns right?
Sadly we don’t have anything that will trigger when a new row is added with Google Sheets, It is a bit of a tricky one this.
Does it need to be a Google Sheet? There are applications out there that work like Google Sheets but they assign an ID to each row as well which we can work with.
