temp
描述
分类
📢 Marketing
使用的节点
n8n-nodes-base.setn8n-nodes-base.setn8n-nodes-base.mergen8n-nodes-base.twittern8n-nodes-base.airtablen8n-nodes-base.airtablen8n-nodes-base.stickyNoten8n-nodes-base.scheduleTrigger
价格免费
浏览量0
最后更新11/28/2025
workflow.json
{
"id": "lPYVaz2xbN5zFDIL",
"meta": {
"instanceId": "cbc68f6c587084f6fe53914a07ed22d475640cb7a6f4ade193e6f0c6d7a06ce8",
"templateCredsSetupCompleted": true
},
"name": "temp",
"tags": [
{
"id": "DaQLpYItTEM2y8Gt",
"name": "Product",
"createdAt": "2025-06-17T10:48:17.486Z",
"updatedAt": "2025-06-17T10:48:17.486Z"
},
{
"id": "6X5c5WbCRWtxJbl2",
"name": "AI",
"createdAt": "2025-06-17T10:48:17.367Z",
"updatedAt": "2025-06-17T10:48:17.367Z"
},
{
"id": "ycHNTMiM8vy98zu1",
"name": "Building blocks",
"createdAt": "2025-06-17T10:48:17.563Z",
"updatedAt": "2025-06-17T10:48:17.563Z"
},
{
"id": "UJ6au0mv063gOupq",
"name": "Finance",
"createdAt": "2025-06-17T10:48:17.583Z",
"updatedAt": "2025-06-17T10:48:17.583Z"
},
{
"id": "CaWiGPzJpyfUHdxp",
"name": "IT Ops",
"createdAt": "2025-06-17T10:48:17.388Z",
"updatedAt": "2025-06-17T10:48:17.388Z"
},
{
"id": "6Uolue5XigSZ2IYx",
"name": "OpenAI",
"createdAt": "2025-06-17T10:48:17.508Z",
"updatedAt": "2025-06-17T10:48:17.508Z"
},
{
"id": "nA8GpDM4XoG5aJ0A",
"name": "Marketing",
"createdAt": "2025-06-17T10:48:17.532Z",
"updatedAt": "2025-06-17T10:48:17.532Z"
},
{
"id": "J4gTJX9lSPm3wByF",
"name": "Support",
"createdAt": "2025-06-17T10:48:17.464Z",
"updatedAt": "2025-06-17T10:48:17.464Z"
},
{
"id": "i294x7TPtUQgJkmv",
"name": "HR",
"createdAt": "2025-06-17T10:48:17.426Z",
"updatedAt": "2025-06-17T10:48:17.426Z"
}
],
"nodes": [
{
"id": "e061d33b-2f23-4cf3-9573-5c4d99950f90",
"name": "Twitter",
"type": "n8n-nodes-base.twitter",
"position": [
380,
0
],
"parameters": {
"limit": 100,
"operation": "search",
"searchText": "Narendra Modi",
"additionalFields": {
"resultType": "mixed"
}
},
"typeVersion": 1
},
{
"id": "d83d3421-a750-455b-9414-b1eacf042544",
"name": "Set_AT_list",
"type": "n8n-nodes-base.set",
"position": [
600,
200
],
"parameters": {
"values": {
"number": [
{
"name": "Likes",
"value": "={{$node[\"Twitter\"].json[\"favorite_count\"] ? $node[\"Twitter\"].json[\"favorite_count\"] : 0 }}"
}
],
"string": [
{
"name": "Tweet",
"value": "={{$node[\"get airtable list\"].json[\"fields\"][\"Tweet\"]}}"
},
{
"name": "Tweet_id",
"value": "={{$node[\"get airtable list\"].json[\"fields\"][\"Tweet_id\"]}}"
},
{
"name": "Tweet URL",
"value": "={{$node[\"get airtable list\"].json[\"fields\"][\"Tweet URL\"]}}"
},
{
"name": "Author",
"value": "={{$node[\"get airtable list\"].json[\"fields\"][\"Author\"]}}"
},
{
"name": "Time",
"value": "={{$node[\"get airtable list\"].json[\"fields\"][\"Time\"]}}"
}
]
},
"options": {
"dotNotation": false
},
"keepOnlySet": true
},
"typeVersion": 1
},
{
"id": "878b07b3-322c-4a41-bc4f-28f47a62afe2",
"name": "get airtable list",
"type": "n8n-nodes-base.airtable",
"position": [
380,
200
],
"parameters": {
"table": "tbl6rexxFBodzKVoC",
"operation": "list",
"application": "app36P08S3Jzki6qJ",
"additionalOptions": {}
},
"typeVersion": 1
},
{
"id": "9f893824-aad9-44c1-9da2-136959ac09fd",
"name": "set twitter data",
"type": "n8n-nodes-base.set",
"position": [
600,
0
],
"parameters": {
"values": {
"number": [
{
"name": "Likes",
"value": "={{$node[\"Twitter\"].json[\"favorite_count\"]}}"
}
],
"string": [
{
"name": "Tweet",
"value": "={{$node[\"Twitter\"].json[\"text\"]}}"
},
{
"name": "Tweet_id",
"value": "={{$node[\"Twitter\"].json[\"id\"]}}"
},
{
"name": "Tweet URL",
"value": "=https://twitter.com/{{$node[\"Twitter\"].json[\"user\"][\"screen_name\"]}}/status/{{$node[\"Twitter\"].json[\"id_str\"]}}"
},
{
"name": "Author",
"value": "={{$node[\"Twitter\"].json[\"in_reply_to_screen_name\"]}}"
},
{
"name": "Time",
"value": "={{$node[\"Twitter\"].json[\"created_at\"]}}"
}
]
},
"options": {
"dotNotation": false
},
"keepOnlySet": true
},
"typeVersion": 1
},
{
"id": "2aee3941-6e08-4893-806e-52b1cd963e68",
"name": "Leave only new tweets",
"type": "n8n-nodes-base.merge",
"position": [
820,
100
],
"parameters": {
"mode": "removeKeyMatches",
"propertyName1": "Tweet_id",
"propertyName2": "Tweet_id"
},
"typeVersion": 1
},
{
"id": "86cd15e4-621f-48c6-90a8-c4bdf136b75c",
"name": "Append new tweets to airtable",
"type": "n8n-nodes-base.airtable",
"position": [
1040,
100
],
"parameters": {
"table": "tbl6rexxFBodzKVoC",
"options": {},
"operation": "append",
"application": "app36P08S3Jzki6qJ",
"addAllFields": "={{true}}"
},
"typeVersion": 1
},
{
"id": "edfafc16-bd4a-49d8-bf08-8ed4638fc00b",
"name": "8 AM",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
160,
100
],
"parameters": {
"rule": {
"interval": [
{
"triggerAtHour": 8
}
]
}
},
"typeVersion": 1.2
},
{
"id": "1fb69414-d14b-42a4-8078-fd69fed9d28d",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-420,
-420
],
"parameters": {
"width": 1800,
"height": 1060,
"content": "# 🐦 Twitter to Airtable Archiver\n\n**Automatically archive fresh tweets about \"Narendra Modi\" to Airtable, eliminating duplicates.**\n\n## ⏰ Daily Automation\n- **Runs**: Every day at 8 AM (via Schedule Trigger)\n- **Searches**: Latest 100 tweets containing \"Narendra Modi\"\n\n## 🔄 Workflow Steps\n1. **Fetch Tweets** \n - Retrieve up to 100 tweets using Twitter API\n - Fields collected: \n 📝 Text | ❤️ Likes | 🆔 ID | 🔗 URL | 👤 Author | 📅 Timestamp\n\n2. **Reformat Data** \n - Structure tweet data for Airtable compatibility\n\n3. **Check Existing Records** \n - Fetch current records from Airtable table\n - Compare using Tweet IDs\n\n4. **Filter Duplicates** \n - Remove tweets already in Airtable\n\n5. **Append New Tweets** \n - Add only brand-new entries to your base\n\n## ✨ Key Features\n- **Zero Duplicates**: Intelligent ID matching\n- **Always Fresh**: Daily updates with latest content\n- **Complete Context**: Full tweet metadata preserved\n- **Effortless Archiving**: Fully automated pipeline\n\n## 🛠️ Perfect For\n- Political analysts tracking mentions\n- Researchers monitoring public sentiment\n- Journalists following trending topics\n- Archivists preserving digital content\n\n> **Pro Tip**: Change the search term to monitor any topic - politicians, brands, or trends!"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "dd98aabf-f750-41cb-8e26-b2196e794bcc",
"connections": {
"8 AM": {
"main": [
[
{
"node": "Twitter",
"type": "main",
"index": 0
},
{
"node": "get airtable list",
"type": "main",
"index": 0
}
]
]
},
"Twitter": {
"main": [
[
{
"node": "set twitter data",
"type": "main",
"index": 0
}
]
]
},
"Set_AT_list": {
"main": [
[
{
"node": "Leave only new tweets",
"type": "main",
"index": 1
}
]
]
},
"set twitter data": {
"main": [
[
{
"node": "Leave only new tweets",
"type": "main",
"index": 0
}
]
]
},
"get airtable list": {
"main": [
[
{
"node": "Set_AT_list",
"type": "main",
"index": 0
}
]
]
},
"Leave only new tweets": {
"main": [
[
{
"node": "Append new tweets to airtable",
"type": "main",
"index": 0
}
]
]
}
}
}