← All N8N workflows
AI & researchCodeForm TriggerGoogle SheetsGoogle Sheets TriggerHTTP Request

LinkedIn Leads Scraping & Enrichment (Main)

Configured with Form Trigger, Google Sheets, Google Sheets Trigger, HTTP Request, and additional nodes. Review the connections and setup before adapting this template.

Workflow preview
TriggerOn form submissionForm TriggerTransformSplit OutSplit OutTriggerGoogle Sheets TriggerGoogle Sheets TriggerAI & modelsOpenAI1Open AiTriggerGoogle Sheets Trigger2Google Sheets TriggerTransformClean DataEdit FieldsData storeAdd Leads to GoogleSheetGoogle SheetsData storeAdd Linkedin UsernameGoogle SheetsData storeGet Pending UsernameRowGoogle SheetsData storeAdd Email AddressGoogle SheetsData storeMark Invalid EmailGoogle SheetsTriggerSchedule TriggerSchedule TriggerWeb / APIGet Email from ApolloHTTP RequestWeb / APIConfirm Email ValidityHTTP RequestData storeGet Pending EmailStatusesGoogle SheetsTriggerGoogle Sheets Trigger3Google Sheets TriggerWeb / APIGet Profile PostsHTTP RequestWeb / APIGet About ProfileHTTP RequestData storeGet Pending About andPosts RowsGoogle SheetsCodeClean Profile DataCodeTriggerGoogle Sheets Trigger4Google Sheets TriggerData storeGet Pending About andPosts Rows1Google SheetsCodeClean Posts DataCodeTriggerGoogle Sheets Trigger5Google Sheets TriggerTriggerSchedule Trigger2Schedule TriggerData storeget invalid email rowsGoogle SheetsData storeupdate_to_pendingGoogle SheetsData storeget_failed_profile_sum…Google SheetsData storeupdate_to_pending1Google SheetsTriggerSchedule Trigger3Schedule TriggerData storeget_failed_posts_summa…Google SheetsAI & modelsPosts AI SummarizerOpen AiAI & modelsAI Profile SummarizerOpen AiData storeUpdate Profile SummaryGoogle SheetsData storeUpdate Posts SummaryGoogle SheetsData storeGet Completely EnrichedProfilesGoogle SheetsData storeupdate_to_unscrapedGoogle SheetsData storeAppend to EnrichedLeads DatabaseGoogle SheetsData storeupdate status to failedGoogle SheetsData storeGoogle SheetsGoogle SheetsCodeStringify Profile Data1CodeCodeStringify Posts DataCodeWeb / APIGenerate Leads withApollo.ioHTTP RequestTriggerGoogle Sheets Trigger6Google Sheets TriggerData storeGet Pending About andPosts Rows2Google SheetsCodeClean Profile Data1CodeCodeStringify Data2CodeAI & modelsAI Profile Summarizer1Open AiData storeUpdate Profile Summary1Google SheetsCodeStringify Data3CodeAI & modelsPosts AI Summarizer1Open AiWeb / APIGet About Profile2HTTP RequestCodeClean Profile Data2CodeTransformMergeMergeData storeupdate status tofailed1Google SheetsRoutingIf email is validIf

Node categories in this workflow

  • Trigger
  • Transform
  • AI & models
  • Data store
  • Web / API
  • Code
  • Routing

Icons describe general node roles, inferred from node types. Inspect the parameters for the configured action.

Drag to pan; use + and − to zoom. Reconstructed from the exported node positions; nothing runs here. Dashed lines represent non-main connections. Full node names and notes appear below.

How it works

The exported workflow contains the following configured nodes. Their connections are shown above; inspect the JSON for the complete logic, expressions, and external actions.

Workflow node names, types, and operations
NodeCategoryTypeOperation
On form submissionTriggerForm TriggerSee node parameters
Split OutTransformSplit OutSee node parameters
Google Sheets TriggerTriggerGoogle Sheets TriggerSee node parameters
OpenAI1AI & modelsOpen AiSee node parameters
Google Sheets Trigger2TriggerGoogle Sheets TriggerSee node parameters
Clean DataTransformEdit FieldsSee node parameters
Add Leads to Google SheetData storeGoogle Sheetsappend
Add Linkedin UsernameData storeGoogle Sheetsupdate
Get Pending Username RowData storeGoogle SheetsSee node parameters
Add Email AddressData storeGoogle Sheetsupdate
Mark Invalid EmailData storeGoogle Sheetsupdate
Schedule TriggerTriggerSchedule TriggerSee node parameters
Get Email from ApolloWeb / APIHTTP RequestPOST
Confirm Email ValidityWeb / APIHTTP RequestSee node parameters
Get Pending Email StatusesData storeGoogle SheetsSee node parameters
Google Sheets Trigger3TriggerGoogle Sheets TriggerSee node parameters
Get Profile PostsWeb / APIHTTP RequestSee node parameters
Get About ProfileWeb / APIHTTP RequestSee node parameters
Get Pending About and Posts RowsData storeGoogle SheetsSee node parameters
Clean Profile DataCodeCodeSee node parameters
Google Sheets Trigger4TriggerGoogle Sheets TriggerSee node parameters
Get Pending About and Posts Rows1Data storeGoogle SheetsSee node parameters
Clean Posts DataCodeCodeSee node parameters
Google Sheets Trigger5TriggerGoogle Sheets TriggerSee node parameters
Schedule Trigger2TriggerSchedule TriggerSee node parameters
get invalid email rowsData storeGoogle SheetsSee node parameters
update_to_pendingData storeGoogle Sheetsupdate
get_failed_profile_summary_rowsData storeGoogle SheetsSee node parameters
update_to_pending1Data storeGoogle Sheetsupdate
Schedule Trigger3TriggerSchedule TriggerSee node parameters
get_failed_posts_summary_rows1Data storeGoogle SheetsSee node parameters
Posts AI SummarizerAI & modelsOpen AiSee node parameters
AI Profile SummarizerAI & modelsOpen AiSee node parameters
Update Profile SummaryData storeGoogle Sheetsupdate
Update Posts SummaryData storeGoogle Sheetsupdate
Get Completely Enriched ProfilesData storeGoogle SheetsSee node parameters
update_to_unscrapedData storeGoogle Sheetsupdate
Append to Enriched Leads DatabaseData storeGoogle SheetsappendOrUpdate
update status to failedData storeGoogle Sheetsupdate
Google SheetsData storeGoogle Sheetsupdate
Stringify Profile Data1CodeCodeSee node parameters
Stringify Posts DataCodeCodeSee node parameters
Generate Leads with Apollo.ioWeb / APIHTTP RequestPOST
Google Sheets Trigger6TriggerGoogle Sheets TriggerSee node parameters
Get Pending About and Posts Rows2Data storeGoogle SheetsSee node parameters
Clean Profile Data1CodeCodeSee node parameters
Stringify Data2CodeCodeSee node parameters
AI Profile Summarizer1AI & modelsOpen AiSee node parameters
Update Profile Summary1Data storeGoogle Sheetsupdate
Stringify Data3CodeCodeSee node parameters
Posts AI Summarizer1AI & modelsOpen AiSee node parameters
Get About Profile2Web / APIHTTP RequestSee node parameters
Clean Profile Data2CodeCodeSee node parameters
MergeTransformMergeSee node parameters
update status to failed1Data storeGoogle Sheetsupdate
If email is validRoutingIfSee node parameters

Setup

  1. Download the JSON and import it into an isolated n8n instance. Leave the workflow inactive.
  2. Connect your own credentials through n8n’s credential store. Replace REPLACE_WITH_* values with your resource identifiers.
  3. Inspect API destinations, Code nodes, database queries, file paths, and outbound actions.
  4. Run with synthetic data and harmless destinations. Enable triggers only after checking the actual outputs.

Requirements

An n8n instance with the listed node types and compatible versions. Service-connected workflows may require accounts, credentials, or paid APIs.

Credential types declared in the source

  • googleSheetsOAuth2Api
  • googleSheetsTriggerOAuth2Api
  • openAiApi

Workflow notes

Get Profile and Latest Posts Summary & Update Status (Apify Alternative - Secondary, if rapid api option doesn't work )

Get Profile and Latest Posts Summary & Update Status (Apify Alternative - Secondary, if rapid api option doesn't work )

Some users that dont have an account on rapid API cant sign up hence are unable to get to the api and get an api key. This alternative is tailored for you. Immediatelty you get access to rapid API, please switch back to using that one. It is more reliable in scraping detailed data. See updated documentation

LinkedIn Leads Scraping & Enrichment (Main)

LinkedIn Leads Scraping & Enrichment (Main)

Purpose and structure

This folder contains the LinkedIn Leads Scraping & Enrichment (Main) workflow. Its executable nodes use code, formTrigger, googleSheets, googleSheetsTrigger, httpRequest, if, merge, openAi, scheduleTrigger, set, splitOut. The table and connection map below are derived from the JSON, not an inferred guarantee of behavior.

Setup

Import inactive. Configure your own credentials and replace REPLACE_WITH_* values. Review external destinations and Code nodes before running.

Entry points

On form submission, Google Sheets Trigger, Google Sheets Trigger2, Schedule Trigger, Google Sheets Trigger3, Google Sheets Trigger4, Google Sheets Trigger5, Schedule Trigger2, Schedule Trigger3, Google Sheets Trigger6

Verification

Sanitized source candidate; not runtime-tested. This overview is generated from node metadata. Read the folder README for the connection map, credential types, and license.

Attribution

https://github.com/Zie619/n8n-workflows/blob/94007c1445d9258a7da116646b79473e7c7c3282/workflows/Splitout/1146_Splitout_Code_Automation_Webhook.json MIT; preserve source notices.

Canvas section labels

These name areas of the original canvas; they do not include explanatory instructions.

  • Extract Linkedin Username
  • Scrape Leads from Apollo
  • Get Email Address, Validate Deliverability & Update Column Status
  • Update Contact Scrape Status from Invalid back to Pending
  • Get Profile Summary & Update Status (Rapid API✅ - Primary Option)
  • Get Summary of Latest Linkedin Profile Posts (Rapid API✅ - Primary Option)
  • Update Completely Enriched Profile to Final Database
  • Update profile summary status from failed back to pending
  • Update posts summary status from failed back to pending

More in AI & research