I decided to recreate / add a new Google sheets node instead of using a copied one from another workflow. I think it is identical as the one I had, but now it finds the key:
Hi @fxholl, I am sorry to hear you had trouble with the Google Sheets node. It has been updated since n8n version 0.198.2 which you have in use, so hopefully this should no longer be problem
@MutedJam I’m using n8n 0.205.0 & it still doesn’t have a place to place key field unfortunately. I’ve reverted to using the old node @fxholl provided above
Is there a way it could be added under the “Append & Update” instead of just “Update” to minimize on the creation of unnecessary nodes/workflows - Thanks
Hey @KevinK, have you removed the old Google Sheets node from your workflow and added a new one? n8n wouldn’t change your existing workflow nodes, so you’ll need to add a fresh one to see the changes.
Yes I tried using the new Google Sheet node but it doesn’t have the “Keys” function that’s why I’ve reverted to typeversion:2 (old GS node version) I really need an identifier column seeing as I’m getting in values from a MySQL node
Could I be getting something wrong?
Here’s the New Node
@maja I think I found your problem.
I just built a new workflow and a new sheet and again I saw what you see - duplicates !!
I went to Google Sheets - selected all columns and made them all Text - no numbers nothing.
I am passing Strings from my set node and workflow and it seems to do a datatype match.
Hi @lightcom, welcome to the community and please accept my sincere apologies for the trouble this causes. I was able to reproduce the problem and have added it to our engineering backlog for a fix.