Extract insights from LinkedIn with Apify, Pinecone Assistant, and GPT-4.1

Try it out

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

1. Create a Pinecone Assistant in the Pinecone Console here
   1. Name your Assistant n8n-assistant
   2. No need to configure a Chat model or Assistant instructions
2. 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
3. Setup the Open AI and Apify credentials in n8n
4. In the Set LinkedIn url node, enter your LinkedIn profile url, for a personal or company profile
5. Select your Assistant Name in each of the Pinecone Assistant nodes, if it's not already
6. Schedule or manually execute Step 1 and 2 to extract the LinkedIn comment data and upload to Pinecone Assistant
7. 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.