I've never done this before with chatgpt either! Here's the docs for the Pinecone developer MCP you're looking for. I believe the Zapier integration is using these. Curious how that setup ends up working of if going direct is easier.
https://docs.pinecone.io/guides/operations/mcp-server