Hello @visions2060 and welcome to the Pinecone community forum.
I’m afraid I cannot help much with the actual issue, as it seems more related to n8n than to Pinecone. However, I was recently exchanging messages with another user who also uses n8n, and according to this post, inserting values into the database works fine from n8n.
@chathuranga, given that you know more about n8n than I do, would you be willing to help a fellow community member?