LinkedIn Profile Enrichment using Ghost Genius and Google Sheets - n8n Workflow

• Sales teams and SDRs who need accurate, up-to-date professional contact details.


• Recruiters building talent pipelines and analyzing candidate backgrounds.


• Data analysts requiring structured LinkedIn data for market research.


• Users looking for practical n8n templates integrating external APIs with Google Sheets.

Maintaining a clean, detailed list of professional contacts can be time-consuming. This powerful n8n workflow template solves the manual enrichment problem by automating the lookup process. Using the Ghost Genius API, this n8n workflow instantly converts basic LinkedIn profile URLs into comprehensive data points—including experience, education, followers, and hiring status.

This automation is built around robust data flow control, starting with a simple list in Google Sheets and ending with a fully enriched database. It uses the Google Sheets n8n node efficiently for both reading and updating, making this one of the most valuable n8n templates for efficient data operations. By implementing this n8n workflow, you ensure your CRM or lead list is always powered by accurate, deep profile data.

This efficient n8n workflow begins execution using the manual n8n trigger node, allowing on-demand data processing.

1. Data Retrieval: The first active n8n node, "Recover Profiles" (Google Sheets), initiates the process by reading all rows from the specified Google Sheet, targeting the columns containing the LinkedIn URLs.


2. API Request: For each URL item recovered, the process moves to the "Get Profile Info" n8n node (HTTP Request). This n8n node calls the Ghost Genius /v2/profile endpoint, passing the URL dynamically. Crucially, this n8n node is configured with mandatory batching (1 item every 2000ms) to ensure the API rate limits are managed effectively. It retrieves the extensive structured profile data.


3. Data Update: Finally, the "Update" Google Sheets n8n node processes the rich JSON data returned by the API. It matches the original row using the url column and uses complex n8n expressions to map dozens of fields (Firstname, Lastname, 5 Experiences, 3 Educations, Skills, etc.) back into the correct spreadsheet columns. This completes the automatic data enrichment cycle defined by the n8n workflow.

To deploy this specific n8n workflow template, follow these steps:

1. Import the n8n Workflow: Copy the provided JSON code and import it directly into your n8n instance via the 'New' menu > 'Import from JSON'.


2. Setup Google Sheets Credentials: Configure the 'Recover Profiles' and 'Update' n8n node instances. You will need a Google Sheets credential configured in n8n (Service Account is recommended for non-interactive use). Link both Google Sheets n8n nodes to your designated list spreadsheet.


3. Setup Ghost Genius Credentials: Configure the "Get Profile Info" n8n node's authentication. This requires a Generic HTTP Header Authentication setup where you enter your Ghost Genius API key.


4. Review Mappings: Ensure your Google Sheet column headers precisely match the mappings defined in the 'Update' n8n node (e.g., 'url', 'Firstname', 'Experience 1', etc.).


5. Activate and Run: Once credentials and sheet connections are confirmed, activate the n8n workflow and execute the initial manual n8n trigger.

Start (Manual Trigger n8n Trigger): Initiates the execution of the n8n workflow on command.
Recover Profiles (Google Sheets n8n Node): Reads data from a specific Google Sheet, retrieving the list of LinkedIn URLs to be enriched.
Get Profile Info (HTTP Request n8n Node): This core n8n node sends requests to the https://api.ghostgenius.fr/v2/profile endpoint. Key configurations include using an expression ={{ $json.url }} to dynamically pass the LinkedIn link and setting a 2000ms batch interval to avoid overwhelming the external API.
Update (Google Sheets n8n Node): Performs the final action of this n8n workflow. It uses the url as the matching column to locate the corresponding row and updates numerous fields (e.g., Skills, Followers, Summary, Experience 1) using data derived from the Ghost Genius API response.