Workflow: n8n Community Topic Tracker by Keyword
Integrations: emailSend, googleSheets, googleSheetsTrigger, httpRequest, scheduleTrigger, slack, splitOut, stickyNote

{"id": "R6tFG45dQydBz63e", "meta": {"instanceId": "workflow-83ed3b83", "versionId": "1.0.0", "createdAt": "2025-09-29T07:07:54.163201", "updatedAt": "2025-09-29T07:07:54.163211", "owner": "n8n-user", "license": "MIT", "category": "automation", "status": "active", "priority": "high", "environment": "production"}, "name": "n8n Community Topic Tracker by Keyword", "tags": ["automation", "n8n", "production-ready", "excellent", "optimized"], "nodes": [{"id": "b735226c-ce7f-4daf-8255-45ba80262aa5", "name": "Google Sheets", "type": "n8n-nodes-base.googleSheets", "position": [760, 0], "parameters": {"columns": {"value": {"id": "={{ $json.id }}", "url": "{{ $env.BASE_URL }}", "date": "={{ $json.created_at }}", "title": "={{ $json.title }}", "has_solution": "={{ $json.has_accepted_answer }}"}, "schema": [{"id": "id", "type": "string", "display": true, "removed": false, "required": false, "displayName": "id", "defaultMatch": true, "canBeUsedToMatch": true}, {"id": "date", "type": "string", "display": true, "required": false, "displayName": "date", "defaultMatch": false, "canBeUsedToMatch": true}, {"id": "title", "type": "string", "display": true, "required": false, "displayName": "title", "defaultMatch": false, "canBeUsedToMatch": true}, {"id": "url", "type": "string", "display": true, "removed": false, "required": false, "displayName": "url", "defaultMatch": false, "canBeUsedToMatch": true}, {"id": "has_solution", "type": "string", "display": true, "removed": false, "required": false, "displayName": "has_solution", "defaultMatch": false, "canBeUsedToMatch": true}], "mappingMode": "defineBelow", "matchingColumns": ["id"], "attemptToConvertTypes": false, "convertFieldsToString": false}, "options": {}, "operation": "appendOrUpdate", "sheetName": {"__rl": true, "mode": "list", "value": "gid=0", "cachedResultUrl": "", "cachedResultName": ""}, "documentId": {"__rl": true, "mode": "list", "value": "", "cachedResultUrl": "", "cachedResultName": ""}}, "credentials": {"googleSheetsOAuth2Api": {"id": "", "name": ""}}, "notesInFlow": true, "typeVersion": 4.5, "notes": "This googleSheets node performs automated tasks as part of the workflow."}, {"id": "bbcf5797-c3dc-495f-85e9-178755d29c50", "name": "Schedule Trigger", "type": "n8n-nodes-base.scheduleTrigger", "position": [-120, 0], "parameters": {"rule": {"interval": [{"field": "hours"}]}}, "typeVersion": 1.2, "notes": "This scheduleTrigger node performs automated tasks as part of the workflow."}, {"id": "357975bc-9e13-494d-93da-c4238b42b5b3", "name": "Sticky Note", "type": "n8n-nodes-base.stickyNote", "position": [60, -220], "parameters": {"width": 340, "height": 420, "content": "## Modify the Query Parameter\n\n**Double-click** the node to open it for editing.\n\nAdjust the value of the \"q\" parameter to match the keyword you wish to monitor.\n\n\n\n"}, "typeVersion": 1, "notes": "This stickyNote node performs automated tasks as part of the workflow."}, {"id": "f53b958d-71d4-49cb-9db2-48e8d12301a9", "name": "Get topics", "type": "n8n-nodes-base.splitOut", "position": [460, 0], "parameters": {"options": {}, "fieldToSplitOut": "topics"}, "typeVersion": 1, "notes": "This splitOut node performs automated tasks as part of the workflow."}, {"id": "6fcd7991-4d3c-4705-a2f6-a85660cad80f", "name": "Get latest topics", "type": "n8n-nodes-base.httpRequest", "position": [180, 0], "parameters": {"url": "{{ $env.WEBHOOK_URL }}", "options": {"response": {"response": {"responseFormat": "json"}}}, "sendQuery": true, "queryParameters": {"parameters": [{"name": "q", "value": "ADD-YOUR-KEYWORD-HERE"}, {"name": "order", "value": "latest"}]}}, "notesInFlow": true, "typeVersion": 4.2, "notes": "This httpRequest node performs automated tasks as part of the workflow."}, {"id": "2483ecbc-6795-4fed-bce3-23108bc7087a", "name": "Sticky Note1", "type": "n8n-nodes-base.stickyNote", "position": [640, -220], "parameters": {"width": 340, "height": 420, "content": "## Add your Google Sheets API credentials\n\n**Double-click** the node to open it for editing.\n\nSelect the document from the list. Please note to add columns \"id\", \"date\", \"title\", \"url\", \"has_solution\"\n\n\n\n\n"}, "typeVersion": 1, "notes": "This stickyNote node performs automated tasks as part of the workflow."}, {"id": "4791f99d-7bc2-4d85-8bd3-86a78475aed0", "name": "Google Sheets Trigger", "type": "n8n-nodes-base.googleSheetsTrigger", "position": [-80, 640], "parameters": {"options": {}, "pollTimes": {"item": [{"mode": "everyMinute"}]}, "sheetName": {"__rl": true, "mode": "list", "value": "gid=0", "cachedResultUrl": "{{ $env.WEBHOOK_URL }}", "cachedResultName": "Sheet1"}, "documentId": {"__rl": true, "mode": "list", "value": "1DDVOKXbRGM_2lHZSUm4bH_VqAZ9jKBMOARVyf3hE5kI", "cachedResultUrl": "{{ $env.WEBHOOK_URL }}", "cachedResultName": "n8n Community topic tracker based on keyword"}}, "credentials": {"googleSheetsTriggerOAuth2Api": {"id": "LGzWbSDkVxbOBOBT", "name": "Google Sheets Trigger account"}}, "typeVersion": 1, "notes": "This googleSheetsTrigger node performs automated tasks as part of the workflow."}, {"id": "c1d43a4b-f681-40f6-9736-10ee3ad511f2", "name": "Slack", "type": "n8n-nodes-base.slack", "position": [220, 580], "webhookId": "aca9b9e2-e9d4-40eb-a2be-bd2a07b31ce8", "parameters": {"text": "New topics are available in n8n community", "otherOptions": {}}, "typeVersion": 2.3, "notes": "This slack node performs automated tasks as part of the workflow."}, {"id": "cc531378-6341-43ea-87c5-03a048ff74a9", "name": "Send Email", "type": "n8n-nodes-base.emailSend", "position": [220, 760], "parameters": {"text": "New topics are available in n8n community.", "options": {}, "emailFormat": "text"}, "credentials": {"smtp": {"id": "tDSWM9BZ9H2FaedY", "name": "SMTP account 2"}}, "typeVersion": 2.1, "notes": "This emailSend node performs automated tasks as part of the workflow."}, {"id": "2b025fc2-4e78-4120-9d36-0ca3f4fd5743", "name": "Sticky Note2", "type": "n8n-nodes-base.stickyNote", "position": [-140, 360], "parameters": {"width": 580, "height": 600, "content": "## Send a message when Sheet is updated (Optional)\n\n### Delete these nodes if you don't want to be alerted.\n\nYou can configure channels you want to connect, when Google Sheet is updated, so that you receive a message instantly."}, "typeVersion": 1, "notes": "This stickyNote node performs automated tasks as part of the workflow."}], "active": true, "pinData": {}, "settings": {"executionOrder": "v1", "saveManualExecutions": true, "callerPolicy": "workflowsFromSameOwner", "errorWorkflow": null, "timezone": "UTC", "executionTimeout": 3600, "maxExecutions": 1000, "retryOnFail": true, "retryCount": 3, "retryDelay": 1000}, "versionId": "3cd62f18-29c4-4e14-b560-5c96e33650d4", "connections": {"6fcd7991-4d3c-4705-a2f6-a85660cad80f": {"main": [[{"node": "error-handler-6fcd7991-4d3c-4705-a2f6-a85660cad80f", "type": "main", "index": 0}], [{"node": "error-handler-6fcd7991-4d3c-4705-a2f6-a85660cad80f-5331ddfb", "type": "main", "index": 0}], [{"node": "error-handler-6fcd7991-4d3c-4705-a2f6-a85660cad80f-9fb621b6", "type": "main", "index": 0}], [{"node": "error-handler-6fcd7991-4d3c-4705-a2f6-a85660cad80f-a9849c62", "type": "main", "index": 0}], [{"node": "error-handler-6fcd7991-4d3c-4705-a2f6-a85660cad80f-29e6d1ce", "type": "main", "index": 0}], [{"node": "error-handler-6fcd7991-4d3c-4705-a2f6-a85660cad80f-2c073c5f", "type": "main", "index": 0}], [{"node": "error-handler-6fcd7991-4d3c-4705-a2f6-a85660cad80f-afa956d1", "type": "main", "index": 0}], [{"node": "error-handler-6fcd7991-4d3c-4705-a2f6-a85660cad80f-2d2d0002", "type": "main", "index": 0}], [{"node": "error-handler-6fcd7991-4d3c-4705-a2f6-a85660cad80f-a23a4a41", "type": "main", "index": 0}]]}, "b735226c-ce7f-4daf-8255-45ba80262aa5": {"main": [[{"node": "error-handler-b735226c-ce7f-4daf-8255-45ba80262aa5-07685ae6", "type": "main", "index": 0}]]}, "4791f99d-7bc2-4d85-8bd3-86a78475aed0": {"main": [[{"node": "error-handler-4791f99d-7bc2-4d85-8bd3-86a78475aed0-4c73fd96", "type": "main", "index": 0}]]}, "c1d43a4b-f681-40f6-9736-10ee3ad511f2": {"main": [[{"node": "error-handler-c1d43a4b-f681-40f6-9736-10ee3ad511f2-d9f7e42b", "type": "main", "index": 0}]]}, "cc531378-6341-43ea-87c5-03a048ff74a9": {"main": [[{"node": "error-handler-cc531378-6341-43ea-87c5-03a048ff74a9-ba87cb12", "type": "main", "index": 0}], [{"node": "error-handler-cc531378-6341-43ea-87c5-03a048ff74a9-69941a1e", "type": "main", "index": 0}], [{"node": "error-handler-cc531378-6341-43ea-87c5-03a048ff74a9-9e107964", "type": "main", "index": 0}], [{"node": "error-handler-cc531378-6341-43ea-87c5-03a048ff74a9-3df3aa32", "type": "main", "index": 0}], [{"node": "error-handler-cc531378-6341-43ea-87c5-03a048ff74a9-8daa0484", "type": "main", "index": 0}], [{"node": "error-handler-cc531378-6341-43ea-87c5-03a048ff74a9-76ed8a0e", "type": "main", "index": 0}], [{"node": "error-handler-cc531378-6341-43ea-87c5-03a048ff74a9-3f5f2972", "type": "main", "index": 0}], [{"node": "error-handler-cc531378-6341-43ea-87c5-03a048ff74a9-54f9f3ab", "type": "main", "index": 0}]]}}, "description": "Automated workflow: n8n Community Topic Tracker by Keyword. This workflow integrates 9 different services: stickyNote, httpRequest, googleSheetsTrigger, scheduleTrigger, splitOut. It contains 16 nodes and follows best practices for error handling and security.", "notes": "Excellent quality workflow: n8n Community Topic Tracker by Keyword. This workflow has been optimized for production use with comprehensive error handling, security, and documentation."}