Bear Brown
← All N8N workflows
Data & databasesCodeFilterGoogle SheetsHTTP RequestManual Trigger

Create a Google sheet

Configured with Filter, Google Sheets, HTTP Request. Review the connections and setup before adapting this template.

Download workflow JSONView files on GitHub ↗7 nodes · MIT
Workflow preview
TriggerWhen clicking ‘Testworkflow’Manual TriggerWeb / APICall Rapid APIHTTP RequestRoutingFilter already enrichedFilterTransformEncode URIEdit FieldsCodeFiIter out all arraysCodeData storeUpdate the profileGoogle SheetsData storePull linkedin profilesGoogle Sheets

Node categories in this workflow

  • Trigger
  • Web / API
  • Routing
  • Transform
  • Code
  • Data store

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
When clicking ‘Test workflow’TriggerManual TriggerSee node parameters
Call Rapid APIWeb / APIHTTP RequestSee node parameters
Filter already enrichedRoutingFilterSee node parameters
Encode URITransformEdit FieldsSee node parameters
FiIter out all arraysCodeCodeSee node parameters
Update the profileData storeGoogle SheetsappendOrUpdate
Pull linkedin profilesData storeGoogle SheetsSee 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

Workflow notes

Create a Google sheet

Create a Google sheet

With just one column named "linkedin_url" and fill it with the profiles you want to enrich

Call RapidAPI Fresh Linkedin Profile Data

Call RapidAPI Fresh Linkedin Profile Data

You have to create an account in RapidAPI and subscribe to Fresh LinkedIn Profile Data. With a free account you will be able to scrape 100 profile / month. After your subscription you will have to replace the header values: "x-rapidapi-key" and "x-rapidapi-host" with the values given in the RapidAPI interface

LinkedIn Profile Enrichment Workflow

LinkedIn Profile Enrichment Workflow

Who is this for?

This workflow is ideal for recruiters, sales professionals, and marketing teams who need to enrich LinkedIn profiles with additional data for lead generation, talent sourcing, or market research.

What problem is this workflow solving?

Manually gathering detailed LinkedIn profile information can be time-consuming and prone to errors. This workflow automates the process of enriching profile data from LinkedIn, saving time and ensuring accuracy.

What this workflow does

  1. Input: Reads LinkedIn profile URLs from a Google Sheet.
  2. Validation: Filters out already enriched profiles to avoid redundant processing.
  3. Data Enrichment: Uses RapidAPI's Fresh LinkedIn Profile Data API to retrieve detailed profile information.
  4. Output: Updates the Google Sheet with enriched profile data, appending new information efficiently.

Setup

  1. Google Sheet: Create a sheet with a column named linkedin_url and populate it with the profile URLs to enrich.
  2. RapidAPI Account: Sign up at RapidAPI and subscribe to the Fresh LinkedIn Profile Data API.
  3. API Integration: Replace the x-rapidapi-key and x-rapidapi-host values with your credentials from RapidAPI.
  4. Run the Workflow: Trigger the workflow and monitor the updates to your Google Sheet.

How to customize this workflow

  • Filter Criteria: Modify the filter step to include additional conditions for processing profiles.
  • API Configuration: Adjust API parameters to retrieve specific fields or extend usage.
  • Output Format: Customize how the enriched data is appended to the Google Sheet (e.g., format, column mappings).
  • Error Handling: Add steps to handle API rate limits or missing data for smoother automation.

This workflow streamlines LinkedIn profile enrichment, making it faster and more effective for data-driven decision-making.

Create a Google sheet

Create a Google sheet

Purpose and structure

This folder contains the Create a Google sheet workflow. Its executable nodes use code, filter, googleSheets, httpRequest, manualTrigger, set. 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

When clicking ‘Test workflow’

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/Code/0708_Code_Filter_Update_Webhook.json MIT; preserve source notices.

More in Data & databases

1/ Add Your credentials1/ Add Your credentials2. Add Beehiiv newsletter subscribers from Gumroad sales