Polina Medvedieva This workflow corresponds to n8n.io template #2945 — 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": {
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "53e93a66-468a-4df8-b2cb-58ff0563f83f",
"name": "When clicking \u2018Test workflow\u2019",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-160,
0
],
"parameters": {},
"typeVersion": 1
},
{
"id": "70692fd5-d575-49d2-9e3c-71bdddb0782e",
"name": "AI Agent",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
1000,
0
],
"parameters": {
"text": "=keyword: {{ $json.Keyword }}",
"options": {
"systemMessage": "=Check the keyword I provided and define if this keyword has a name of the known IT software, service, tool or app as a part of it (for example, ServiceNow or Salesforce) and return yes or no."
},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 1.7
},
{
"id": "587e6283-32c0-4599-a024-2ce0079bdaeb",
"name": "OpenAI Chat Model",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
1000,
240
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4o-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"name": "<your credential>"
}
},
"typeVersion": 1.2
},
{
"id": "0e3e7d09-202e-47cc-8704-16ab70bc4077",
"name": "Structured Output Parser",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
1180,
240
],
"parameters": {
"jsonSchemaExample": "{\n\t\"Isservice\": \"yes\"\n}"
},
"typeVersion": 1.2
},
{
"id": "900ac097-c6de-41c0-8270-c9de60424d5f",
"name": "Fetch Keywords from Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
120,
0
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1319606837,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1jzDvszQoVDV-jrAunCXqTVsiDxXVLMGqQ1zGXwfy5eU/edit#gid=1319606837",
"cachedResultName": "Copy of Sheet1 1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1jzDvszQoVDV-jrAunCXqTVsiDxXVLMGqQ1zGXwfy5eU",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1jzDvszQoVDV-jrAunCXqTVsiDxXVLMGqQ1zGXwfy5eU/edit?usp=drivesdk",
"cachedResultName": "AI + agents"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 4.5
},
{
"id": "73e208d1-e8d8-4c8b-90f3-06202ed73986",
"name": "Process Keywords in Batches",
"type": "n8n-nodes-base.splitInBatches",
"position": [
440,
0
],
"parameters": {
"options": {},
"batchSize": 6
},
"typeVersion": 3
},
{
"id": "93646bfc-b79d-4ec3-ba8d-8922773fd36b",
"name": "Prevent API Rate Limiting",
"type": "n8n-nodes-base.wait",
"position": [
720,
0
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "313474f7-a53d-479c-a33e-9327ca29e570",
"name": "Update Sheet with Analysis Results",
"type": "n8n-nodes-base.googleSheets",
"position": [
1360,
0
],
"parameters": {
"columns": {
"value": {
"Number": "={{ $('Process Keywords in Batches').item.json.Number }}",
"Service?": "={{ $json.output.Isservice }}"
},
"schema": [
{
"id": "Number",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Number",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Service?",
"type": "string",
"display": true,
"required": false,
"displayName": "Service?",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Keyword",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Country",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Country",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Difficulty",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Difficulty",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Volume",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Volume",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "CPC",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "CPC",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "CPS",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "CPS",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Parent Keyword",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Parent Keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Last Update",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Last Update",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "SERP Features",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "SERP Features",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Global volume",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Global volume",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Traffic potential",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Traffic potential",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Global traffic potential",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Global traffic potential",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "First seen",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "First seen",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Intents",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Intents",
"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": [
"Number"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1319606837,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1jzDvszQoVDV-jrAunCXqTVsiDxXVLMGqQ1zGXwfy5eU/edit#gid=1319606837",
"cachedResultName": "Copy of Sheet1 1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1jzDvszQoVDV-jrAunCXqTVsiDxXVLMGqQ1zGXwfy5eU",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1jzDvszQoVDV-jrAunCXqTVsiDxXVLMGqQ1zGXwfy5eU/edit?usp=drivesdk",
"cachedResultName": "AI + agents"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 4.5
}
],
"connections": {
"AI Agent": {
"main": [
[
{
"node": "Update Sheet with Analysis Results",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Chat Model": {
"ai_languageModel": [
[
{
"node": "AI Agent",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Structured Output Parser": {
"ai_outputParser": [
[
{
"node": "AI Agent",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Fetch Keywords from Sheet": {
"main": [
[
{
"node": "Process Keywords in Batches",
"type": "main",
"index": 0
}
]
]
},
"Prevent API Rate Limiting": {
"main": [
[
{
"node": "AI Agent",
"type": "main",
"index": 0
}
]
]
},
"Process Keywords in Batches": {
"main": [
[],
[
{
"node": "Prevent API Rate Limiting",
"type": "main",
"index": 0
}
]
]
},
"When clicking \u2018Test workflow\u2019": {
"main": [
[
{
"node": "Fetch Keywords from Sheet",
"type": "main",
"index": 0
}
]
]
},
"Update Sheet with Analysis Results": {
"main": [
[
{
"node": "Process Keywords in Batches",
"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.
googleSheetsOAuth2ApiopenAiApi
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
This template is for marketers, SEO specialists, or content managers who need to analyze keywords to identify which ones contain references to a specific area or topic, in this case – IT software, services, tools, or apps.
Source: https://n8n.io/workflows/2945/ — 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.
🎯 Create viral TikToks, Shorts, Reels, podcasts, and ASMR videos in minutes — all on autopilot.
OpenAI, HTTP Request, Form Trigger +7
Generate AI viral videos with NanoBanana & VEO3, shared on socials via Blotato 2. Uses @blotato/n8n-nodes-blotato, googleSheets, lmChatOpenAi, toolThink. Event-driven trigger; 94 nodes.
@Blotato/N8N Nodes Blotato, Google Sheets, OpenAI Chat +9
This template is designed for marketers, content creators, and e-commerce brands who want to automate the creation of professional ad videos at scale. It’s ideal for teams looking to generate consiste
Telegram, Telegram Trigger, Google Drive +8
Digistars - Scrape & Crawl. Uses httpRequest, n8n-nodes-firecrawl-scraper, googleSheets, lmChatOpenAi. Event-driven trigger; 63 nodes.
HTTP Request, N8N Nodes Firecrawl Scraper, Google Sheets +5
This comprehensive n8n workflow automates the entire Meta (Facebook/Instagram) advertising process, from asset analysis to ad creation. It combines AI-powered content analysis with automated ad deploy
Facebook Graph Api, HTTP Request, Google Drive +5