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

Description

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

Create a Pinecone Assistant in the Pinecone Console here
Name your Assistant n8n-assistant
No need to configure a Chat model or Assistant instructions
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.