(5/5)

Search LinkedIn companies, Score with AI and add them to Google Sheet CRM

Automated workflow: Search LinkedIn companies, Score with AI and add them to Google Sheet CRM. This workflow integrates 11 different services: stickyNote, httpRequest, wait, splitOut, set. It contains 25 nodes and follows best practices for error handling and security.

Integrations Used (2)

HTTP Request

Google Sheets

Workflow Structure (12 nodes)

100%

Manual Trigger

Start

Set

Set Variables

Http Request

Search Companies

Split Out

Extract Company Data

Split In Batches

Process Each Company

Http Request

Get Company Info

Filter Valid Companies

Google Sheets

Check If Company Exists

Is New Company?

No Op

AI Company Scoring

Wait

Wait 2s

Google Sheets

Add Company to CRM

Node Types:

logic

http

transform

action

default

trigger

Requires credentials

Prerequisites

Required Credentials (3)

Google Sheets

Used by: Check If Company Exists, Add Company to CRM

Docs

HTTP Header Auth

Used by: Get Company Info, Search Companies

Docs

OpenAI

Used by: AI Company Scoring

Docs

Multiple services required

This workflow needs 3 different credentials. Make sure you have accounts for all services before importing.

Complexity

Advanced

Expert level. Custom code, complex logic, many integrations.

Setup time: ~50 min

Score: 65/100

Conditional Logic

Loops

4 Integrations

When to Use This Workflow

Automated Reporting

Automatically collect and organize data into spreadsheets for analysis.

Spend less time on data entry and more time on insights.

Real-time Response

React instantly when events happen - new orders, form submissions, or API calls.

Zero delay between trigger and action for time-sensitive workflows.

Sales Automation

Automate lead capture, follow-ups, and CRM updates to close more deals.

Focus on selling, not on manual data entry and tracking.

workflow.json

{
  "id": "GW4dTYPBXwOrCUxo",
  "meta": {
    "instanceId": "workflow-35b3e5ab",
    "versionId": "1.0.0",
    "createdAt": "2025-09-29T07:07:59.306935",
    "updatedAt": "2025-09-29T07:07:59.306952",
    "owner": "n8n-user",
    "license": "MIT",
    "category": "automation",
    "status": "active",
    "priority": "high",
    "environment": "production"
  },
  "name": "Search LinkedIn companies, Score with AI and add them to Google Sheet CRM",
  "tags": [
    "automation",
    "n8n",
    "production-ready",
    "excellent",
...