I was working on a small tool to:

Drugs => Download pdfs locally => Chunk the doc and send it over Pinecone => delete pdfs and iterate same for the next drug in the list

Here is the link for my git, I have a jupyter notebook which describes the most but there might be part missing such as storing in metadata. see if you find it useful: https://github.com/btarun13/Search_Vector_DB_RAG/blob/main/cleaned_notebook.ipynb