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": "Row lookup",
"nodes": [
{
"parameters": {
"workflowInputs": {
"values": [
{
"name": "query_column"
},
{
"name": "query_value"
}
]
}
},
"type": "n8n-nodes-base.executeWorkflowTrigger",
"typeVersion": 1.1,
"position": [
0,
0
],
"id": "0df84540-7343-4f59-a341-baaf8f405ea4",
"name": "When Executed by Another Workflow"
},
{
"parameters": {
"documentId": {
"__rl": true,
"value": "13psI0SoLbp8zJDxSmUfkgtyVIa_EvljZFHEWwLiOgmU",
"mode": "list",
"cachedResultName": "Volunteer-Index",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/13psI0SoLbp8zJDxSmUfkgtyVIa_EvljZFHEWwLiOgmU/edit?usp=drivesdk"
},
"sheetName": {
"__rl": true,
"value": "gid=0",
"mode": "list",
"cachedResultName": "Full",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/13psI0SoLbp8zJDxSmUfkgtyVIa_EvljZFHEWwLiOgmU/edit#gid=0"
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.6,
"position": [
220,
0
],
"id": "fd1e9b16-78e5-4720-854d-d34981adcbad",
"name": "Google Sheets",
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "1b6a13ef-48bf-4d37-918f-39a85392b425",
"leftValue": "={{ $json[$('When Executed by Another Workflow').item.json.query_column] }}",
"rightValue": "={{ $('When Executed by Another Workflow').item.json.query_value }}",
"operator": {
"type": "string",
"operation": "contains"
}
}
],
"combinator": "and"
},
"options": {}
},
"type": "n8n-nodes-base.filter",
"typeVersion": 2.2,
"position": [
440,
0
],
"id": "005d0a66-061f-460f-8bcd-d4dbe38f46ac",
"name": "Filter"
}
],
"connections": {
"When Executed by Another Workflow": {
"main": [
[
{
"node": "Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets": {
"main": [
[
{
"node": "Filter",
"type": "main",
"index": 0
}
]
]
}
},
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "880a9989-5288-4751-a45c-def0c3009973",
"meta": {
"templateCredsSetupCompleted": true
},
"id": "caxeA1kyx6lszkaN",
"tags": []
}
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.
googleSheetsOAuth2Api
About this workflow
Row lookup. Uses executeWorkflowTrigger, googleSheets. Event-driven trigger; 3 nodes.
Source: https://github.com/LinkedInLearning/build-ai-agents-and-automate-workflows-with-n8n-5437042/blob/3daaa2e098f567839966797c672cde9a8865d9e2/n8n-workflows/Row_lookup.json — original creator credit. Request a take-down →