This workflow corresponds to n8n.io template #2324 — we link there as the canonical source.
This workflow follows the Agent → Google Sheets 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 →
{
"meta": {
"templateId": "2324",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "71b06728-7f59-49e3-9365-3281189a6659",
"name": "When clicking \"Test workflow\"",
"type": "n8n-nodes-base.manualTrigger",
"position": [
920,
340
],
"parameters": {},
"typeVersion": 1
},
{
"id": "b37019e3-c7ab-4119-986d-c27d082a036e",
"name": "Input",
"type": "n8n-nodes-base.set",
"position": [
1340,
340
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "fcc97354-b9f6-4459-a004-46e87902c77c",
"name": "company_input",
"type": "string",
"value": "={{ $json.input }}"
},
{
"id": "e5415c49-5204-45b1-a0e9-814157127b12",
"name": "row_number",
"type": "number",
"value": "={{ $json.row_number }}"
}
]
}
},
"typeVersion": 3.3
},
{
"id": "7d5d53ac-6d3c-4b24-97c7-deb6b76749e5",
"name": "OpenAI Chat Model",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
2020,
660
],
"parameters": {
"model": "gpt-4o",
"options": {
"temperature": 0.3
}
},
"credentials": {
"openAiApi": {
"name": "<your credential>"
}
},
"typeVersion": 1
},
{
"id": "24e2f3b0-8b90-49a9-bde6-0fb0c2baf52a",
"name": "Get website content",
"type": "@n8n/n8n-nodes-langchain.toolWorkflow",
"position": [
2580,
680
],
"parameters": {
"name": "get_website_content",
"source": "parameter",
"description": "This tool will return the text from the given URL. ",
"workflowJson": "{\n \"meta\": {\n \"templateCredsSetupCompleted\": true,\n \"instanceId\": \"2b1cc1a8b0a2fb9caab11ab2d5eb3712f9973066051b2e898cf4041a1f2a7757\"\n },\n \"nodes\": [\n {\n \"parameters\": {},\n \"id\": \"475eaf3c-7e11-457e-8b72-4d3e683e2f80\",\n \"name\": \"Execute Workflow Trigger\",\n \"type\": \"n8n-nodes-base.executeWorkflowTrigger\",\n \"typeVersion\": 1,\n \"position\": [\n 260,\n 340\n ]\n },\n {\n \"parameters\": {\n \"url\": \"={{ $json.query.url }}\",\n \"options\": {}\n },\n \"id\": \"321fbc74-d749-4f9b-954e-7cad37601ddf\",\n \"name\": \"Visit Website\",\n \"type\": \"n8n-nodes-base.httpRequest\",\n \"typeVersion\": 4.2,\n \"position\": [\n 440,\n 340\n ]\n },\n {\n \"parameters\": {\n \"operation\": \"extractHtmlContent\",\n \"extractionValues\": {\n \"values\": [\n {\n \"key\": \"body\",\n \"cssSelector\": \"html\",\n \"skipSelectors\": \"head\"\n }\n ]\n },\n \"options\": {\n \"cleanUpText\": true\n }\n },\n \"id\": \"6e51732a-4999-4805-838b-f692e9965197\",\n \"name\": \"HTML\",\n \"type\": \"n8n-nodes-base.html\",\n \"typeVersion\": 1.2,\n \"position\": [\n 620,\n 340\n ]\n }\n ],\n \"connections\": {\n \"Execute Workflow Trigger\": {\n \"main\": [\n [\n {\n \"node\": \"Visit Website\",\n \"type\": \"main\",\n \"index\": 0\n }\n ]\n ]\n },\n \"Visit Website\": {\n \"main\": [\n [\n {\n \"node\": \"HTML\",\n \"type\": \"main\",\n \"index\": 0\n }\n ]\n ]\n }\n },\n \"pinData\": {\n \"Execute Workflow Trigger\": [\n {\n \"query\": {\n \"url\": \"https://www.lemlist.com\"\n }\n }\n ]\n }\n}",
"jsonSchemaExample": "{\n\t\"url\": \"https://www.lemlist.com\"\n}",
"specifyInputSchema": true,
"responsePropertyName": "body"
},
"typeVersion": 1.1
},
{
"id": "ff7ab74c-dfc6-43ce-8c57-6edf935b4915",
"name": "SerpAPI - Search Google",
"type": "@n8n/n8n-nodes-langchain.toolSerpApi",
"position": [
2300,
660
],
"parameters": {
"options": {}
},
"credentials": {
"serpApi": {
"name": "<your credential>"
}
},
"typeVersion": 1
},
{
"id": "4fe311f2-4983-4380-b4ed-a827a406fce5",
"name": "Structured Output Parser",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
2880,
660
],
"parameters": {
"schemaType": "manual",
"inputSchema": "{\n\t\"type\": \"object\",\n\t\"properties\": {\n\t\t\"case_study_link\": {\n\t\t\t\"type\":[\"string\", \"null\"]\n\t\t},\n \t\t\"domain\": {\n\t\t\t\"type\": [\"string\", \"null\"]\n\t\t},\n \"linkedinUrl\": {\n\t\t\t\"type\": [\"string\", \"null\"]\n\t\t},\n \t\"market\": {\n\t\t\t\"type\": [\"string\", \"null\"]\n\t\t},\n\t\t\"cheapest_plan\": {\n\t\t\t\"type\": [\"number\", \"null\"]\n\t\t},\n\t\"has_enterprise_plan\": {\n\t\t\t\"type\": [\"boolean\", \"null\"]\n\t\t},\n\t\"has_API\": {\n\t\t\t\"type\": [\"boolean\", \"null\"]\n\t\t},\n\t\"has_free_trial\": {\n\t\t\t\"type\": [\"boolean\", \"null\"]\n\t\t},\n\t\"integrations\": {\n\t\t\t\"type\": [\"array\",\"null\"],\n \"items\": {\n\t\t\t\t\"type\": \"string\"\n\t\t\t}\n\t\t}\n\t}\n}"
},
"typeVersion": 1.2
},
{
"id": "89ed0723-4dbe-428d-b1a9-ebdf515e42bb",
"name": "Loop Over Items",
"type": "n8n-nodes-base.splitInBatches",
"position": [
1600,
340
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "34ea3862-e8e5-4bf2-a9aa-2ad084376bb5",
"name": "AI Researcher Output Data",
"type": "n8n-nodes-base.set",
"position": [
2960,
340
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "4109ca11-1bb8-4f5c-8bec-a962f44b0746",
"name": "domain",
"type": "string",
"value": "={{ $json.output.domain }}"
},
{
"id": "7f492768-375e-48fa-866b-644b2b5cbd68",
"name": "linkedinUrl",
"type": "string",
"value": "={{ $json.output.linkedinUrl }}"
},
{
"id": "e30b0d07-68db-45a1-9593-fd6ce24a1d50",
"name": "market",
"type": "string",
"value": "={{ $json.output.market }}"
},
{
"id": "0c03a51e-2c07-4583-85c6-d3d2ee81c5d1",
"name": "cheapest_plan",
"type": "number",
"value": "={{ $json.output.cheapest_plan }}"
},
{
"id": "0c9622d0-8446-4663-9a94-964b5df851f1",
"name": "has_enterprise_plan",
"type": "boolean",
"value": "={{ $json.output.has_enterprise_plan }}"
},
{
"id": "564cf6ea-457f-4762-bc19-6900b7d5743c",
"name": "has_API",
"type": "boolean",
"value": "={{ $json.output.has_API }}"
},
{
"id": "7fd39897-65c3-45d6-9563-8254f55ecef0",
"name": "has_free_trial",
"type": "boolean",
"value": "={{ $json.output.has_free_trial }}"
},
{
"id": "26477939-d407-4cae-92b2-9a9dc0f53a64",
"name": "integrations",
"type": "array",
"value": "={{ $json.output.integrations }}"
},
{
"id": "f0cc61d1-6b6b-4142-8627-4a4c721b19a1",
"name": "case_study_link",
"type": "string",
"value": "={{ $json.output.case_study_link }}"
}
]
}
},
"typeVersion": 3.3
},
{
"id": "ff1cb26d-6138-4ee1-9f28-4ecc80c1c8ae",
"name": "Google Sheets - Update Row with data",
"type": "n8n-nodes-base.googleSheets",
"position": [
3600,
700
],
"parameters": {
"columns": {
"value": {
"domain": "={{ $json.domain }}",
"market": "={{ $json.market }}",
"row_number": "={{ $json.row_number }}",
"linkedinUrl": "={{ $json.linkedinUrl }}",
"integrations": "={{ $json.integrations }}",
"cheapest_plan": "={{ $json.cheapest_plan }}",
"has_free_trial": "={{ $json.has_free_trial }}",
"enrichment_status": "done",
"has_entreprise_plan": "={{ $json.has_enterprise_plan }}",
"last_case_study_link": "={{ $json.case_study_link }}"
},
"schema": [
{
"id": "input",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "input",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "domain",
"type": "string",
"display": true,
"required": false,
"displayName": "domain",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "linkedinUrl",
"type": "string",
"display": true,
"required": false,
"displayName": "linkedinUrl",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "has_free_trial",
"type": "string",
"display": true,
"required": false,
"displayName": "has_free_trial",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "cheapest_plan",
"type": "string",
"display": true,
"required": false,
"displayName": "cheapest_plan",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "has_entreprise_plan",
"type": "string",
"display": true,
"required": false,
"displayName": "has_entreprise_plan",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "last_case_study_link",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "last_case_study_link",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "market",
"type": "string",
"display": true,
"required": false,
"displayName": "market",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "integrations",
"type": "string",
"display": true,
"required": false,
"displayName": "integrations",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "enrichment_status",
"type": "string",
"display": true,
"required": false,
"displayName": "enrichment_status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"row_number"
]
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/19U7gAgkUEz6mbFcnygf1zKDdGvY6OAdUqq3bZQWgjxE/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "19U7gAgkUEz6mbFcnygf1zKDdGvY6OAdUqq3bZQWgjxE",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/19U7gAgkUEz6mbFcnygf1zKDdGvY6OAdUqq3bZQWgjxE/edit?usp=drivesdk",
"cachedResultName": "Enrich companies using AI agents"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 4.3
},
{
"id": "6611f852-b4d6-4a07-9428-db206ef57cc3",
"name": "Merge data",
"type": "n8n-nodes-base.merge",
"position": [
3240,
180
],
"parameters": {
"mode": "combine",
"options": {},
"combinationMode": "mergeByPosition"
},
"typeVersion": 2.1
},
{
"id": "2a19516b-33a1-4987-9b5f-242a084621e0",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
380,
240
],
"parameters": {
"width": 409.0131656322444,
"height": 658.0614601225933,
"content": "## \uc77d\uc74c\n\n\uc774 \uc6cc\ud06c\ud50c\ub85c\ub294 AI\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc6f9\uc73c\ub85c \uacc4\uc815 \uc870\uc0ac\ub97c \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.\n\n\ucca8\ub2e8 AI \ubaa8\ub4c8\uc5d0\ub294 2\uac00\uc9c0 \uae30\ub2a5\uc774 \uc788\uc2b5\ub2c8\ub2e4: \n- SerpAPI\ub97c \uc0ac\uc6a9\ud558\uc5ec Google \uac80\uc0c9\n- \uc11c\ube0c-\uc6cc\ud06c\ud50c\ub85c\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc6f9\uc0ac\uc774\ud2b8 \ubc29\ubb38 \ubc0f \ub0b4\uc6a9 \uac00\uc838\uc624\uae30\n\n\n\ube44\uad6c\uc870\ud654\ub41c \uc785\ub825(\uc608: \ub3c4\uba54\uc778 \ub610\ub294 \ud68c\uc0ac \uc774\ub984)\uc73c\ub85c\ubd80\ud130. \n\n\ub2e4\uc74c \uc18d\uc131\uc744 \ubc18\ud658\ud569\ub2c8\ub2e4: \n- \ub3c4\uba54\uc778\n- \ud68c\uc0ac LinkedIn URL\n- \uac00\uc7a5 \uc800\ub834\ud55c \ud50c\ub79c\n- \ubb34\ub8cc \uccb4\ud5d8 \uc81c\uacf5 \uc5ec\ubd80\n- \uc5d4\ud130\ud504\ub77c\uc774\uc988 \ud50c\ub79c \uc81c\uacf5 \uc5ec\ubd80\n- API \uc81c\uacf5 \uc5ec\ubd80\n- \uc2dc\uc7a5 (B2B \ub610\ub294 B2C)\n\n\nn8n\uc758 \uac15\uc810\uc740 \uc774 \uc6cc\ud06c\ud50c\ub85c\ub97c \uc6d0\ud558\ub294 \uc815\ubcf4 \uc870\uc0ac\ub97c \uc704\ud574 \uc870\uc815\ud560 \uc218 \uc788\ub2e4\ub294 \uac83\uc785\ub2c8\ub2e4.\n\n\ud504\ub86c\ud504\ud2b8\uc5d0 \uba85\uc2dc\ud558\uace0, \"Structured Output Parser\" \ubaa8\ub4c8\uc5d0\uc11c \ucd9c\ub825 \ud615\uc2dd\uc744 \uba85\uc2dc\ud558\uae30\ub9cc \ud558\uba74 \ub429\ub2c8\ub2e4.\n\n[\uc5ec\uae30\uc5d0\uc11c \ub354 \uc790\uc138\ud55c \uc9c0\uce68\uacfc \ube44\ub514\uc624 \uac00\uc774\ub4dc\ub97c \ucc3e\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.](https://lempire.notion.site/AI-Web-research-with-n8n-a25aae3258d0423481a08bd102f16906)"
},
"typeVersion": 1
},
{
"id": "67d485c9-3289-4bb3-9523-cd24c0b1aa05",
"name": "Get rows to enrich",
"type": "n8n-nodes-base.googleSheets",
"position": [
1140,
340
],
"parameters": {
"options": {
"returnAllMatches": "returnAllMatches"
},
"filtersUI": {
"values": [
{
"lookupColumn": "enrichment_status"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/19U7gAgkUEz6mbFcnygf1zKDdGvY6OAdUqq3bZQWgjxE/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "19U7gAgkUEz6mbFcnygf1zKDdGvY6OAdUqq3bZQWgjxE",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/19U7gAgkUEz6mbFcnygf1zKDdGvY6OAdUqq3bZQWgjxE/edit?usp=drivesdk",
"cachedResultName": "Enrich companies using AI agents"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 4.3
},
{
"id": "eb0c95e7-2211-48d1-abaf-07cd0c76d3a6",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
1540,
227.25301102878547
],
"parameters": {
"width": 300.49399096535876,
"height": 333.8263184006576,
"content": "\ud589\uc744 \ud558\ub098\uc529 \ucc98\ub9ac \n\uc774 \ubaa8\ub4c8\uc740 \uc6b0\ub9ac\uac00 \ud589\uc744 \ud558\ub098\uc529 \ucc98\ub9ac\ud560 \uc218 \uc788\uac8c \ud574\uc904 \uac83\uc785\ub2c8\ub2e4"
},
"typeVersion": 1
},
{
"id": "8bf0deae-dda7-4e27-9ac7-978db14cca19",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
2740,
560
],
"parameters": {
"width": 300.49399096535876,
"height": 236.01118609685022,
"content": "\uc5ec\uae30\uc5d0 \ub370\uc774\ud130\ub97c \ud544\uc694\ud55c \ud615\uc2dd\uc744 \uc815\ud655\ud788 \uc9c0\uc815\ud558\uc138\uc694."
},
"typeVersion": 1
},
{
"id": "dc4f1550-1e3c-4175-a2b3-10153dc2fd77",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
2180,
200.2582716310755
],
"parameters": {
"width": 300.49399096535876,
"height": 279.8787004666023,
"content": "AI\uc5d0\uac8c \ub2f9\uc2e0\uc774 \ud68c\uc0ac\uc5d0 \ub300\ud574 \ucc3e\uace0 \uc788\ub294 \uc815\ubcf4\uac00 \ubb34\uc5c7\uc778\uc9c0 \ubb3c\uc5b4\ubcf4\uc138\uc694."
},
"typeVersion": 1
},
{
"id": "70fc73a0-303b-46e1-822d-cebdbccf8e32",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
2220,
580
],
"parameters": {
"height": 248.91749449109562,
"content": "\uc5ec\uae30\uc5d0\uc11c \ubb34\ub8cc API \ud0a4\ub97c \ubc1b\uc73c\uc138\uc694 https://serpapi.com/"
},
"typeVersion": 1
},
{
"id": "0c1dafa9-28fe-4ef4-b80e-d4034e16f6c0",
"name": "Schedule Trigger",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
920,
580
],
"parameters": {
"rule": {
"interval": [
{
"field": "hours",
"hoursInterval": 2
}
]
}
},
"typeVersion": 1.2
},
{
"id": "8b5ebee9-f519-4621-bf2a-12891794f2c5",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
820,
240
],
"parameters": {
"width": 266.12865147126786,
"height": 627.5654650079845,
"content": "\uc6cc\ud06c\ud50c\ub85c\ub97c \uc218\ub3d9\uc73c\ub85c \uc2e4\ud589\ud558\uac70\ub098 \uc774\ub97c \ud65c\uc131\ud654\ud558\uc5ec 2\uc2dc\uac04\ub9c8\ub2e4 \uc2e4\ud589\ud558\uc138\uc694."
},
"typeVersion": 1
},
{
"id": "d7db2452-ba3d-4adb-bd8b-d17a92d1bce5",
"name": "AI company researcher",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
2200,
340
],
"parameters": {
"text": "=This is the company I want you to research info about:\n{{ $json.company_input }}\n\nReturn me:\n- the linkedin URL of the company\n- the domain of the company. in this format ([domain].[tld])\n- market: if they are B2B or B2C. Only reply by \"B2B\" or \"B2B\"\n- the lowest paid plan the company is offering. If you are not sure, reply null.\n- the latest case study URL published on the website (find case study hub using google, and return the first case study link)\n- tell me if the company offer an API\n- tell me if the company has an enterprise plan\n- tell me if the company has a free trial mentionned in their homepage. reply false if you don't find strong evidence.\n- return an array with up to 5 tools the company is integrated with",
"options": {
"maxIterations": 10
},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 1.6
},
{
"id": "f7896dbd-5c15-44e9-96ca-c695a66562cc",
"name": "Search Google with ScrapingBee",
"type": "@n8n/n8n-nodes-langchain.toolWorkflow",
"position": [
2300,
1140
],
"parameters": {
"name": "search_google",
"source": "parameter",
"description": "Call this tool to get results from a google search.",
"workflowJson": "{\n \"meta\": {\n \"templateCredsSetupCompleted\": true,\n \"instanceId\": \"2b1cc1a8b0a2fb9caab11ab2d5eb3712f9973066051b2e898cf4041a1f2a7757\"\n },\n \"nodes\": [\n {\n \"parameters\": {},\n \"id\": \"fbb17d8d-e2dc-46ae-aba4-8c27cc9d8766\",\n \"name\": \"Execute Workflow Trigger\",\n \"type\": \"n8n-nodes-base.executeWorkflowTrigger\",\n \"typeVersion\": 1,\n \"position\": [\n 20,\n 460\n ]\n },\n {\n \"parameters\": {\n \"url\": \"https://app.scrapingbee.com/api/v1/store/google\",\n \"authentication\": \"genericCredentialType\",\n \"genericAuthType\": \"httpQueryAuth\",\n \"sendQuery\": true,\n \"queryParameters\": {\n \"parameters\": [\n {\n \"name\": \"search\",\n \"value\": \"={{ $json.query.google_search_query }}\"\n },\n {\n \"name\": \"language\",\n \"value\": \"en\"\n },\n {\n \"name\": \"nb_results\",\n \"value\": \"5\"\n }\n ]\n },\n \"options\": {}\n },\n \"id\": \"b938a2bd-030e-46d7-adee-4e3c85cfc1b3\",\n \"name\": \"Search Google\",\n \"type\": \"n8n-nodes-base.httpRequest\",\n \"typeVersion\": 4.2,\n \"position\": [\n 300,\n 460\n ],\n \"credentials\": {\n \"httpQueryAuth\": {\n \"id\": \"Pb2CIMT0tN838QPy\",\n \"name\": \"ScrapingBee\"\n }\n }\n },\n {\n \"parameters\": {\n \"assignments\": {\n \"assignments\": [\n {\n \"id\": \"096fee70-444e-4948-816c-752b20786062\",\n \"name\": \"response\",\n \"value\": \"={{ $json.organic_results }}\",\n \"type\": \"array\"\n }\n ]\n },\n \"options\": {}\n },\n \"id\": \"c5db1fb6-d875-47d2-97db-287777583f22\",\n \"name\": \"Response\",\n \"type\": \"n8n-nodes-base.set\",\n \"typeVersion\": 3.3,\n \"position\": [\n 520,\n 460\n ]\n }\n ],\n \"connections\": {\n \"Execute Workflow Trigger\": {\n \"main\": [\n [\n {\n \"node\": \"Search Google\",\n \"type\": \"main\",\n \"index\": 0\n }\n ]\n ]\n },\n \"Search Google\": {\n \"main\": [\n [\n {\n \"node\": \"Response\",\n \"type\": \"main\",\n \"index\": 0\n }\n ]\n ]\n }\n },\n \"pinData\": {\n \"Execute Workflow Trigger\": [\n {\n \"query\": {\n \"google_search_query\": \"site:lemlist.com pricing\"\n }\n }\n ]\n }\n}",
"jsonSchemaExample": "{\n\t\"google_search_query\": \"site:lemlist.com pricing\"\n}",
"specifyInputSchema": true
},
"typeVersion": 1.1
},
{
"id": "7a89c803-8145-49c2-aafe-ec2aff0b2fbc",
"name": "Sticky Note6",
"type": "n8n-nodes-base.stickyNote",
"position": [
2220,
940
],
"parameters": {
"height": 340.14969579315925,
"content": "SERP API \ubaa8\ub4c8 \ub300\uc2e0, ScrapingBee\uc6a9 \uc774 \ucee4\uc2a4\ud140 \ubaa8\ub4c8\uc744 \uc0ac\uc6a9\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. \uc774\uac83\uc740 \ub354 \ube44\uc6a9 \ud6a8\uc728\uc801\uc785\ub2c8\ub2e4.\n\n\uc5ec\uae30\uc5d0\uc11c \ubb34\ub8cc API \ud0a4\ub97c \ubc1b\uc73c\uc138\uc694 https://www.scrapingbee.com/"
},
"typeVersion": 1
},
{
"id": "79eff129-790b-46da-bef3-899eb6db3ced",
"name": "Sticky Note7",
"type": "n8n-nodes-base.stickyNote",
"position": [
1100,
-20
],
"parameters": {
"width": 194.6864335083109,
"height": 525.6560478822986,
"content": "\uc774 \uc6cc\ud06c\ud50c\ub85c\uc6b0\uc5d0\uc11c \uacb0\uacfc\ub97c \uc800\uc7a5\ud558\uae30 \uc704\ud574 Google Sheets\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4.\n\n\ub354 \ube60\ub974\uac8c \uc2dc\uc791\ud558\uae30 \uc704\ud574 \ub0b4 \ud15c\ud50c\ub9bf\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4:\n\n1. [\ud15c\ud50c\ub9bf\uc744 \uac00\uc838\uc624\uae30 \uc704\ud574 \uc774 \ub9c1\ud06c\ub97c \ud074\ub9ad\ud558\uc138\uc694](https://docs.google.com/spreadsheets/d/1vR6s2nlTwu01v3GP7wvSRWS5W49FJIh20ZF7AUkmMDo/edit?usp=sharing)\n2. Sheets\uc758 \ubcf5\uc0ac\ubcf8\uc744 \ub9cc\ub4dc\uc138\uc694\n3. \uc774 \ub178\ub4dc\uc640 **\"Google Sheets - \ub370\uc774\ud130\ub85c \ud589 \uc5c5\ub370\uc774\ud2b8\"** \ub178\ub4dc\uc5d0 URL\uc744 \ucd94\uac00\ud558\uc138\uc694"
},
"typeVersion": 1
}
],
"connections": {
"Input": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Merge data": {
"main": [
[
{
"node": "Google Sheets - Update Row with data",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
null,
[
{
"node": "AI company researcher",
"type": "main",
"index": 0
},
{
"node": "Merge data",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "Get rows to enrich",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Chat Model": {
"ai_languageModel": [
[
{
"node": "AI company researcher",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Get rows to enrich": {
"main": [
[
{
"node": "Input",
"type": "main",
"index": 0
}
]
]
},
"Get website content": {
"ai_tool": [
[
{
"node": "AI company researcher",
"type": "ai_tool",
"index": 0
}
]
]
},
"AI company researcher": {
"main": [
[
{
"node": "AI Researcher Output Data",
"type": "main",
"index": 0
}
]
]
},
"SerpAPI - Search Google": {
"ai_tool": [
[
{
"node": "AI company researcher",
"type": "ai_tool",
"index": 0
}
]
]
},
"Structured Output Parser": {
"ai_outputParser": [
[
{
"node": "AI company researcher",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"AI Researcher Output Data": {
"main": [
[
{
"node": "Merge data",
"type": "main",
"index": 1
}
]
]
},
"When clicking \"Test workflow\"": {
"main": [
[
{
"node": "Get rows to enrich",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets - Update Row with data": {
"main": [
[
{
"node": "Loop Over Items",
"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.
googleSheetsOAuth2ApiopenAiApiserpApi
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
2324. Uses lmChatOpenAi, toolWorkflow, toolSerpApi, outputParserStructured. Event-driven trigger; 22 nodes.
Source: https://github.com/n8nKOR/n8n-shared-workflow/blob/62a671327e906c22a40d290b339ff6d2373f8d75/workflows/n8nworkflows/sales/2324.json — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
Schedule. Uses manualTrigger, lmChatOpenAi, toolWorkflow, toolSerpApi. Event-driven trigger; 22 nodes.
OpenAI Chat, Tool Workflow, Tool Serp Api +3
Schedule. Uses manualTrigger, lmChatOpenAi, toolWorkflow, toolSerpApi. Event-driven trigger; 22 nodes.
OpenAI Chat, Tool Workflow, Tool Serp Api +3
This workflow is for all sales reps and lead generation manager who need to prepare their prospecting activities, and find relevant information to personalize their outreach.
OpenAI Chat, Tool Workflow, Tool Serp Api +3
Supercharge your sales and marketing with this AI-powered workflow! 🚀 Stop wasting hours on manual company research. This template deploys an autonomous AI agent that takes a list of company names fro
OpenAI Chat, Tool Workflow, Tool Serp Api +3
29-ai-researcher-for-sales. Uses lmChatOpenAi, toolWorkflow, toolSerpApi, outputParserStructured. Event-driven trigger; 21 nodes.
OpenAI Chat, Tool Workflow, Tool Serp Api +3