IMHO, you may be over-engineering things.
Ensure you setup prompts to ensure the AI model understands the dataset it’ll get from pinecone.
Ensure you use the same embedding model you used to upsert pinecone content for the query embedding as well. That way, you don’t have to specifically prompt the model for sorting. You can use similarity search for this instance
Also use a a framework like langraph to get better results and set up nodes.
This is the approach I used for a similar project.