AutomationFlowsSocial Media › Collect Linkedin Profiles with Serpapi Google Search and Sheets

Collect Linkedin Profiles with Serpapi Google Search and Sheets

ByPiotr Sikora @argone on n8n.io

> ⚠️ Self-hosted disclaimer: > This workflow uses the SerpAPI community node, which is available only on self-hosted n8n instances. > For n8n Cloud, you may need to use an HTTP Request node with the SerpAPI REST API instead.

Event trigger★★★★☆ complexity14 nodesForm TriggerN8N Nodes SerpapiFormGoogle Sheets
Social Media Trigger: Event Nodes: 14 Complexity: ★★★★☆ Added:

This workflow corresponds to n8n.io template #9153 — we link there as the canonical source.

This workflow follows the Form → Form Trigger recipe pattern — see all workflows that pair these two integrations.

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

Download .json
{
  "id": "oghc0ynE1x8iSAgb",
  "name": "[LI] - Search profiles",
  "tags": [],
  "nodes": [
    {
      "id": "55003493-01ab-4ea1-a22e-d2d97df0fa71",
      "name": "On form submission",
      "type": "n8n-nodes-base.formTrigger",
      "position": [
        -1536,
        48
      ],
      "parameters": {
        "options": {},
        "formTitle": "LinkedIn Search",
        "formFields": {
          "values": [
            {
              "fieldLabel": "Keywords (comma separated)",
              "requiredField": "={{ false }}"
            },
            {
              "fieldType": "number",
              "fieldLabel": "Pages to fetch",
              "requiredField": "={{ false }}"
            }
          ]
        },
        "responseMode": "lastNode"
      },
      "typeVersion": 2.3
    },
    {
      "id": "9a9b9b56-a179-41b6-a7ae-8723d92510de",
      "name": "Format Keywords",
      "type": "n8n-nodes-base.set",
      "position": [
        -1296,
        48
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "name": "keywords",
              "type": "string",
              "value": "={{ \n  (() => {\n    const keywords = $json[\"Keywords (comma separated)\"]\n      .split(',')\n      .map(k => k.trim())\n      .filter(Boolean);\n    return '(\"' + keywords.join('\") (\"') + '\")';\n  })()\n}}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "50b03fa5-2e7c-4e4a-a575-8ca09aa95e71",
      "name": "Build Page List",
      "type": "n8n-nodes-base.code",
      "position": [
        -1008,
        48
      ],
      "parameters": {
        "jsCode": "// Build one item per requested page with the proper SerpAPI start offsets\nconst pagesRequested = parseInt($('On form submission').item.json['Pages to fetch'] ?? 1, 10) || 1;\nconst perPage = 10;\nconst ctx = {\n  keywordsGrouped: $('Format Keywords').item.json.keywords,\n  rawKeywords: $('On form submission').item.json['Keywords (comma separated)'],\n  submittedAt: $('On form submission').item.json.submittedAt\n};\nreturn Array.from({ length: pagesRequested }, (_, i) => ({\n  json: {\n    page: i,\n    start: $('On form submission').first().json['Page (offset)'] * perPage,\n    ...ctx\n  }\n}));"
      },
      "typeVersion": 2
    },
    {
      "id": "bc93179f-578b-4fd1-9701-8fefb5f3f650",
      "name": "SerpAPI Search",
      "type": "n8n-nodes-serpapi.serpApi",
      "position": [
        -480,
        64
      ],
      "parameters": {
        "q": "=site:pl.linkedin.com/in/ {{$json.keywordsGrouped}}",
        "location": "Warsaw,Masovian Voivodeship,Poland",
        "requestOptions": {},
        "additionalFields": {
          "start": "={{$json.start}}"
        }
      },
      "credentials": {
        "serpApi": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "e3a373df-29f4-408d-a286-9a2761c30b49",
      "name": "Check how many results are returned",
      "type": "n8n-nodes-base.switch",
      "position": [
        -256,
        64
      ],
      "parameters": {
        "rules": {
          "values": [
            {
              "outputKey": "Empty list",
              "conditions": {
                "options": {
                  "version": 2,
                  "leftValue": "",
                  "caseSensitive": true,
                  "typeValidation": "loose"
                },
                "combinator": "and",
                "conditions": [
                  {
                    "operator": {
                      "type": "number",
                      "operation": "equals"
                    },
                    "leftValue": "={{ parseInt($json.search_information.total_results) }}",
                    "rightValue": "=0"
                  }
                ]
              },
              "renameOutput": true
            },
            {
              "outputKey": "Not empty list",
              "conditions": {
                "options": {
                  "version": 2,
                  "leftValue": "",
                  "caseSensitive": true,
                  "typeValidation": "loose"
                },
                "combinator": "and",
                "conditions": [
                  {
                    "operator": {
                      "type": "number",
                      "operation": "gt"
                    },
                    "leftValue": "={{ $json.search_information.total_results }}",
                    "rightValue": 0
                  }
                ]
              },
              "renameOutput": true
            }
          ]
        },
        "options": {},
        "looseTypeValidation": true
      },
      "typeVersion": 3.3
    },
    {
      "id": "aaa5aa78-d3c0-474b-8329-2a9f17012540",
      "name": "No profiles found",
      "type": "n8n-nodes-base.form",
      "position": [
        -80,
        -160
      ],
      "parameters": {
        "options": {},
        "operation": "completion",
        "completionTitle": "Response",
        "completionMessage": "No profiles found based on params."
      },
      "typeVersion": 2.3
    },
    {
      "id": "7529e706-afb5-4878-a388-2ff04fd67842",
      "name": "Split Out",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        -80,
        288
      ],
      "parameters": {
        "options": {},
        "fieldToSplitOut": "organic_results"
      },
      "typeVersion": 1
    },
    {
      "id": "20e568aa-9be7-4d97-85f1-a01725300699",
      "name": "Get Full Name to property of object",
      "type": "n8n-nodes-base.code",
      "position": [
        112,
        288
      ],
      "parameters": {
        "jsCode": "for (const item of $input.all()) {\n  if (typeof item.json.title === 'string') {\n    item.json.fullName = item.json.title.split('-')[0].trim();\n  }\n}\nreturn $input.all();"
      },
      "typeVersion": 2
    },
    {
      "id": "c7331bd5-8680-4651-97f4-6a09c0b40fe2",
      "name": "Append profile in sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        368,
        288
      ],
      "parameters": {
        "columns": {
          "value": {
            "Date": "={{ $('On form submission').item.json.submittedAt }}",
            "Profile": "={{ $json.link }}",
            "Keywords": "={{ $('On form submission').item.json['Keywords (comma separated)'] }}",
            "Full name": "={{ $json.fullName }}"
          },
          "schema": [
            {
              "id": "Date",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Date",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Full name",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Full name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Profile",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Profile",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Keywords",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Keywords",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1f_wxWdSr2hfmmRTWIHqpCKn6-63J0UUflFJnLj_M7ls/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1f_wxWdSr2hfmmRTWIHqpCKn6-63J0UUflFJnLj_M7ls",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1f_wxWdSr2hfmmRTWIHqpCKn6-63J0UUflFJnLj_M7ls/edit?usp=drivesdk",
          "cachedResultName": "[LI Profiles]"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "119be8c8-5b9e-44a8-a845-2a2e34ed2baa",
      "name": "Form Response",
      "type": "n8n-nodes-base.form",
      "position": [
        -480,
        -384
      ],
      "parameters": {
        "options": {},
        "operation": "completion",
        "completionTitle": "Response",
        "completionMessage": "Check linked file"
      },
      "typeVersion": 2.3
    },
    {
      "id": "87fe340d-f481-4158-954a-136150adbdad",
      "name": "Loop Over Items",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        -768,
        48
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 3
    },
    {
      "id": "0b168e74-c995-4bd0-9b24-9bdf997c1570",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1392,
        -224
      ],
      "parameters": {
        "width": 288,
        "height": 432,
        "content": "## Change form data to query \n```\nelemnt1, element2\n```\nchanged to \n```\n(\"elemnt1\") (\"element2\")\n```"
      },
      "typeVersion": 1
    },
    {
      "id": "367edf17-e444-426b-aeb6-f6385fbbdff4",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -560,
        -64
      ],
      "parameters": {
        "color": 5,
        "height": 304,
        "content": "## Google query\nSerpAPI used to make a query"
      },
      "typeVersion": 1
    },
    {
      "id": "6915509d-bba4-4ce3-83c5-65faa6599fbc",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        288,
        -16
      ],
      "parameters": {
        "color": 4,
        "height": 464,
        "content": "## Save profiles in Google Sheet\n\nSetup Google Sheet with the following columns:\n- Date\n- Profile\n- Keywords\n\n"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "50438f28-0644-4777-b599-a257510b1f55",
  "connections": {
    "Split Out": {
      "main": [
        [
          {
            "node": "Get Full Name to property of object",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "SerpAPI Search": {
      "main": [
        [
          {
            "node": "Check how many results are returned",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Build Page List": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Format Keywords": {
      "main": [
        [
          {
            "node": "Build Page List",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items": {
      "main": [
        [
          {
            "node": "Form Response",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "SerpAPI Search",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "On form submission": {
      "main": [
        [
          {
            "node": "Format Keywords",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Append profile in sheet": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Check how many results are returned": {
      "main": [
        [
          {
            "node": "No profiles found",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Split Out",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Full Name to property of object": {
      "main": [
        [
          {
            "node": "Append profile in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

Credentials you'll need

Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.

Pro

For the full experience including quality scoring and batch install features for each workflow upgrade to Pro

About this workflow

&gt; ⚠️ Self-hosted disclaimer: &gt; This workflow uses the SerpAPI community node, which is available only on self-hosted n8n instances. &gt; For n8n Cloud, you may need to use an HTTP Request node with the SerpAPI REST API instead.

Source: https://n8n.io/workflows/9153/ — original creator credit. Request a take-down →

More Social Media workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.

Social Media

Disclaimer: this workflow only works on self-hosted instances due to the file system usage.

Execute Workflow Trigger, HTTP Request, Form Trigger +3
Social Media

This n8n workflow automates the process of scraping job listings from both LinkedIn and Indeed platforms simultaneously, combining results, and exporting data to Google Sheets for comprehensive job ma

Form Trigger, HTTP Request, Google Sheets
Social Media

How is works This template makes it possible to extract Search Results from LinkedIn and import them into a Google Sheet.

N8N Nodes Sourcegeek, Form Trigger, Google Sheets
Social Media

💼 LinkedIn Job Finder Automation using Bright Data API & Google Sheets

Form Trigger, HTTP Request, Google Sheets
Social Media

This n8n workflow automatically converts LinkedIn video URLs into downloadable MP4 files using the LinkedIn Video Downloader API, uploads them to Google Drive with public access, and logs both the ori

Form Trigger, HTTP Request, Google Drive +1