📊 Extract insights from LinkedIn comments with Apify, Pinecone Assistant, and GPT-4.1
⚡ 23 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 and API key
- 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
- Setup Pinecone API key, OpenAI API key, and Apify API token as 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