Need Help Configuring Upsert with PineconeVector in n8n

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.