Sync OpenAI vector stores from Google Sheets with Drive and AWS S3

by Salman Mehboob ✓ · 20 views · created 2026-06-01 · Document Extraction, AI RAG

What this workflow does

This AI workflow has 19 nodes and runs on a schedule (every 2 minutes). Along the way it connects Google Sheets, Google Drive, OpenAI and AWS S3. It also calls api.openai.com over HTTP.

How it runs

Trigger: On a schedule (every 2 minutes).

1. Get Row(s) From Sheet (Google Sheets): uses Google Sheets
2. If: checks a condition and branches into true / false
3. Delete File From Vector Store (HTTP Request): calls an HTTP API (DELETE)
4. Filter: keeps only the items that match a condition
5. Mark Row as Deleted (Google Sheets): update
6. Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
7. Route by File Source (Switch): routes items into 3 branches
8. Download from Google Drive (Google Drive): download
9. Download from S (AWS S3): uses AWS S3
10. Download via HTTP (HTTP Request): calls an HTTP API

…plus 7 more steps. See the full node list below.

Services it uses

Google SheetsGoogle DriveOpenAIAWS S3

HTTP calls to: api.openai.com

Before you upgrade to n8n 3.0

Nodes used (12)

• Schedule Triggern8n-nodes-base.scheduleTrigger
• Google Sheetsn8n-nodes-base.googleSheets
• Ifn8n-nodes-base.if
• HTTP Requestn8n-nodes-base.httpRequest
• Filtern8n-nodes-base.filter
• No Operation, do nothingn8n-nodes-base.noOp
• Switchn8n-nodes-base.switch
• Google Driven8n-nodes-base.googleDrive
• OpenAI@n8n/n8n-nodes-langchain.openAi
• AWS S3n8n-nodes-base.awsS3
• Loop Over Items (Split in Batches)n8n-nodes-base.splitInBatches
• Waitn8n-nodes-base.wait

From the author

Quick overview This workflow runs every two minutes to sync a Google Sheets file queue with an OpenAI Vector Store by deleting outdated entries, downloading new files from Google Drive, AWS S3, or a URL, uploading them to OpenAI, and updating each row’s…

View the original on n8n.io → Check your own copy