Extract Premium & Verified LinkedIn Group Members to Google Sheets with ConnectSafely.AI

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: Initializes pagination variables with your target group ID Fetches group members in batches of 50 via ConnectSafely.ai API Filters each batch for Premium OR Verified members only Extracts profile data (name, headline, follower count, profile URL, etc.) Checks if more pages exist and loops back automatically Once complete, splits all members into individual items 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 Name | Description | Required | |------------|-------------|----------| | Profile ID | Unique LinkedIn profile identifier | Yes | | First Name | Member's first name | Yes | | Last Name | Member's last name | Yes | | Full Name | Combined first and last name | Yes | | Headline | Professional headline/tagline | Yes | | Public Identifier | LinkedIn username | Yes | | Profile URL | Direct link to LinkedIn profile | Yes | | Follower Count | Number of followers | Yes | | Is Premium | Premium subscription status | Yes | | Is Verified | Verification badge status | Yes | | Relationship Status | Connection 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

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

Add Bearer Auth Credential in n8n

Go to Credentials in n8n Click Add Credential → Header Auth or Bearer Auth Paste your ConnectSafely.ai API key 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

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

3.2 Configure "Append to Google Sheets" Node

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

Step 4: Set Your Target LinkedIn Group

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

Finding Your Group ID: Go to your LinkedIn group Look at the URL: linkedin.com/groups/XXXXXXX/ The numbers are your group ID

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

Step 5: Test the Workflow

Click the Start Workflow manual trigger node Click Test Workflow 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:

Premium Only**: Remove the isVerified checks to capture only Premium subscribers Verified Only**: Remove the isPremium checks to capture only Verified profiles All Members**: Remove the filter entirely to extract everyone (modify the return statement) Minimum Followers**: Add a follower count threshold for influencer targeting

// 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

Default**: 50 members per API request Adjust**: Modify the count value in Initialize Pagination node Note**: 50 is the maximum allowed by the API

Additional Fields

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

creator - Whether they're a LinkedIn creator badges - Full list of profile badges fetchedAt - Timestamp of extraction

Use Cases

Sales Prospecting**: Build targeted prospect lists from industry-specific groups with verified decision-makers Competitor Research**: Analyze who's active in competitor communities and their professional backgrounds Influencer Identification**: Find Premium creators and verified professionals for partnership opportunities Recruiting**: Source passive candidates who are active in professional development groups Event Marketing**: Identify engaged professionals in niche communities for webinar and conference promotion Content Strategy**: Research headlines and titles to understand what resonates in your industry

Troubleshooting

Common Issues & Solutions

Issue: Empty results returned Solution**: Verify you're a member of the target group; API can only access groups you've joined

Issue: "401 Unauthorized" errors Solution**: Check that your ConnectSafely.ai API key is valid and the Bearer Auth credential is properly configured

Issue: Pagination loop seems infinite Solution**: This is expected behavior until hasMore returns false; large groups may take several minutes to fully process

Issue: Duplicate entries in Google Sheets Solution**: Ensure the "Append or Update" operation is selected with Profile ID as the matching column

Issue: Missing data in certain columns Solution**: Not all profiles have complete data; the workflow handles null values gracefully

Issue: Google Sheets not updating Solution**: Verify OAuth credentials are valid and the sheet/document IDs are correctly configured

Documentation & Resources

Official Documentation ConnectSafely.ai Docs**: https://connectsafely.ai/docs API Reference**: Available in ConnectSafely.ai dashboard n8n Google Sheets Node**: https://docs.n8n.io/integrations/builtin/app-nodes/n8n-nodes-base.googlesheets/

Support Channels Email Support**: support@connectsafely.ai Documentation**: https://connectsafely.ai/docs Custom Workflows**: Contact us for custom automation

Connect With Us

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

LinkedIn**: linkedin.com/company/connectsafelyai YouTube**: youtube.com/@ConnectSafelyAI-v2x Instagram**: instagram.com/connectsafely.ai Facebook**: facebook.com/connectsafelyai X (Twitter): x.com/AiConnectsafely Bluesky: connectsafelyai.bsky.social Mastodon**: mastodon.social/@connectsafely

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: Multi-channel engagement workflows AI-powered personalization at scale Lead scoring and qualification automation CRM integration and data synchronization Custom reporting and analytics pipelines