Extract LinkedIn Sales Navigator Contacts to Google Sheets with Auto-Pagination

This n8n workflow automates the process of extracting contacts from LinkedIn Sales Navigator and saving them into a Google Sheet, handling pagination automatically. This is particularly useful for sales professionals, recruiters, and marketers who need to export large lists of leads from Sales Navigator for further analysis or outreach.

What it does

This workflow performs the following steps:

1. Manual Trigger: Initiates the workflow upon manual execution.
2. HTTP Request (LinkedIn Sales Navigator API): Makes an API call to LinkedIn Sales Navigator to fetch contact data. This node is configured to handle pagination, iterating through multiple pages of results until all contacts are retrieved.
3. Edit Fields (Set): Transforms and cleans the extracted data, mapping relevant fields from the Sales Navigator API response to a standardized format suitable for Google Sheets.
4. If: Checks for a specific condition (e.g., if there are more pages to fetch) to control the pagination loop.
5. Wait: Introduces a delay between API calls, which can be crucial for respecting API rate limits and preventing IP blocking.
6. Code: Executes custom JavaScript code, likely to manage pagination logic, update page numbers, or process data in a specific way before writing to Google Sheets.
7. Google Sheets: Appends the processed contact data as new rows to a specified Google Sheet.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running instance of n8n.
• LinkedIn Sales Navigator Account: Access to LinkedIn Sales Navigator with the necessary permissions to retrieve contact data via API.
• Google Account: A Google account with access to Google Sheets to store the extracted data.
• n8n Credentials for Google Sheets: Configured Google Sheets OAuth2 credentials in n8n.
• API Key/Authentication for LinkedIn Sales Navigator: Details on how to authenticate with the LinkedIn Sales Navigator API (this typically involves cookies, tokens, or other session management, which would be configured within the HTTP Request node).

Setup/Usage

1. Import the workflow: Download the provided JSON and import it into your n8n instance.
2. Configure Credentials:
   • Set up your Google Sheets credentials in n8n.
   • Configure the HTTP Request node with the appropriate LinkedIn Sales Navigator API endpoint and authentication details (e.g., headers, cookies, or query parameters). You will need to inspect how Sales Navigator makes its requests to replicate this.
3. Specify Google Sheet: In the Google Sheets node, specify the Spreadsheet ID and Sheet Name where you want the contact data to be written.
4. Adjust Pagination Logic: Review the Code and If nodes to understand and potentially adjust the pagination logic based on the specific Sales Navigator API response structure (e.g., how nextPageToken or offset are handled).
5. Run the workflow: Execute the workflow manually using the "When clicking ‘Execute workflow’" trigger. The workflow will then fetch contacts page by page and append them to your Google Sheet.