🎣 Extract premium & verified LinkedIn group members to Google Sheets with ConnectSafely.AI

⚡ 69 views · 🎣 Lead Generation & Enrichment

💡 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.

View All Scrapers

Description

Extract LinkedIn Group Members to Google Sheets - Premium & Verified Only using ConnectSafely.AI API

Who’s it for

This workflow is built for sales professionals, community managers, recruiters, and growth marketers who want to extract high-quality leads from LinkedIn groups without the manual grind. Perfect for anyone who needs to identify decision-makers, founders, and serious professionals within large LinkedIn communities.

If you’re running targeted outreach campaigns, building prospect lists, researching competitor communities, or looking to connect with verified industry leaders, this automation filters the noise and delivers only Premium and Verified members straight to your spreadsheet.

How it works

The workflow automates LinkedIn group member extraction by combining pagination handling with intelligent filtering through ConnectSafely.ai’s API.

The process flow:

  1. Initializes pagination variables with your target group ID
  2. Fetches group members in batches of 50 via ConnectSafely.ai API
  3. Filters each batch for Premium OR Verified members only
  4. Extracts profile data (name, headline, follower count, profile URL, etc.)
  5. Checks if more pages exist and loops back automatically
  6. Once complete, splits all members into individual items
  7. Appends or updates records in Google Sheets (deduplicates by Profile ID)

The pagination loop handles groups of any size - whether 500 or 50,000 members.

Setup steps

Step 1: Prepare Your Google Sheet

Structure your Google Sheet with the following columns:

Column NameDescriptionRequired
Profile IDUnique LinkedIn profile identifierYes
First NameMember’s first nameYes
Last NameMember’s last nameYes
Full NameCombined first and last nameYes
HeadlineProfessional headline/taglineYes
Public IdentifierLinkedIn usernameYes
Profile URLDirect link to LinkedIn profileYes
Follower CountNumber of followersYes
Is PremiumPremium subscription statusYes
Is VerifiedVerification badge statusYes
Relationship StatusConnection degree (1st, 2nd, 3rd)Yes

Pro Tip: The workflow uses “Append or Update” operation with Profile ID as the matching column, so running it multiple times won’t create duplicates.

Step 2: Configure ConnectSafely.ai API Credentials

Obtain API Key

  1. Log into ConnectSafely.ai Dashboard
  2. Navigate to Settings → API Keys
  3. Generate a new API key

Add Bearer Auth Credential in n8n

  1. Go to Credentials in n8n
  2. Click Add Credential → Header Auth or Bearer Auth
  3. Paste your ConnectSafely.ai API key
  4. Save the credential

This credential is used by the “Fetch Group Members” HTTP Request node.

Step 3: Configure Google Sheets Integration

3.1 Connect Google Sheets Account

  1. Go to Credentials → Add Credential → Google Sheets OAuth2
  2. Follow the OAuth flow to connect your Google account
  3. Grant access to Google Sheets

3.2 Configure “Append to Google Sheets” Node

  1. Open the Append to Google Sheets node
  2. Select your Google Sheets credential
  3. Enter your Document ID (from the sheet URL)
  4. Select the Sheet Name
  5. Configure column mapping to match the extracted fields
  6. Set Matching Column to Profile ID for deduplication

Step 4: Set Your Target LinkedIn Group

  1. Open the Initialize Pagination node
  2. Locate the groupId variable in the code
  3. Replace "9357376" with your target group ID

Finding Your Group ID:

// Change this value to your target group
groupId: "9357376",  // Replace with your group ID

Step 5: Test the Workflow

  1. Click the Start Workflow manual trigger node
  2. Click Test Workflow
  3. Verify:
    • API returns member data correctly
    • Filtering captures only Premium/Verified members
    • Pagination loops for additional pages (if applicable)
    • Google Sheets populates with extracted data

Customization

Filter Criteria

Edit the filter logic in the Process & Filter Members node to adjust:

// Example: Filter for Premium members with 1000+ followers
const filteredMembers = members.filter(member => {
  const isPremium = member.isPremium === true;
  const hasMinFollowers = member.followerCount >= 1000;
  return isPremium && hasMinFollowers;
});

Batch Size

Additional Fields

The API returns more fields than extracted by default. Edit the Process & Filter Members node to include:

Use Cases

Troubleshooting

Common Issues & Solutions

Issue: Empty results returned

Issue: “401 Unauthorized” errors

Issue: Pagination loop seems infinite

Issue: Duplicate entries in Google Sheets

Issue: Missing data in certain columns

Issue: Google Sheets not updating

Documentation & Resources

Official Documentation

Support Channels

Connect With Us

Stay updated with the latest automation tips, LinkedIn strategies, and platform updates:

Need Custom Workflows?

Looking to build sophisticated LinkedIn automation workflows tailored to your business needs?

Contact our team for custom automation development, strategy consulting, and enterprise solutions.

We specialize in:

đź”— Nodes Used

Google Sheets, HTTP Request

đź“Ą Import

Download workflow.json and import into n8n: Workflow menu → Import from File

📖 Importing guide · 🔑 Credential setup