Skip to main content

Generate Twitter content in personal style with OpenAI & Supabase RAG

Workflow preview

Workflow preview
100%
Generate Twitter content in personal style with OpenAI & Supabase RAG preview
Open on n8n.io

Important notice

This workflow is provided as-is. Please review and test before using in production.

1. Workflow Overview

Self Learning X Content Engine (Creator RAG Booster) Learn your voice. Generate posts that sound like you — not AI. Overview This n8n workflow builds a personal RAG (Retrieval Augmented Gener...

Best for

  • Content Creation automation workflows
  • AI RAG automation workflows
  • advanced n8n builders looking for reusable templates

Tools used

n8n-nodes-base.formtrigger, n8n-nodes-base.set, @n8n/n8n-nodes-langchain.embeddingsopenai, @n8n/n8n-nodes-langchain.documentdefaultdataloader, @n8n/n8n-nodes-langchain.textsplitterrecursivecharactertextsplitter, @n8n/n8n-nodes-langchain.vectorstoresupabase, n8n-nodes-base.form, @n8n/n8n-nodes-langchain.lmchatopenai

Source and attribution

This workflow is cataloged by N8N Workflows and links back to its original n8n.io source page by Yusuke.

Original n8n.io source

1.1 Workflow description

Title
Generate Twitter content in personal style with OpenAI & Supabase RAG
Workflow name
Generate Twitter content in personal style with OpenAI & Supabase RAG

🎯 Self-Learning X Content Engine (Creator RAG Booster)

Learn your voice. Generate posts that sound like you — not AI.

🧩 Overview

This n8n workflow builds a personal RAG (Retrieval-Augmented Generation) system for creators.
It learns from your own past posts and generates new tweets, replies, and image prompts in your tone.

⚙️ How it works

Step 1 — Ingest

  • Use the “Add to KB” Form to upload your past posts or notes.
  • Text + metadata (topic, style) are stored in Supabase as vectors.

Step 2 — Generate

  • Use the “Generate Posts” Form to create new post ideas.
  • The Agent fetches the most relevant style snippets (via Supabase VectorStore)
  • Output includes:
    • 📝 post
    • 💬 quote
    • 💭 reply
    • 🎨 image_prompt

🔧 Setup (3–5 min)

  1. Connect Supabase (URL + Key)
    • Make sure the table name is documents
    • Enable vector extension (pgvector)
  2. Connect OpenAI API Key
  3. Activate both Forms and open the URLs to test.
  4. Optionally replace Forms with Webhooks.

💡 Tip: RLS enabled? Ensure your API key allows insert/select for documents.

🧠 Tech Stack

  • n8n (self-hosted)
  • Supabase (Vector Store)
  • OpenAI (gpt-4.1-mini)
  • HTML-based completion form

🪄 Credits

Built by Yusuke | @yskautomation
License: MITView on GitHub

1.2 Logical Blocks

This catalog entry is organized from the workflow JSON. The node-level section below shows the executable blocks available for review before importing the template.

2. Block-by-Block Analysis

Block 1 - Form: Add to KB

Type / Role
n8n-nodes-base.formTrigger - formTrigger
Config choices
Version 2.2

Block 2 - Normalize (ingest)

Type / Role
n8n-nodes-base.set - set
Config choices
Version 3.4

Block 3 - Embeddings OpenAI (ingest)

Type / Role
@n8n/n8n-nodes-langchain.embeddingsOpenAi - embeddingsOpenAi
Config choices
Version 1.2

Block 4 - Document Loader (+metadata)

Type / Role
@n8n/n8n-nodes-langchain.documentDefaultDataLoader - documentDefaultDataLoader
Config choices
Version 1

Block 5 - Text Splitter

Type / Role
@n8n/n8n-nodes-langchain.textSplitterRecursiveCharacterTextSplitter - textSplitterRecursiveCharacterTextSplitter
Config choices
Version 1

Block 6 - VectorStore (Supabase)

Type / Role
@n8n/n8n-nodes-langchain.vectorStoreSupabase - vectorStoreSupabase
Config choices
Version 1

Block 7 - End Page (ingest)

Type / Role
n8n-nodes-base.form - form
Config choices
Version 2.3

Block 8 - Form: Generate

Type / Role
n8n-nodes-base.formTrigger - formTrigger
Config choices
Version 2.2

Block 9 - Build Params

Type / Role
n8n-nodes-base.set - set
Config choices
Version 3.4

Block 10 - OpenAI Chat Model

Type / Role
@n8n/n8n-nodes-langchain.lmChatOpenAi - lmChatOpenAi
Config choices
Version 1.2

Block 11 - KB (Supabase VectorStore)

Type / Role
@n8n/n8n-nodes-langchain.vectorStoreSupabase - vectorStoreSupabase
Config choices
Version 1

Block 12 - Generator Agent

Type / Role
@n8n/n8n-nodes-langchain.agent - agent
Config choices
Version 2.2

Block 13 - Edit Fields (format HTML)

Type / Role
n8n-nodes-base.set - set
Config choices
Version 3.4

Block 14 - End Page (generate)

Type / Role
n8n-nodes-base.form - form
Config choices
Version 2.3

Block 15 - Sticky: Overview (yellow)1

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 16 - Sticky: Step

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 17 - Sticky: Step 3

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 18 - Sticky: Troubleshooting1

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

3. Summary Table

Workflow Generate Twitter content in personal style with OpenAI & Supabase RAG
Complexity advanced
Nodes 18
Categories Content Creation, AI RAG
Author Yusuke
Published 10 Nov 2025

4. Reproducing the Workflow from Scratch

  1. 1. Download the workflow JSON

    Use the JSON export at /data/workflows/10672/10672.json as the source template for this automation.

  2. 2. Import the template into n8n

    Open n8n, import the downloaded JSON, and review each node before activating the workflow.

  3. 3. Configure credentials and variables

    Replace placeholder credentials, API keys, webhook URLs, account IDs, and environment-specific values with your own settings.

  4. 4. Test with sample data

    Run the workflow manually or in a staging workspace, inspect node output, and confirm downstream systems receive the expected data.

  5. 5. Activate and monitor

    Enable the workflow only after testing, then monitor executions, errors, and rate limits during the first production runs.

5. General Notes & Resources

Review imported nodes carefully before activation. This catalog entry is intended to help you inspect the workflow structure, understand required services, and find related templates faster.

Node names, credentials, schedules, webhook paths, and external service limits may need adjustment for your workspace.

Frequently asked questions

What does Generate Twitter content in personal style with OpenAI & Supabase RAG do?

Self Learning X Content Engine (Creator RAG Booster) Learn your voice. Generate posts that sound like you — not AI. Overview This n8n workflow builds a personal RAG (Retrieval Augmented Gener...

What do I need before importing this workflow?

Review the workflow JSON, configure any required credentials in n8n, and test the automation in a safe workspace before using it in production.

Can I customize this workflow?

Yes. Use the block-by-block analysis and the downloadable JSON to inspect each node, then adjust credentials, prompts, schedules, filters, or destinations for your Content Creation, AI RAG use case.