Sync WooCommerce products, blog, and Google Drive files to Pinecone with OpenAI

by Stanislaw Chalupczak ✓ · 3 views · created 2026-10-07 · Document Extraction, AI RAG

What this workflow does

This AI workflow has 135 nodes and runs manually, when you click “Execute workflow” (plus 7 other triggers). Along the way it connects WooCommerce, Embeddings OpenAI, Pinecone Vector Store and Google Drive and 1 more.

How it runs

Trigger: Manually, when you click “Execute workflow” (plus 7 other triggers).

1. Settings (Edit Fields (Set)): sets or maps fields
2. Drive: Reduce to single run (Code): runs custom JavaScript code
3. Preflight: Validate configuration (Code): runs custom JavaScript code
4. Route by trigger (Switch): routes items into branches
5. Products: Get all products (WooCommerce): uses WooCommerce
6. Webhook: Verify signature (Code): runs custom JavaScript code
7. Blog: Fetch static pages (HTTP Request): calls an HTTP API
8. Drive: Find documents (Google Drive): uses Google Drive
9. Products: Get dedup table entries (Data table): uses Data table
10. Webhook: Signature valid? (If): checks a condition and branches into true / false

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

Services it uses

WooCommerceEmbeddings OpenAIPinecone Vector StoreGoogle DriveGmail

Before you upgrade to n8n 3.0

Nodes used (20)

• Manual Triggern8n-nodes-base.manualTrigger
• Loop Over Items (Split in Batches)n8n-nodes-base.splitInBatches
• Ifn8n-nodes-base.if
• HTTP Requestn8n-nodes-base.httpRequest
• Coden8n-nodes-base.code
• Schedule Triggern8n-nodes-base.scheduleTrigger
• WooCommercen8n-nodes-base.wooCommerce
• Data tablen8n-nodes-base.dataTable
• Embeddings OpenAI@n8n/n8n-nodes-langchain.embeddingsOpenAi
• Recursive Character Text Splitter@n8n/n8n-nodes-langchain.textSplitterRecursiveCharacterTextSplitter
• Default Data Loader@n8n/n8n-nodes-langchain.documentDefaultDataLoader
• Pinecone Vector Store@n8n/n8n-nodes-langchain.vectorStorePinecone
• Webhookn8n-nodes-base.webhook
• No Operation, do nothingn8n-nodes-base.noOp
• Google Driven8n-nodes-base.googleDrive
• Extract from Filen8n-nodes-base.extractFromFile
• Google Drive Triggern8n-nodes-base.googleDriveTrigger
• Gmailn8n-nodes-base.gmail
• Edit Fields (Set)n8n-nodes-base.set
• Switchn8n-nodes-base.switch

From the author

Quick overview This workflow keeps a Pinecone knowledge base in sync with WooCommerce products and reviews, WordPress pages/posts, and files from a Google Drive folder by generating OpenAI embeddings, chunking content, and tracking sync state in an n8n Data…

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