The "social data tracking" workflow resource

Hi there! 😊

Thank you so much for your interest in the “social data tracking” workflow I recently shared on LinkedIn. This workflow is built using N8N, Google Sheets, and the Leadspicker API, which extracts real-time information from LinkedIn posts. It's a powerful tool that, when combined with generative AI, can monitor a list of people or companies daily and send notifications to Google Chat (or another platform) when a buying signal is detected.

‍

Below, you'll find the steps to test it out. But before we dive in, here’s the LinkedIn post I mentioned for more context:

‍https://www.linkedin.com/posts/vlastimilvodicka_this-social-data-tracking-workflow-researches-activity-7252673868841021441-QGn5?utm_source=share&utm_medium=member_desktop

‍

‍

Also, feel free to join our next webinar this Friday: 

Webinar: https://lu.ma/oedxj3ka

‍

Now, onto the fun part—here’s how to get started:

‍

Getting Your Leadspicker API Key

1. Sign up here: Leadspicker Signup
2. During onboarding, answer a few quick questions about your tech skills and the features that interest you most so we can personalize your experience.
3. Once you're inside Leadspicker, go directly to the Integrations page.
4. Create your API key by clicking the designated button:

5) Copy and save your API key — you’ll need to enter it into the N8N workflow.

The remaining steps will take place in N8N, so for this specific workflow, we won’t be using the Leadspicker interface directly. However, if you’d like to include LinkedIn or email outreach steps in your workflow or create additional workflows, feel free to reach out to us at info@leadspicker.com.

For more technical users, you can review our API documentation here:
Leadspicker API Documentation
We’ll be using the POST /app/sb/api/utils/linkedin-posts endpoint.

‍

N8N Workflow

6) Go to the link below, copy the provided code, and paste it into your N8N project:
N8N Workflow Code

7) The workflow connects to a Google Sheet formatted as shown in the sample below. Make a copy and add the people you want to monitor (customers, influencers, users, partners, etc.):
Sample Google Sheet

8) In N8N, be sure to authorize access to Google Sheets and add your ChatGPT/OpenAI API key. If you’re unsure how to do this, just send us a message at info@leadspicker.com, and we’ll be happy to help set it up.

Google Chat

9) Create a new space in Google Chat and name it something like "Account Signal Tracker."

‍

‍

10) In the space settings, navigate to Apps & integrations, and create a new webhook by clicking 

‍

11) Add webhook (refer to the screenshot below).

‍

12) Once you’ve created the webhook, copy the link and paste it into the N8N workflow under the “notification to Google Chat” node.

‍

‍

13) Edit the GPT prompt

In this step, you’ll need to customize the prompt used by GPT within the N8N workflow. This is important to ensure the notifications generated from LinkedIn posts are aligned with the type of buying signals you're looking for. The prompt can be adjusted to focus on specific keywords, behaviors, or criteria that indicate a sales opportunity.

The prompt that I used:

You are a business development expert. Analyze the post on the input and try to find information about any of these signals:

‍

Signals:

Business expansion

Starting a new job

Expanding the team

Launching a new product or service

Looking for startups

Receiving investment

Looking for sales people or lead gen tool

No signal

‍

Output just the type of signal and describe in one line what the signal is about.

For example:

Input example: "I'm happy to announce our new product AI platform for SMEs that helps you automate daily work."

Output example: "Launching new product - AI platform for SMEs."

‍

Here is the input: 

{{ $('Leadspicker API').item.json.posts[0].text }}

‍

14) Test the workflow!

Once you've set everything up, test the workflow. If the test is successful, you should start receiving notifications in your Google Chat that look like this: