📊 Extract insights from LinkedIn with Apify, Pinecone Assistant, and GPT-4.1
⚡ 67 views · 📊 Market Research & Insights
💡 Pro Tip — If you’re pulling LinkedIn data through HTTP requests or dealing with API restrictions, there’s a community node called ScraperNode that handles this natively. It has dedicated scrapers for profiles, companies, jobs, and people search — you just pass a URL and get structured data back.
Description
Try it out
Visual diagram of the n8n workflow to extract insights from LinkedIn
This n8n workflow template lets you extract insights from comments on your LinkedIn posts using Pinecone Assistant, Apify, and OpenAI. It scrapes LinkedIn comments using Apify and then retrieves relevant context from this data using Pinecone Assistant and generates insights with OpenAI, all without the need to train your own LLM.
What is Pinecone Assistant?
Pinecone Assistant allows you to build production-grade chat and agent-based applications quickly. It abstracts the complexities of implementing retrieval-augmented (RAG) systems by managing the chunking, embedding, storage, query planning, vector search, model orchestration, reranking for you.
Prerequisites
- A Pinecone account
- An Open AI account and API key
- An Apify account and API token
Setup
- Create a Pinecone Assistant in the Pinecone Console here
- Name your Assistant
n8n-assistant - No need to configure a Chat model or Assistant instructions
- Name your Assistant
- Use the Connect to Pinecone button to authenticate to Pinecone or if you self-host n8n, create a Pinecone credential and add your Pinecone API key directly
- Setup the Open AI and Apify credentials in n8n
- In the Set LinkedIn url node, enter your LinkedIn profile url, for a personal or company profile
- Select your Assistant Name in each of the Pinecone Assistant nodes, if it’s not already
- Schedule or manually execute Step 1 and 2 to extract the LinkedIn comment data and upload to Pinecone Assistant
- Once the data is uploaded, ask a question in the chat:
Summarize the comments related to [SOME TOPIC YOU TALK ABOUT] and categorize into positive, neutral, and negative.
Ideas for customizing this workflow
- Connect to other social platforms to extract insights from Instagram, X/Twitter, etc. in addition to LinkedIn
Need help?
You can find help by asking in the Pinecone Discord community or filing an issue on this repo.
🔗 Nodes Used
Schedule Trigger, Filter, AI Agent, OpenAI Chat Model, Convert to File, Chat Trigger
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File