{"product_id":"sync-woocommerce-wordpress-google-drive-to-pinecone-with-openai","title":"Sync WooCommerce, WordPress \u0026 Google Drive to Pinecone with OpenAI","description":"\u003ch3\u003eKeep your Pinecone knowledge base synced with WooCommerce, WordPress, and Google Drive—using OpenAI embeddings\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically converts your WooCommerce products\/reviews, WordPress pages\/posts, and Google Drive files into OpenAI vector embeddings, chunks the content, and keeps a Pinecone index up to date. It also tracks sync status in an n8n Data Table (\u003ccode\u003epinecone_sync_state\u003c\/code\u003e) so only new or changed content is processed.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on multiple triggers:\u003c\/strong\u003e manual execution, daily schedules (blog at \u003cem\u003e4:00 AM\u003c\/em\u003e and products at \u003cem\u003e5:00 AM\u003c\/em\u003e), a Google Drive new-file trigger, and WooCommerce webhook events for product changes.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates required configuration:\u003c\/strong\u003e store URL, Pinecone index settings, OpenAI embedding model\/dimensions, chunking rules, and trigger-specific values (such as Drive folder ID or WooCommerce webhook secret).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWooCommerce batch sync:\u003c\/strong\u003e fetches all published products, uses \u003ccode\u003epinecone_sync_state\u003c\/code\u003e to detect new\/changed items, removes vectors for unpublished\/deleted products, then loads each product’s variations and latest reviews.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWooCommerce webhook sync:\u003c\/strong\u003e verifies the WooCommerce HMAC signature, resolves the canonical product ID, deletes vectors for deleted\/unpublished products, or fetches product details (plus variations and reviews) for updates.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWordPress blog sync:\u003c\/strong\u003e inventories published posts\/pages via the WordPress REST API with pagination, removes vectors for deleted items, and fetches full content for new\/changed entries.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Drive sync:\u003c\/strong\u003e lists files in a target folder, skips temp\/unchanged files, and extracts text from Docs\/Sheets\/PDF (with OCR fallback) and other file types using OpenAI Vis-based processing.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eEnable reliable RAG for e-commerce: Pinecone stays current with product descriptions, variations, and reviews.\u003c\/li\u003e\n  \u003cli\u003eSync a content knowledge base: WordPress pages\/posts are embedded and searchable without manual reindexing.\u003c\/li\u003e\n  \u003cli\u003eIngest documentation files: automatically embed Google Drive content from a specific folder.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI embeddings + chunking\u003c\/strong\u003e before writing to \u003cstrong\u003ePinecone\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n lanes and routing\u003c\/strong\u003e after configuration validation.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegration components:\u003c\/strong\u003e \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003ccode\u003eno op\u003c\/code\u003e, \u003ccode\u003egmail\u003c\/code\u003e, and \u003ccode\u003eswitch\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eState tracking:\u003c\/strong\u003e n8n Data Table (\u003ccode\u003epinecone_sync_state\u003c\/code\u003e) to prevent unnecessary re-embedding.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46172931063987,"sku":"N8N-20604","price":53.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/nUdjOGTMqaGGJ4Ftba7J6_KudK7mJT.png?v=1791363863","url":"https:\/\/buyflowscripts.com\/products\/sync-woocommerce-wordpress-google-drive-to-pinecone-with-openai","provider":"N8N Commerce","version":"1.0","type":"link"}