Automated job extraction & publishing with RAG, Jina AI and OpenAI to WordPress
Ready for 3.0What this workflow does
This AI workflow has 54 nodes and runs on Google Drive events (file updated) (plus 2 other triggers). Along the way it connects Google Drive, Supabase Vector Store, Embeddings OpenAI and OpenAI Chat Model and 4 more.
How it runs
Trigger: On Google Drive events (file updated) (plus 2 other triggers).
- Search File (Google Drive): work with file folder
- Code: runs custom JavaScript code
- 🔧 Prepare URL for Extraction (Edit Fields (Set)): sets 2 fields: text, cleanUrl
- Get Data (Google Drive): download
- Kirim ke Telegram (Telegram): uses Telegram
- 📚 Load Valid Job Types & Categories (Edit Fields (Set)): sets 2 fields: category, types
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- valid url? (If): checks a condition and branches into true / false
- Supabase Vector Store: stores documents in the Supabase vector store, with embeddings: Embeddings OpenAI; document loader: Default Data Loader
- notify: processing job (Telegram): uses Telegram
…plus 34 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (20)
- Google Drive
n8n-nodes-base.googleDrive - Supabase Vector Store
@n8n/n8n-nodes-langchain.vectorStoreSupabase - Embeddings OpenAI
@n8n/n8n-nodes-langchain.embeddingsOpenAi - Default Data Loader
@n8n/n8n-nodes-langchain.documentDefaultDataLoader - Recursive Character Text Splitter
@n8n/n8n-nodes-langchain.textSplitterRecursiveCharacterTextSplitter - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Google Drive Trigger
n8n-nodes-base.googleDriveTrigger - Telegram Trigger
n8n-nodes-base.telegramTrigger - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - If
n8n-nodes-base.if - Telegram
n8n-nodes-base.telegram - Wait
n8n-nodes-base.wait - OpenAI
@n8n/n8n-nodes-langchain.openAi - Postgres Chat Memory
@n8n/n8n-nodes-langchain.memoryPostgresChat - Jina AI
n8n-nodes-base.jinaAi - Error Trigger
n8n-nodes-base.errorTrigger
From the author
Fresh job posts without the manual grind. Auto Repost Job with RAG extracts, processes, and publishes job listings from monitored sources using Google Drive, OpenAI, Supabase, and WordPress. Job data gets extracted, categories mapped accurately, media…