n8n 自动化 LinkedIn 发帖：OpenAI 生成内容、Google Sheets 审批与邮件确认工作流

从 Google Sheets 读取待发布内容 → OpenAI 生成 LinkedIn 帖子 → Gmail 邮件审批 → 条件发布并回写状态

给谁

需要内容审批流程的营销团队或社交媒体运营者

你会得到

自动从表格提取待办内容，由 AI 生成 LinkedIn 帖子，经邮件审批后自动发布并更新表格状态

你需要

n8n · Google Sheets · Gmail · LinkedIn

步骤

1. 准备 Google Sheet 数据表

   创建新 Google Sheet，添加以下列：Post Description（帖子描述）、Instructions（写作指令）、Image（图片 URL，可选）、Status（状态）、Output（输出）、Post Link（发布链接）、row_number（行号，用于精确更新）。填入一行测试数据，将 Status 设为 Pending。

2. 配置 n8n 凭证

   在 n8n 中创建以下凭证并分配到对应节点：a) Google Sheets OAuth2；b) Gmail OAuth2；c) OpenAI API Key；d) LinkedIn OAuth2。将凭证 ID 填入 workflow JSON 中各节点的 credentials 字段。

3. 设置触发器与 AI 模型

   在 Schedule Trigger 节点设置运行间隔（如每日上午 9 点）。在 OpenAI Chat Model 节点选择模型（默认 gpt-4o-mini，也可选用 gpt-4o）。如需调整生成风格，可在 Generate Post Content 节点修改提示词。

4. 生成内容并发送审批邮件

   工作流自动读取 Status=Pending 的首行数据，由 Generate Post Content 节点调用 OpenAI 生成帖子正文，经 Data Formatting 1 节点格式化后，通过 Gmail 发送给审批人。邮件内含自定义表单：下拉选项 Yes/No/Cancel 与修改意见文本框。

   运行提示词 · 来源原文。Generate Post Content 节点的 messages.messageValues[0].message（System 指令）

   复制提示词

   =You are an expert social media and LinkedIn content writer.
   
   You will be provided with:
   - A brief post description
   - Specific instructions from the user
   
   Please follow these steps:
   
   1. Initial Creation:
   If you are given a post description and instructions, write a polished, professionally worded LinkedIn post suitable for sharing. Strictly follow the instructions and ensure the message is engaging and succinct.
   If instructed, add a call to action or particular phrase (for example, "Connect with me" at the bottom).
   
   2. Formatting:
   Keep the tone positive, inclusive, and professional.
   Add relevant hashtags in small case.
   Limit the content to within 1300 characters.
   Place the call to action or special instruction at the end if requested.
   Output ONLY the final LinkedIn post content. Do NOT include any explanations, markdown, headings, or commentary—just the post text, ready to copy and share on LinkedIn.

   运行提示词 · 来源原文。Generate Post Content 节点的 text 字段（User 提示词）

   复制提示词

   =# LinkedIn Post Generation
   
   ## Post Description:
   {{ $json["Post Description"] }}
   
   ## Instructions:
   {{ $json["Instructions"] }}
   
   ---
   
   **Task:**
   Using the information above, generate the content for a LinkedIn post:
   - Use the Description and Instructions to create a new post.
   - Ensure your output is positive, professional, clear, and follows all provided instructions and feedback.
   - Do not include any explanations, just the final post content only, ready to publish on LinkedIn.
   - Limit to 1300 characters.
   - If the user demands to keep the same post as the Post Descrioption (in the instructions), then keep the same post content as provided in the Post Description, and output it.

5. 处理审批结果并发布

   Content Confirmation Logic（Switch 节点）根据审批回复路由：Yes→检查是否有图片 URL，有则下载并带图发布（Post With Image），无则纯文本发布（Post Without Image），然后更新 Google Sheet 状态为 Completed 并写入帖子链接；No→将修改意见传入 Regenerate Post Content 节点重新生成，再次发送审批；Cancel→更新 Google Sheet 状态为 Cancelled。

   运行提示词 · 来源原文。Regenerate Post Content 节点的 text 字段

   复制提示词

   =Apply the modification requests on the following LinkedIn post. Besides applying the reqested modifications, return the same linkedin post.
   
   LinkedIn post:
   ```
   {{ $('Data Formatting 1').item.json['Post Content'] }}
   ```
   
   Change requests:
   {{ $('Send Content Confirmation').item.json.data['Any Changes?'] }}
   
   **Task:**
   Using the information above, update the LinkedIn post content:
   - Do not include any explanations, just the final post content only (with all the change requests included in the post), ready to publish on LinkedIn.
   - Limit to 1300 characters.
   - If the user demands to keep the same post as the Post Description (in the instructions), then keep the same post content as provided in the Post Description, and output it.

   运行提示词 · 来源原文。Post With Image 节点的 text 字段

   复制提示词

   ={{ $('Data Formatting 1').item.json['Post Content'] }}

你正在搭建一个 n8n 工作流，用于自动从 Google Sheets 生成 LinkedIn 内容并经过邮件审批后发布。请先确认：1) Google Sheet 已创建且包含必需列；2) 四个凭证（Google Sheets、Gmail、OpenAI、LinkedIn）已在 n8n 中配置完成；3) 已从模板页导入 workflow JSON 或手动搭建节点。如需修改生成风格，请重点调整 Generate Post Content 节点的 system message 与 user prompt。