n8n Workflow: Sync Supabase KB to LinkedIn with Gemini

Turn your Supabase knowledge base into daily LinkedIn posts—automatically

This 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.

What this workflow does

• Sync Supabase from Google Drive (create/update): When a new file is added to a watched Google Drive folder, the workflow downloads it, extracts text, chunks it, embeds it with Google Gemini, and stores the vectors in a Supabase vector table.
• Keep content current (update): 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.
• Daily AI content creation: Every morning at 8am, a schedule trigger starts an AI Content Creation Agent built with Google Gemini.
• Grounded writing from your knowledge base: The agent queries Supabase via a vector-store tool to pull a relevant company concept, service, or methodology.
• Support with fresh web research: It searches the web with Tavily to find recent trends, data, or news that support the chosen idea.
• Publish to LinkedIn with an image: The agent generates a structured post (title, body, hashtags) and an image prompt; Google Gemini generates the image, and the workflow publishes the final post (with image) to your LinkedIn organization page.

Use cases

• Weekly maintenance-free thought leadership by turning internal docs into consistent LinkedIn outreach.
• Product and methodology updates: upload new knowledge to Google Drive and have refreshed posts go out automatically.
• SaaS operators who want AI-assisted marketing grounded in their own Supabase-backed knowledge base.

Technical details

• n8n nodes/stack: set, limit, LinkedIn, Supabase, Sticky Note, Google Drive
• Triggers: Google Drive “file created” and “file updated”, plus a daily 8am schedule
• AI + retrieval: Google Gemini for embeddings and image generation; Supabase vector store for retrieval; Tavily for web search
• Output: structured post content via a structured output parser