This workflow follows the Google Sheets → OpenAI 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 →
{
"name": "Lead Scoring",
"nodes": [
{
"parameters": {
"documentId": {
"__rl": true,
"mode": "list",
"value": "19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs/edit?usp=drivesdk",
"cachedResultName": "HDW_OutReach"
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs/edit#gid=0",
"cachedResultName": "Sheet1"
},
"options": {}
},
"id": "b577f14d-5158-451b-ab90-7ef46d17e7ca",
"name": "Google Sheets11",
"type": "n8n-nodes-base.googleSheets",
"position": [
368,
112
],
"executeOnce": true,
"retryOnFail": true,
"typeVersion": 4.5,
"waitBetweenTries": 5000
},
{
"parameters": {
"options": {
"reset": false
}
},
"id": "f23c21ea-baf8-4ecc-aef7-d1e8f10819aa",
"name": "Loop Over Items6",
"type": "n8n-nodes-base.splitInBatches",
"position": [
896,
-48
],
"retryOnFail": true,
"typeVersion": 3
},
{
"parameters": {
"operation": "update",
"documentId": {
"__rl": true,
"mode": "list",
"value": "19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs/edit?usp=drivesdk",
"cachedResultName": "HDW_OutReach"
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs/edit#gid=0",
"cachedResultName": "Sheet1"
},
"columns": {
"value": {
"URN": "={{ $('Google Sheets11').item.json.URN }}",
"Lead Score": "={{ $json.message.content }}"
},
"schema": [
{
"id": "Name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "URN",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "URN",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "URL",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "img",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "img",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Headline",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Headline",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "location",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "location",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is premium",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "is premium",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Current company",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Current company",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Company URN",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Company URN",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "URL",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Industry",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Industry",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Position",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Position",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Description",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Description",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Date",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Website",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Website",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Posts summary",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Posts summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Product Summary",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Product Summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Company News",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Company News",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Company post summary",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Company post summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Lead Score",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Lead Score",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"URN"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"id": "7e088eb5-92c6-4789-9355-dc11b093f311",
"name": "Google Sheets12",
"type": "n8n-nodes-base.googleSheets",
"position": [
1584,
144
],
"retryOnFail": true,
"typeVersion": 4.5,
"onError": "continueRegularOutput"
},
{
"parameters": {
"content": "You can also change the scoring criteria to assess the probability of need based on your product or business by adjusting the prompt in this node",
"height": 100,
"width": 360,
"color": 5
},
"id": "8227620c-a6d1-41b8-b3ac-5d3520f06a9a",
"name": "Sticky Note16",
"type": "n8n-nodes-base.stickyNote",
"position": [
1152,
16
],
"typeVersion": 1
},
{
"parameters": {
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "loose"
},
"combinator": "or",
"conditions": [
{
"id": "140d284f-34c0-4bf4-bb88-b0a9bdbc80f7",
"operator": {
"type": "string",
"operation": "empty",
"singleValue": true
},
"leftValue": "={{ $json[\"Lead Score\"] }}",
"rightValue": ""
}
]
},
"looseTypeValidation": true,
"options": {}
},
"id": "3158bbb0-ad27-4478-88ce-935e8046a68f",
"name": "Lead Score is empty",
"type": "n8n-nodes-base.if",
"position": [
624,
112
],
"typeVersion": 2.2
},
{
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "gpt-4o",
"cachedResultName": "GPT-4O"
},
"messages": {
"values": [
{
"content": "You are an expert in evaluating lead potential for our product.\nAnalyze the company\u2019s and lead\u2019s profile content, assessing their likelihood of interest in our product on a scale from 1 to 10 (where 1 indicates minimal potential, and 10 indicates maximum potential).\n\nKey evaluation criteria:\n\t\u2022\tMentions of Hotels suppliers \n\t\u2022\tMentions of Hotel Services\n\nEvaluation scale:\n\t\u2022\t8\u201310 points: Clear mentions of both criteria, active engagement, and explicit interest.\n\t\u2022\t5\u20137 points: Mention of one criterion or indirect indicators of interest in both criteria.\n\t\u2022\t1\u20134 points: No clear mentions, or only weak indirect indicators of interest.\n\nYour answer must ONLY be a single number from 1 to 10, without any additional text.",
"role": "system"
},
{
"content": "=Lead posts summary:\n {{ $json[\"Posts summary\"] }}\nLead company website analysis:\n{{ $('Google Sheets11').item.json['Product Summary'] }}\n\nCompany news summary:\n{{ $('Google Sheets11').item.json['Company News'] }}\nCompany posts summary\n{{ $('Google Sheets11').item.json['Company post summary'] }}\nCompany descriptin\n{{ $json.Description }}"
}
]
},
"options": {}
},
"id": "9654350e-ca26-40f4-ad65-0175c4c7a514",
"name": "Company Score Analysis",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
1216,
144
],
"retryOnFail": true,
"typeVersion": 1.8,
"onError": "continueRegularOutput"
}
],
"connections": {
"Google Sheets11": {
"main": [
[
{
"node": "Lead Score is empty",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items6": {
"main": [
[],
[
{
"node": "Company Score Analysis",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets12": {
"main": [
[
{
"node": "Loop Over Items6",
"type": "main",
"index": 0
}
]
]
},
"Lead Score is empty": {
"main": [
[
{
"node": "Loop Over Items6",
"type": "main",
"index": 0
}
]
]
},
"Company Score Analysis": {
"main": [
[
{
"node": "Google Sheets12",
"type": "main",
"index": 0
}
]
]
}
},
"active": false,
"settings": {
"executionOrder": "v1",
"availableInMCP": false
},
"versionId": "9d6d3d5d-8380-4a2d-8c00-d4e56e62fc5b",
"meta": {
"templateCredsSetupCompleted": true
},
"id": "VLXIWrJhh23e4TmF",
"tags": []
}
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Lead Scoring. Uses googleSheets, openAi. Manual trigger; 6 nodes.
Source: https://github.com/anshwysmcbel2710/ai-linkedin-lead-generation-machine/blob/main/workflows/04-lead-scoring.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.
Content Intelligence. Uses googleSheets, n8n-nodes-hdw, openAi. Manual trigger; 29 nodes.
Google Sheets, N8N Nodes Hdw, OpenAI
Use cases are many: Perfect for freelancers managing client invoices, small businesses handling supplier bills, accounting departments processing high invoice volumes, or anyone who wants to eliminate
OpenAI, Google Drive, Google Sheets +3
Supercharge your sales and marketing efforts with this powerful automation that transforms a list of LinkedIn profiles into a fully enriched, personalized outreach campaign. This workflow is designed
HTTP Request, OpenAI, Google Sheets
AI Reel Factory - RSS Feed Monitor. Uses rssFeedRead, openAi, googleSheets. Manual trigger; 6 nodes.
RSS Feed Read, OpenAI, Google Sheets
Openai Twitter. Uses googleSheets, openAi, twitter. Manual trigger; 5 nodes.
Google Sheets, OpenAI, Twitter