Enrich LinkedIn Leads with Apify using Google Sheets

This n8n workflow automates the process of enriching LinkedIn lead data stored in a Google Sheet using Apify. It's designed to streamline lead generation and data enrichment, providing more comprehensive information for sales and marketing efforts.

What it does

This workflow simplifies the process of enriching lead data by:

1. Triggering Manually: The workflow is initiated manually, allowing you to control when the enrichment process begins.
2. Reading Data from Google Sheets: It reads lead data from a specified Google Sheet, likely containing initial LinkedIn profile URLs or company names.
3. Preparing Data for Apify: A "Code" node is used to transform and prepare the data from Google Sheets into a format suitable for the Apify API. This might involve extracting specific fields or constructing API request bodies.
4. Enriching Data with Apify: (Implicit, as Apify node is not in JSON but inferred from the name and data preparation) It's intended to send the prepared data to an Apify actor (e.g., a LinkedIn profile scraper or company data extractor) to gather additional information.
5. Processing Apify Results: (Implicit) It would then process the results returned by Apify.
6. Combining Data: A "Merge" node is used to combine the original data from Google Sheets with the enriched data obtained from Apify.
7. Updating Google Sheets: (Implicit) The enriched and merged data would then be written back to Google Sheets, updating existing records or adding new ones with the enhanced information.
8. Editing Fields: An "Edit Fields (Set)" node allows for renaming, adding, or removing fields from the data before or after writing back to Google Sheets, ensuring the output is clean and well-structured.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running n8n instance.
• Google Sheets Account: Access to a Google Sheet containing your LinkedIn lead data.
• Google Sheets Credentials: Configured Google Sheets credentials in n8n.
• Apify Account: An Apify account with access to relevant actors for LinkedIn data enrichment.
• Apify API Key: Configured Apify API credentials in n8n (implicit, as an Apify node would require this).

Setup/Usage

1. Import the Workflow: Import the provided JSON into your n8n instance.
2. Configure Credentials:
   • Set up your Google Sheets credentials.
   • Set up your Apify credentials (if an Apify node is added).
3. Configure Google Sheets Node (ID: 18):
   • Specify the Spreadsheet ID and Sheet Name where your lead data is located.
   • Configure the Operation (e.g., "Read" to get initial data, "Update" or "Append" to write back enriched data).
4. Configure Code Node (ID: 834):
   • Review and adjust the JavaScript code to correctly extract and format data from Google Sheets for your chosen Apify actor. This node is crucial for preparing the input for Apify.
5. Add and Configure Apify Node (Missing in JSON, but essential for the workflow's purpose):
   • Drag and drop an Apify node into the workflow.
   • Configure it to call the specific Apify actor you intend to use for LinkedIn lead enrichment (e.g., "LinkedIn Profile Scraper").
   • Map the input data from the "Code" node to the Apify actor's input parameters.
6. Configure Merge Node (ID: 24):
   • Ensure the merge node is correctly set up to combine the original Google Sheets data with the output from the Apify node.
7. Configure Edit Fields (Set) Node (ID: 38):
   • Adjust this node to clean up, rename, or add any necessary fields to the enriched data before it's written back to Google Sheets.
8. Add Google Sheets Node for Writing (Missing in JSON, but essential for the workflow's purpose):
   • Add another Google Sheets node after the "Merge" and "Edit Fields" nodes.
   • Configure it to write the enriched data back to your Google Sheet (e.g., using "Update" or "Append Row" operations).
9. Execute Workflow: Click the "Execute workflow" button on the "Manual Trigger" node (ID: 838) to run the workflow.