{"product_id":"n8n-workflow-sync-supabase-kb-to-linkedin-with-gemini","title":"n8n Workflow: Sync Supabase KB to LinkedIn with Gemini","description":"\u003ch3\u003eTurn your Supabase knowledge base into daily LinkedIn posts—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow syncs a Supabase knowledge base from Google Drive, then uses a Google Gemini + Tavily-powered AI agent to generate structured, scheduled LinkedIn organization posts with AI-generated images—every day at 8am.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eSync Supabase from Google Drive (create\/update):\u003c\/b\u003e When a new file is added to a watched Google Drive folder, the workflow downloads it, extracts text, chunks it, embeds it with \u003cb\u003eGoogle Gemini\u003c\/b\u003e, and stores the vectors in a \u003cb\u003eSupabase vector table\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eKeep content current (update):\u003c\/b\u003e If an existing file is updated, the workflow deletes the previous Supabase rows, re-downloads the refreshed content, re-chunks it, and re-embeds it to maintain an up-to-date knowledge base.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eDaily AI content creation:\u003c\/b\u003e Every morning at \u003cb\u003e8am\u003c\/b\u003e, a schedule trigger starts an AI Content Creation Agent built with \u003cb\u003eGoogle Gemini\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eGrounded writing from your knowledge base:\u003c\/b\u003e The agent queries Supabase via a \u003cb\u003evector-store tool\u003c\/b\u003e to pull a relevant company concept, service, or methodology.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSupport with fresh web research:\u003c\/b\u003e It searches the web with \u003cb\u003eTavily\u003c\/b\u003e to find recent trends, data, or news that support the chosen idea.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003ePublish to LinkedIn with an image:\u003c\/b\u003e The agent generates a structured post (title, body, hashtags) and an image prompt; \u003cb\u003eGoogle Gemini\u003c\/b\u003e generates the image, and the workflow publishes the final post (with image) to your \u003cb\u003eLinkedIn organization page\u003c\/b\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eWeekly maintenance-free thought leadership by turning internal docs into consistent LinkedIn outreach.\u003c\/li\u003e\n  \u003cli\u003eProduct and methodology updates: upload new knowledge to Google Drive and have refreshed posts go out automatically.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators who want AI-assisted marketing grounded in their own Supabase-backed knowledge base.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003en8n nodes\/stack: \u003cb\u003eset\u003c\/b\u003e, \u003cb\u003elimit\u003c\/b\u003e, \u003cb\u003eLinkedIn\u003c\/b\u003e, \u003cb\u003eSupabase\u003c\/b\u003e, \u003cb\u003eSticky Note\u003c\/b\u003e, \u003cb\u003eGoogle Drive\u003c\/b\u003e\n\u003c\/li\u003e\n  \u003cli\u003eTriggers: Google Drive “file created” and “file updated”, plus a daily \u003cb\u003e8am schedule\u003c\/b\u003e\n\u003c\/li\u003e\n  \u003cli\u003eAI + retrieval: \u003cb\u003eGoogle Gemini\u003c\/b\u003e for embeddings and image generation; Supabase vector store for retrieval; \u003cb\u003eTavily\u003c\/b\u003e for web search\u003c\/li\u003e\n  \u003cli\u003eOutput: structured post content via a structured output parser\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45869897023667,"sku":"N8N-18418","price":5.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/jTfkENsyiyu-R6GUq5Icd_lgPXO9nJ.png?v=1787130972","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-sync-supabase-kb-to-linkedin-with-gemini","provider":"N8N Commerce","version":"1.0","type":"link"}