将Google Drive和Sheets中的图片和文本发布到LinkedIn
高级
这是一个Marketing领域的自动化工作流，包含 25 个节点。主要使用 If, Code, Function, LinkedIn, Telegram 等节点。 将Google Drive和Sheets中的图片和文本发布到LinkedIn
前置要求
- •LinkedIn API 凭证
- •Telegram Bot Token
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
使用的节点 (25)
分类
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "658ff8888937f16076b65bffb1ecf888701b332233b5694e6de40082045a989c",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "b556ae70-c630-481c-8860-ce8252d401be",
"name": "便签 - 触发器",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1620,
60
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "1c32ac1a-df82-4e3b-82f3-52e599822849",
"name": "查找下一条帖子3",
"type": "n8n-nodes-base.function",
"position": [
-940,
180
],
"parameters": {},
"typeVersion": 1
},
{
"id": "7e96fb64-540b-48a9-8917-304eccccf9aa",
"name": "便签 - 数据",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1180,
-120
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "de6a9983-b573-4069-8b38-b8e3544f2ed4",
"name": "便签 - 选择",
"type": "n8n-nodes-base.stickyNote",
"position": [
-960,
320
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "94af62f3-aafd-4f37-8e50-e7fb0ac10e9e",
"name": "便签 - 检查",
"type": "n8n-nodes-base.stickyNote",
"position": [
-700,
-60
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "a22401ae-2ac8-42c6-8a79-c836abfbc112",
"name": "便签 - 审批",
"type": "n8n-nodes-base.stickyNote",
"position": [
-260,
-140
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "c15d7c52-6cd2-4253-85d0-175510b9e796",
"name": "便签 - 发布",
"type": "n8n-nodes-base.stickyNote",
"position": [
620,
-300
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "3678d8b7-5bc8-4641-a48c-8065acac8f50",
"name": "便签 - 拒绝",
"type": "n8n-nodes-base.stickyNote",
"position": [
420,
320
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "7b0560a9-8d63-4f3c-aaa2-869b6869cd62",
"name": "HTTP 请求",
"type": "n8n-nodes-base.httpRequest",
"position": [
380,
-20
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "035ae938-2d1a-4982-b1bf-89b967380c00",
"name": "Telegram 审批",
"type": "n8n-nodes-base.telegram",
"position": [
-60,
80
],
"webhookId": "686ee0cf-41cf-49a9-9e5d-c4fc6926faaa",
"parameters": {},
"typeVersion": 1
},
{
"id": "45370005-a95f-4f79-a91e-dc75a0342d6b",
"name": "发送照片",
"type": "n8n-nodes-base.telegram",
"position": [
-280,
80
],
"webhookId": "da84cd14-1c36-4268-b132-898e2fd4844c",
"parameters": {},
"typeVersion": 1
},
{
"id": "86250cf4-7219-40b1-bba3-5c8d815c75ba",
"name": "检查审批状态",
"type": "n8n-nodes-base.if",
"position": [
160,
80
],
"parameters": {},
"typeVersion": 1
},
{
"id": "e66fec78-f9b3-472e-aa93-caa7507b3c7e",
"name": "更新表格 - 已拒绝",
"type": "n8n-nodes-base.googleSheets",
"position": [
600,
180
],
"parameters": {},
"typeVersion": 3
},
{
"id": "fa1ce27f-90a0-4c70-888e-92365177eb8b",
"name": "代码",
"type": "n8n-nodes-base.code",
"position": [
820,
-20
],
"parameters": {},
"typeVersion": 2
},
{
"id": "571d133b-bdd8-40d5-b831-e0282f393965",
"name": "代码1",
"type": "n8n-nodes-base.code",
"position": [
380,
180
],
"parameters": {},
"typeVersion": 2
},
{
"id": "482024c8-6875-46ff-86bc-c7934b636fc3",
"name": "计划触发器",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-1380,
80
],
"parameters": {},
"typeVersion": 1
},
{
"id": "c38ccb34-376e-46ce-901c-a759bb8db21c",
"name": "Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
-1160,
180
],
"parameters": {},
"typeVersion": 3
},
{
"id": "9552ab06-e0c1-472f-a9d9-c4989db52e63",
"name": "Telegram 无帖子",
"type": "n8n-nodes-base.telegram",
"position": [
-500,
280
],
"webhookId": "48ae197e-d8ff-4a82-8357-3d4ab8525f03",
"parameters": {},
"typeVersion": 1
},
{
"id": "bd519555-2bfc-497f-a399-b986731b4c08",
"name": "检查是否有可用帖子",
"type": "n8n-nodes-base.if",
"position": [
-720,
180
],
"parameters": {},
"typeVersion": 1
},
{
"id": "1fd93148-4d19-4e9b-b8bc-7579558ff699",
"name": "HTTP请求1",
"type": "n8n-nodes-base.httpRequest",
"position": [
-500,
80
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "2aef1d2c-e35d-4d6f-87e4-5def5ba066a8",
"name": "编辑字段8",
"type": "n8n-nodes-base.linkedIn",
"position": [
600,
-20
],
"parameters": {},
"typeVersion": 1
},
{
"id": "98bc108b-e8bf-4017-8058-ae4ad9921934",
"name": "更新表格 - 已发布",
"type": "n8n-nodes-base.googleSheets",
"position": [
1040,
-20
],
"parameters": {},
"typeVersion": 3
},
{
"id": "96578ca7-81ab-4064-9a6f-2857fa101acd",
"name": "Telegram 成功通知",
"type": "n8n-nodes-base.telegram",
"position": [
1260,
-20
],
"webhookId": "0ad702c2-b4a0-444d-824f-866d10651c34",
"parameters": {},
"typeVersion": 1
},
{
"id": "c2f346c7-b586-49eb-878c-225dc064a37a",
"name": "Telegram 拒绝通知",
"type": "n8n-nodes-base.telegram",
"position": [
820,
180
],
"webhookId": "8e650140-b1cd-4e92-8588-f6a4cec4b8b9",
"parameters": {},
"typeVersion": 1
},
{
"id": "740a57e2-45dc-40a6-b745-1104c34194d5",
"name": "Telegram 触发器",
"type": "n8n-nodes-base.telegramTrigger",
"position": [
-1380,
280
],
"webhookId": "92637b81-5081-4125-8dca-1b7450273a6c",
"parameters": {},
"typeVersion": 1.2
}
],
"pinData": {},
"connections": {
"Code": {
"main": [
[
{
"node": "Update Sheet - Posted",
"type": "main",
"index": 0
}
]
]
},
"Code1": {
"main": [
[
{
"node": "Update Sheet - Declined",
"type": "main",
"index": 0
}
]
]
},
"LinkedIn": {
"main": [
[
{
"node": "Code",
"type": "main",
"index": 0
}
]
]
},
"Send Photo": {
"main": [
[
{
"node": "Telegram Approval",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request": {
"main": [
[
{
"node": "LinkedIn",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets": {
"main": [
[
{
"node": "Find Next Post3",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request1": {
"main": [
[
{
"node": "Send Photo",
"type": "main",
"index": 0
}
]
]
},
"Check Approval": {
"main": [
[
{
"node": "HTTP Request",
"type": "main",
"index": 0
}
],
[
{
"node": "Code1",
"type": "main",
"index": 0
}
]
]
},
"Find Next Post3": {
"main": [
[
{
"node": "Check If Post Available",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Telegram Trigger": {
"main": [
[
{
"node": "Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Telegram Approval": {
"main": [
[
{
"node": "Check Approval",
"type": "main",
"index": 0
}
]
]
},
"Update Sheet - Posted": {
"main": [
[
{
"node": "Telegram Success",
"type": "main",
"index": 0
}
]
]
},
"Check If Post Available": {
"main": [
[
{
"node": "HTTP Request1",
"type": "main",
"index": 0
}
],
[
{
"node": "Telegram No Posts",
"type": "main",
"index": 0
}
]
]
},
"Update Sheet - Declined": {
"main": [
[
{
"node": "Telegram Decline",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 营销
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
使用GPT-4o、WordPress和LinkedIn发布自动化RSS内容到博客文章
使用GPT-4o、WordPress和LinkedIn发布自动化RSS内容到博客文章
If
Set
Code
+21
40 节点Immanuel
人工智能
YouTube
使用 Google Sheets 和 Telegram 提醒自动转发 TikTok 视频到 YouTube Shorts
Set
Code
Function
+7
22 节点Arkady Reveinz
人工智能
基于URL使用AI、Telegram和多平台发布自动生成社交媒体帖子
基于URL使用AI、Telegram和多平台发布自动生成社交媒体帖子
If
Set
Code
+11
42 节点Karol
内容创作
MailChimp自动化
基于AI的餐厅通讯生成器，集成Mailchimp和Telegram审批
If
Set
Code
+16
43 节点Femi Ad
人工智能
LinkedIn 自动化
使用 Telegram 提醒自动发布 Medium.com 文章到 LinkedIn
If
Code
Filter
+6
15 节点Krishna Kumar Eswaran
人工智能
使用Telegram、GPT-4和Blotato自动创建并发布AI社交视频
使用Telegram、GPT-4和Blotato自动创建并发布AI社交视频
If
Set
Code
+7
42 节点Dr. Firas
人工智能
工作流信息
难度等级
高级
节点数量25
分类1
节点类型10
作者
papcy
@papcy- AI-Powered Software Consultant - AI-DRIVEN SOFTWARE INNOVATOR - AI DEVELOPER & SYSTEM INTEGRATOR
外部链接
在 n8n.io 查看 →
分享此工作流