This n8n workflow automates the process of synchronizing files from Google Drive with an OpenAI-based vector store. Its primary goal is to ensure that new, updated, or deleted files in Google Drive are accurately reflected in the vector database, maintaining consistency for AI-powered search and retrieval systems. The workflow is scheduled to run periodically or triggered manually for testing.

Key steps include.

1. Trigger: The workflow can be initiated manually or via a schedule.

2. Listing Files: It retrieves the current list of files from a specified Google Drive folder.

3. Listing Vector Files: It requests the existing vector store files from OpenAI.

4. Comparison: Files from Google Drive are compared with the vector store to determine which files are new, updated, or need deletion.

5. Conditional Logic: Based on the comparison, files are flagged for creation, update, or deletion.

6. Synchronization: The workflow uploads new or modified files to the vector store and deletes outdated files to keep the storage synchronized.

7. Looping and batching ensure efficient processing of large sets of files.

This automation is particularly useful for content management, knowledge base maintenance, or AI training datasets where keeping data synchronized across storage and AI models is critical.

Node Count	>20 Nodes
Nodes Used	@n8n/n8n-nodes-langchain.openAi, aggregate, compareDatasets, filter, googleDrive, httpRequest, if, manualTrigger, merge, noOp, scheduleTrigger, set, splitInBatches, splitOut, switch