Upload and index files in Pinecone with Google Drive and OpenAI
Go to Workflow
isaWOW
Description
Quick overview
This workflow accepts file uploads via a webhook, archives the originals in Google Drive, then chunks and embeds the content with OpenAI before indexing it into a Pinecone vector database for retrieval.
How it works
Receives a file upload via a POST webhook request as binary multipart form data.
Detects the file name, size, and extension and calculates dynamic chunk size, chunk overlap, and OpenAI embedding batch size.
Uploads the original file to a specified Google Drive folder to keep a source copy.
Downloads the same file back from Google Drive and prepares it for document loading.
Splits the document into pages and chunks (tagged with the source filename), generates OpenAI embeddings, and inserts the vectors into the specified Pinecone index.
Responds to the webhook with the workflow output once indexing completes.
Setup
Add credentials for Google Drive, OpenAI, and Pinecone.
Replace YOUR_GOOGLE_DRIVE_FOLDER_ID with the destination Drive folder ID and YOUR_PINECONE_INDEX_NAME with your Pinecone index name.
Activate the workflow, copy the webhook URL, and configure your client to POST a file using the file binary field (multipart/form-data).
This workflow was created by isaWOW and shared publicly on the n8n community template library. n8nFind indexes it for discovery — the workflow remains the property of its original creator.