从 Google Sheets 自动点赞和转发 X 账号
中级
这是一个自动化工作流，包含 13 个节点。主要使用 Limit, Twitter, GoogleSheets, ScheduleTrigger 等节点。 X 和 Google Sheets 服务的定时自动化
前置要求
- •Twitter API 凭证
- •Google Sheets API 凭证
分类
-
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "pPwYYgTXLQzH7fv4",
"meta": {
"instanceId": "15d6057a37b8367f33882dd60593ee5f6cc0c59310ff1dc66b626d726083b48d"
},
"name": "从 Google Sheets 自动点赞和转发 X 账号",
"tags": [],
"nodes": [
{
"id": "ef981efc-4d09-4e0d-9af4-a1db3cacc819",
"name": "定时触发器",
"type": "n8n-nodes-base.scheduleTrigger",
"notes": "Role: Automatic start on a schedule (hourly/daily). Adjust to respect rate limits.",
"position": [
16,
48
],
"parameters": {
"rule": {
"interval": [
{
"triggerAtHour": 19
}
]
}
},
"typeVersion": 1.2
},
{
"id": "6939ccfc-2490-4489-abdb-349d4e5da564",
"name": "从 Google Sheets 读取账号",
"type": "n8n-nodes-base.googleSheets",
"notes": "Role: Read target accounts from Google Sheets (column: account_id).",
"position": [
240,
48
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "19pJoBuba1o2PaJlx0inaGnGi45PpxbfB79MMhwLFH4s"
}
},
"typeVersion": 4.7
},
{
"id": "cc19735b-c69f-42ef-9fa9-73c97813960f",
"name": "获取最新推文",
"type": "n8n-nodes-base.twitter",
"notes": "Role: Search and fetch each account’s latest tweets. Recommend excluding replies/retweets.",
"position": [
464,
48
],
"parameters": {
"limit": 10,
"operation": "search",
"searchText": "=from:{{ $json['account_id'] }}",
"additionalFields": {
"tweetFieldsObject": []
}
},
"typeVersion": 2
},
{
"id": "d6e808b7-31de-409a-87ac-c6d3edbb1649",
"name": "点赞推文",
"type": "n8n-nodes-base.twitter",
"notes": "Role: Like the target tweet ID(s). Support a dry-run toggle for safety.",
"position": [
912,
48
],
"parameters": {
"tweetId": {
"__rl": true,
"mode": "id",
"value": "={{ $json.id }}"
},
"operation": "like"
},
"typeVersion": 2
},
{
"id": "9e46e0b5-4083-45b2-8cf1-20b172eac5f4",
"name": "转发推文",
"type": "n8n-nodes-base.twitter",
"notes": "Role: Repost tweets you just liked. Consider adding a cooldown.",
"position": [
1136,
48
],
"parameters": {
"tweetId": {
"__rl": true,
"mode": "id",
"value": "={{ $json.id }}"
},
"operation": "retweet"
},
"typeVersion": 2
},
{
"id": "a2f9de77-db50-4656-bd18-1025331adc97",
"name": "限制",
"type": "n8n-nodes-base.limit",
"notes": "Role: Limit downstream Like/Repost actions. Recommend 1–3 in production.",
"position": [
688,
48
],
"parameters": {},
"typeVersion": 1
},
{
"id": "43b4d64b-5fe4-4fcb-9d40-1b417d03e55f",
"name": "🟨 置顶：概述",
"type": "n8n-nodes-base.stickyNote",
"position": [
-688,
-64
],
"parameters": {
"color": "yellow",
"width": 440,
"height": 464,
"content": "## 模板概述（请先阅读）"
},
"typeVersion": 1
},
{
"id": "09cdabb3-e321-4059-b37b-d97cf09f7f0f",
"name": "置顶：计划触发器",
"type": "n8n-nodes-base.stickyNote",
"position": [
-192,
-240
],
"parameters": {
"color": "white",
"width": 376,
"height": 280,
"content": "## 计划触发器 — 使用方法"
},
"typeVersion": 1
},
{
"id": "e11dfabc-240c-495b-ba51-69213644d793",
"name": "置顶：Google Sheets 读取",
"type": "n8n-nodes-base.stickyNote",
"position": [
176,
208
],
"parameters": {
"color": "white",
"width": 360,
"height": 280,
"content": "## 从 Google Sheets 读取（账号列表）"
},
"typeVersion": 1
},
{
"id": "8597dec7-c6b8-4a3a-aff4-ea16042c59d2",
"name": "置顶：获取最新推文",
"type": "n8n-nodes-base.stickyNote",
"position": [
320,
-240
],
"parameters": {
"color": "white",
"width": 360,
"height": 280,
"content": "## 获取最新推文"
},
"typeVersion": 1
},
{
"id": "43745622-5ba2-47ae-b179-4d14f3341228",
"name": "置顶：限制",
"type": "n8n-nodes-base.stickyNote",
"position": [
672,
192
],
"parameters": {
"color": "white",
"width": 360,
"height": 280,
"content": "## 限制（限制操作次数）"
},
"typeVersion": 1
},
{
"id": "77b8e848-670f-4683-bc96-a86ab5b2cfef",
"name": "置顶：点赞推文",
"type": "n8n-nodes-base.stickyNote",
"position": [
848,
-240
],
"parameters": {
"color": "white",
"width": 360,
"height": 280,
"content": "## 点赞推文"
},
"typeVersion": 1
},
{
"id": "8ff534fd-3276-4360-9ba7-41809d0115c2",
"name": "置顶：转发推文",
"type": "n8n-nodes-base.stickyNote",
"position": [
1136,
192
],
"parameters": {
"color": "white",
"width": 360,
"height": 280,
"content": "## 转发推文"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "ee86cc7d-e83a-4bdb-9a86-667192155fca",
"connections": {
"Limit": {
"main": [
[
{
"node": "Like tweet",
"type": "main",
"index": 0
}
]
]
},
"Like tweet": {
"main": [
[
{
"node": "Repost tweet",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "Read accounts from Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Get latest tweets": {
"main": [
[
{
"node": "Limit",
"type": "main",
"index": 0
}
]
]
},
"Read accounts from Google Sheets": {
"main": [
[
{
"node": "Get latest tweets",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
使用 AI 字幕对用户视频进行去重并自动发布到 X 平台
使用 OpenRouter AI 字幕和 Google Sheets 去重自动发布 X 视频
If
Set
Code
+7
25 节点masaya kawabe
带定时功能的X账号自动取消转推清理
X/Twitter转推清理与定时功能
If
Set
Wait
+8
28 节点masaya kawabe
社交媒体
使用 Claude AI、DALL-E 图像和 Google Sheets 审批自动化 LinkedIn 帖子
使用 Claude AI、DALL-E 图像和 Google Sheets 审批自动化 LinkedIn 帖子
Set
Code
Wait
+14
28 节点Usman Liaqat
人工智能
内容生成器 v4
内容农场v4 - 使用ChatGPT 5和Gemini实现WordPress博客自动化
If
Set
Code
+26
168 节点Jay Emp0
在可视化参考库中探索n8n节点
在可视化参考库中探索n8n节点
If
Ftp
Set
+93
113 节点I versus AI
其他
内容生成器 v3
AI驱动博客自动化：使用GPT-4生成并发布SEO文章至WordPress和Twitter
If
Set
Code
+25
144 节点Jay Emp0
内容创作
