Automate LinkedIn Profile Enrichment with n8n & RapidAPI

What this workflow does

This workflow automates the process of adding detailed information to LinkedIn profiles listed in a Google Sheet.

It saves users time spent on copying and searching LinkedIn profiles by automatically fetching job titles, companies, locations, and more.

The result is more accurate, updated data without manual entry or errors.

Who should use this workflow

Recruiters, sales teams, and marketers who need rich LinkedIn data in Google Sheets will find this workflow helpful.

It fits users who want to reduce hours spent copying profile info and avoid inconsistent data.

Tools and services used

• n8n: Automation tool to build and run the workflow.


• Google Sheets: Stores LinkedIn profile URLs and enriched data.


• RapidAPI Fresh LinkedIn Profile Data API: Provides detailed LinkedIn profile information.

Inputs, processing, and outputs

Inputs

The workflow reads LinkedIn profile URLs from the linkedin_url column in a Google Sheet.

Profiles already enriched (with an "about" field filled) are ignored to save API calls.

Processing steps

• Filter out profiles with data already fetched.


• Encode each LinkedIn URL properly for API requests.


• Call the Fresh LinkedIn Profile Data API via RapidAPI using the encoded URLs.


• Remove any array data from the API response to simplify it.


• Match and update rows in the Google Sheet by the unique LinkedIn URL.

Output

The Google Sheet is updated with detailed information like job titles, companies, and locations next to the original URL.

The data is fresh and easy to use for outreach or analysis.

Beginner step-by-step: How to use this workflow in n8n

Import the workflow

1. Download the workflow file using the Download button on this page.

2. Open the n8n editor and choose Import from File to load the workflow.

Configure credentials and IDs

3. Add your Google Sheets OAuth2 credentials in the Google Sheets nodes.

4. Add your RapidAPI API Key and Host values in the HTTP Request node headers.

5. Update the Google Sheet Document ID and Sheet Name if they differ from defaults.

Test and activate

6. Run the workflow once using the Manual Trigger node to test the process.

7. Verify the data updates correctly in your Google Sheet.

8. Activate the workflow for manual or scheduled use as fits your needs in n8n.

If using self-host n8n, monitor the logs to spot any errors.

Customization ideas

• Add filters in the filter node to exclude profiles by company or location.


• Modify the API query parameters in the HTTP Request node to limit fields or add features.


• Change column mapping in Google Sheets nodes to update only specific fields.


• Add error handling flows for API request failures or rate limit retries.

Common problems and fixes

• Invalid API key or missing headers: Check RapidAPI key and host headers in the HTTP Request node.


• Google Sheets update failures: Verify sheet ID, OAuth permissions, and matching column setup.


• Empty or wrong data from Code node: Inspect API response structure and adjust code keys accordingly.

Summary of benefits and results

✓ Saves over 10 hours weekly by automating LinkedIn data enrichment.

✓ Prevents data errors from manual copy-pasting.

✓ Provides up-to-date job titles, company info, and more for profiles.

✓ Integrates smoothly into Google Sheets for analysis and outreach.