Export LinkedIn Group Members to Google Sheets
Scrape all members from a LinkedIn group and export their profiles, headlines, and locations to Google Sheets automatically.
Last updated
February 16, 2026
Connectors used
Tags
Key Takeaways
- Export every member from any LinkedIn group - Scrape all members from groups you belong to and get their data in Google Sheets
- Full profile data - Extracts name, LinkedIn URL, headline, location, membership status, and join date
- Paginated scraping - Loops through all pages of members with 3-second delays between requests
- Handles up to 2,000 members - Processes up to 200 pages with 10 members per page
- Saves as you go - Each member is written to Google Sheets in real time using Gemini 3 Flash
What This Workflow Does
This workflow scrapes all members from a LinkedIn group and exports their profiles to Google Sheets. You copy a network request from your browser's DevTools while viewing the group's members list, paste it into the workflow's manual trigger, and the workflow handles the rest. It parses the request, loops through all member pages, extracts profile data including membership status and join dates, and saves each row to your spreadsheet.
Use cases:
- Building targeted lead lists from niche industry groups
- Exporting group members for outreach campaigns
- Tracking new members joining groups relevant to your business
- Competitive intelligence on who's active in specific communities
How It Works
| Step | What Happens |
|---|---|
| 1. Manual trigger | You paste the fetch() request copied from LinkedIn DevTools |
| 2. Parse fetch request | A code node extracts the URL, headers, CSRF token, and cookies from the pasted request |
| 3. Pagination loop | Iterates through member pages (up to 200 pages, 10 per page) |
| 4. Build page URL | Updates the API URL with the current page offset |
| 5. Wait 3 seconds | Pauses between requests to avoid rate limiting |
| 6. HTTP request | Fetches the current page of members from LinkedIn's Groups API |
| 7. Extract members | Parses the API response to pull out profile data, membership status, and join dates |
| 8. Save to Google Sheets | Gemini 3 Flash writes each member as a row to your spreadsheet |
| 9. Check pagination | Determines if there are more pages and continues the loop |
Workflow Nodes
| Node | Role |
|---|---|
| Manual Trigger | Accepts the pasted fetch() request from DevTools |
| Code (Parse Fetch) | Extracts URL, headers, CSRF token, cookies, and group URN from the fetch request |
| Loop | Iterates through member pages (condition: hasMore and page < 200) |
| Code (Build URL) | Constructs the API URL for the current page offset |
| Wait (3s) | Delays 3 seconds between API calls |
| HTTP Request | Sends a GET request to LinkedIn's Groups API |
| Merge | Combines the HTTP response with the build context |
| Code (Extract Members) | Parses the LinkedIn response, matches GroupMembership entities to Profile entities, deduplicates results |
| Code (Return Members) | Returns the members array for the AI node |
| AI Agent (Gemini 3 Flash) | Saves each member to Google Sheets using add_multiple_rows tool (runs per member) |
| Code (Pagination Info) | Passes pagination state back to the loop |
| Merge | Combines AI save results with pagination data |
| Code (Extract Pagination) | Extracts hasMore, nextStart, and totalResults for the next loop iteration |
Data Exported Per Member
| Column | Field | Description |
|---|---|---|
| A | name | First and last name |
| B | linkedin_url | Full LinkedIn profile URL |
| C | headline | Professional headline |
| D | location | Geographic location (when available) |
| E | membership_status | MEMBER, OWNER, or MANAGER |
| F | joined_at | Date the member joined the group (ISO format) |
Setup Instructions
- Add the "Export LinkedIn Group Members to Google Sheets" template to Needle
- Go to your target LinkedIn group and click the "Members" tab
- Open browser DevTools (F12) and go to the Network tab
- Scroll the members list to trigger the API request
- Find the request containing
graphql?variables=(groupUrn:in the URL (look for responses that are 10 kB or larger) - Right-click the request, then select Copy, then Copy as fetch
- Paste the copied fetch() into the Manual Trigger node
- Copy the template Google Sheet (link is in the workflow's sticky note)
- Connect your Google Sheets account via the Pipedream connector
- Run the workflow
Customization
| What You Can Change | How |
|---|---|
| Google Sheet columns | Update the column mapping in the AI Agent prompt (default: A=name through F=joined_at) |
| Target spreadsheet | Update the sheet URL in the AI Agent prompt |
| Page delay | Change the Wait node duration (default: 3 seconds) |
| Max pages | Change the loop condition (default: page < 200) |
FAQ
Q: How do I find the right network request to copy?
A: Look for requests with graphql?variables=(groupUrn: in the URL. They should be responses of 10-100+ kB. The URL also contains membershipStatuses:List(OWNER,MANAGER,MEMBER).
Q: My workflow is returning errors. What should I do? A: The LinkedIn cookie expires after roughly 24 hours. Go back to LinkedIn, open DevTools, and copy a fresh fetch() request.
Q: Does this work with any LinkedIn group? A: Yes, as long as you are a member of the group. You need to be able to view the members list on LinkedIn.
Q: Why are some location fields empty? A: LinkedIn's Groups API does not always include geographic location data for members. Location depends on the member's profile settings and what LinkedIn returns in the API response.
Q: Can I scrape groups with more than 2,000 members? A: The default limit is 200 pages (2,000 members). You can increase this by editing the loop condition, but very large groups may hit LinkedIn's rate limits.
Want to showcase your own workflows?
Become a Needle workflow partner and turn your expertise into recurring revenue.
