Generate LinkedIn posts from books using OpenAI, LangChain & Pinecone vector search
Ready for 3.0What this workflow does
This AI workflow has 23 nodes and runs on Google Drive events (file updated) (plus 1 other trigger). Along the way it connects Google Drive, Pinecone Vector Store, Embeddings OpenAI and OpenAI Chat Model and 3 more.
How it runs
Trigger: On Google Drive events (file updated) (plus 1 other trigger).
- DownLoadPdf (Google Drive): download
- linkedInPostsContent (Google Sheets): uses Google Sheets
- Extract from File: extracts data from a file (pdf)
- Limit: keeps the first few items
- Pinecone Vector Store: stores documents in the Pinecone vector store, with embeddings: Embeddings OpenAI; document loader: Default Data Loader
- LinkedIn: uses LinkedIn
- Aggregate: combines items into one
- If: checks a condition and branches into true / false
- LinkedIn Post Idea Generation (AI Agent): runs an AI agent, with model: OpenAI Chat Model; 1 tool (Pinecorn Vector Store-book); memory: Simple Memory; output parser: Structured Output Parser
- linkedInPostsContent (Google Sheets): update
…plus 3 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 (19)
- Google Drive Trigger
n8n-nodes-base.googleDriveTrigger - Google Drive
n8n-nodes-base.googleDrive - Extract from File
n8n-nodes-base.extractFromFile - Pinecone Vector Store
@n8n/n8n-nodes-langchain.vectorStorePinecone - Embeddings OpenAI
@n8n/n8n-nodes-langchain.embeddingsOpenAi - Default Data Loader
@n8n/n8n-nodes-langchain.documentDefaultDataLoader - Recursive Character Text Splitter
@n8n/n8n-nodes-langchain.textSplitterRecursiveCharacterTextSplitter - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - AI Agent
@n8n/n8n-nodes-langchain.agent - Simple Memory
@n8n/n8n-nodes-langchain.memoryBufferWindow - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Split Out
n8n-nodes-base.splitOut - OpenAI
@n8n/n8n-nodes-langchain.openAi - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Limit
n8n-nodes-base.limit - LinkedIn
n8n-nodes-base.linkedIn - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets - Aggregate
n8n-nodes-base.aggregate
From the author
Automates the process of generating, storing, and publishing engaging LinkedIn posts derived from books (PDFs) using AI and vector search. --- 🧠 Overview This workflow: 1. Watches a Google Drive folder for new or updated book PDFs. 2. Extracts and embeds the…