{"product_id":"ingest-linkedin-posts-from-google-drive-to-pinecone-gemini-supabase","title":"Ingest LinkedIn Posts from Google Drive to Pinecone (Gemini, Supabase)","description":"\u003ch3\u003eTurn LinkedIn post screenshots \u0026amp; PDFs into searchable writing patterns—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow watches a Google Drive folder for new LinkedIn post files, extracts the text (including OCR for images), uses Google Gemini + Groq to identify reusable writing patterns, embeds them with Gemini, and upserts the results into a Pinecone index—while logging processed files to Supabase to prevent duplicates.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMonitors Google Drive every minute\u003c\/strong\u003e for newly created files in a selected folder (e.g., \u003cem\u003e\/reference-content\u003c\/em\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDeduplicates using Supabase\u003c\/strong\u003e by checking whether the Google Drive file ID was already processed; if it exists, the workflow stops.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDownloads the file and routes by MIME type\u003c\/strong\u003e:\n    \u003cul\u003e\n      \u003cli\u003e\n\u003cstrong\u003ePDFs:\u003c\/strong\u003e extracts text directly.\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eImages (JPEG):\u003c\/strong\u003e runs \u003cstrong\u003eTesseract OCR\u003c\/strong\u003e, then uses \u003cstrong\u003eGroq\u003c\/strong\u003e to clean and reconstruct the OCR text.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts structured “writing patterns” with Google Gemini\u003c\/strong\u003e by converting normalized post text into \u003cem\u003eJSON\u003c\/em\u003e fields such as hook type, structure, tone, formatting notes, CTA type, and anti-patterns.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates chunked documents\u003c\/strong\u003e, generates \u003cstrong\u003eGemini embeddings\u003c\/strong\u003e, and \u003cstrong\u003eupserts\u003c\/strong\u003e them into a \u003cstrong\u003ePinecone\u003c\/strong\u003e vector index with metadata.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs ingestion to Supabase\u003c\/strong\u003e (source file ID, file name, timestamp) so future runs skip the same file.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eBuild a \u003cstrong\u003eGemini-driven “LinkedIn swipe file”\u003c\/strong\u003e by continuously ingesting posts stored in Google Drive.\u003c\/li\u003e\n  \u003cli\u003eCreate a Pinecone-backed \u003cstrong\u003esemantic search\u003c\/strong\u003e experience for marketers and SaaS teams.\u003c\/li\u003e\n  \u003cli\u003eGenerate structured playbooks (hooks, tone, CTAs, formatting notes) from saved LinkedIn content for faster writing.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Drive, Supabase, Groq, Google Gemini (chat + embeddings), Pinecone.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n logic \u0026amp; nodes:\u003c\/strong\u003e set, no op, merge, filter, switch, Supabase steps for duplicate checks and ingestion logging.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOCR:\u003c\/strong\u003e Tesseract for images; PDF text extraction for documents.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46018963931315,"sku":"N8N-19554","price":4.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/qtBVF-7Xtips3Qalx3NYm_7e6KJRbO.png?v=1789376667","url":"https:\/\/buyflowscripts.com\/products\/ingest-linkedin-posts-from-google-drive-to-pinecone-gemini-supabase","provider":"N8N Commerce","version":"1.0","type":"link"}