Hi everyone, I’m facing an issue when using Google Sheets to input values into Pinecone. I’m using an n8n workflow to execute the process. With the PineconeVector node, I’m able to insert values into the database, but I haven’t been able to update existing values using that option.
Is there a way to handle this? When I use the API directly, the upsert operation works as expected, but I couldn’t figure out how to configure that using the built-in PineconeVector node. You can see my screenshots below.
Hello @chathuranga and welcome to the Pinecone community.
Have you asked in the n8n community? I’m not a n8n user but a quick search found me this year-old post, which states “At time of writing, n8n’s Vectorstore nodes do not support upserts” Perhaps things have changed since then and it’s now supported. Otherwise, the post shows how to work around the issue using custom code. In any case, this should be addressed by n8n, so you are probably better off discussing it on their forums.
Yes, @milen. I use a different approach for Excel updates with the PineconeVector node. I use the Excel unique ID to find the corresponding vector DB ID through an API search. After that, I delete the record using an API call and then insert the data again. I know it’s a bit lengthy, but that’s the method I have to use.