使用GPT-4洞察和PDF.co从Google Sheets生成营销报告

• •Google Sheets API 凭证
• •OpenAI API Key

{
  "meta": {
    "instanceId": "ad0113c344ee237399e44e9f11798b05baeb83a6196d514a9ae9d2ad71c3b5c9",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "ab1b7d2d-7eac-45eb-9e0a-36f14c56df14",
      "name": "当点击“执行工作流”时",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        1728,
        288
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "2015e3a3-026b-46af-adfc-1fcff0031e66",
      "name": "OpenAI 聊天模型",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        2720,
        608
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4.1-mini"
        },
        "options": {}
      },
      "credentials": {
        "openAiApi": {
          "id": "4l6TDfLZVFS24g3X",
          "name": "OpenAi account 4"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "3bce7fdc-3fe1-451f-9e3f-ed37563a8fb5",
      "name": "结构化输出解析器",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        3072,
        576
      ],
      "parameters": {
        "jsonSchemaExample": "{\n\t\"summary\": \"summary\"\n}"
      },
      "typeVersion": 1.3
    },
    {
      "id": "93cb6107-c70b-4a48-95e4-1ddda24d87e1",
      "name": "便签53",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1632,
        -272
      ],
      "parameters": {
        "color": 7,
        "width": 2144,
        "height": 1056,
        "content": "# 📊 营销支出报告 → Google Sheets + PDF"
      },
      "typeVersion": 1
    },
    {
      "id": "00aba054-1dab-429e-beb4-2c18e21c7e3a",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1184,
        -272
      ],
      "parameters": {
        "width": 400,
        "height": 1056,
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "2d0dba31-964f-4b8c-94e4-215b5448f2b4",
      "name": "获取营销数据",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1952,
        464
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 365710158,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1UDWt0-Z9fHqwnSNfU3vvhSoYCFG6EG3E-ZewJC_CLq4/edit#gid=365710158",
          "cachedResultName": "Data"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1UDWt0-Z9fHqwnSNfU3vvhSoYCFG6EG3E-ZewJC_CLq4",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1UDWt0-Z9fHqwnSNfU3vvhSoYCFG6EG3E-ZewJC_CLq4/edit?usp=drivesdk",
          "cachedResultName": "Sample Marketing Data - n8n"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "HlBW2puZbuCCq8jJ",
          "name": "Google Sheets account 3"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "385bdda8-e751-4c71-8ddc-ff1b93eb5698",
      "name": "按渠道汇总支出",
      "type": "n8n-nodes-base.summarize",
      "position": [
        2256,
        288
      ],
      "parameters": {
        "options": {},
        "fieldsToSplitBy": "Channel",
        "fieldsToSummarize": {
          "values": [
            {
              "field": "Spend ($)",
              "aggregation": "sum"
            }
          ]
        }
      },
      "typeVersion": 1.1
    },
    {
      "id": "433d72c6-032c-43b9-9c34-36191d3181b5",
      "name": "汇总支出",
      "type": "n8n-nodes-base.summarize",
      "position": [
        2256,
        128
      ],
      "parameters": {
        "options": {},
        "fieldsToSummarize": {
          "values": [
            {
              "field": "Spend ($)",
              "aggregation": "sum"
            }
          ]
        }
      },
      "typeVersion": 1.1
    },
    {
      "id": "dbcd16cf-f023-467b-bc92-d70c9110cf1b",
      "name": "撰写摘要",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        2832,
        304
      ],
      "parameters": {
        "text": "={{ $json.data }}",
        "options": {
          "systemMessage": "You are writing a daily update message about the marketing data. The data is provided. Output a 4 sentance summary. \n\nOutput like this. \n\n{\n\t\"summary\": \"summary\"\n}"
        },
        "promptType": "define",
        "hasOutputParser": true
      },
      "typeVersion": 2.2
    },
    {
      "id": "4d2c9c31-7fc8-4a4b-a6ca-3b36777ff96b",
      "name": "合并所有数据",
      "type": "n8n-nodes-base.merge",
      "position": [
        3136,
        48
      ],
      "parameters": {
        "mode": "combine",
        "options": {},
        "combineBy": "combineByPosition",
        "numberInputs": 3
      },
      "typeVersion": 3.2
    },
    {
      "id": "d6a77a5d-c9c4-4496-8a8e-520425b54400",
      "name": "转换为 PDF 并上传",
      "type": "n8n-nodes-base.code",
      "position": [
        3504,
        -160
      ],
      "parameters": {
        "jsCode": "// n8n Code node (JavaScript)\n// Input: ONE item whose .json is the array you posted\n// Output: ONE item in correct n8n shape: [{ json: <object for HTML/Mustache> }]\n\nconst fmtUSD = (n) => Number(n || 0).toLocaleString('en-US', { style: 'currency', currency: 'USD' });\n\nconst items = $input.all();\nif (!items.length) {\n  return [{ json: { error: 'No input data' } }];\n}\n\n// Handle your exact incoming shape (array with one object)\nlet root = items[0].json;\nif (Array.isArray(root)) root = root[0] || {};\n\nconst totalSpendRaw = Number(root[\"sum_Spend_($)\"] || 0);\nconst channelsRaw = Array.isArray(root.data) ? root.data : [];\nconst summary = (typeof root.output?.summary === 'string') ? root.output.summary : '';\n\n// Build channels list for the HTML template\nconst channels = channelsRaw.map(r => ({\n  channel: r.Channel || 'Unknown',\n  spendFmt: fmtUSD(Number(r[\"sum_Spend_($)\"] || 0)),\n}));\n\n// Final object expected by your HTML/Mustache\nconst out = {\n  generatedDate: new Date().toISOString().slice(0, 10),\n  totalSpendFmt: fmtUSD(totalSpendRaw),\n  channelCount: channels.length,\n  channels,\n  summary,\n};\n\n// ✅ Return in proper n8n format\nreturn [{ json: out }];\n"
      },
      "typeVersion": 2
    },
    {
      "id": "5d147144-87a1-4e6c-a03c-4366896deffe",
      "name": "创建 PDF",
      "type": "n8n-nodes-pdfco.PDFco Api",
      "position": [
        3552,
        560
      ],
      "parameters": {
        "operation": "URL/HTML to PDF",
        "templateId": "12011",
        "convertType": "htmlTemplateToPDF",
        "templateData": "={{ JSON.stringify($json) }}\n",
        "advancedOptions": {}
      },
      "credentials": {
        "pdfcoApi": {
          "id": "wGorcCULfsY1va25",
          "name": "PDF.co account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "0a330ed9-9b83-4915-a867-432752e0a6fc",
      "name": "转换为单行",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        2496,
        224
      ],
      "parameters": {
        "options": {},
        "aggregate": "aggregateAllItemData"
      },
      "typeVersion": 1
    },
    {
      "id": "a3ecc29f-ef2f-4325-b477-b4a536dc86d6",
      "name": "便签59",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3440,
        64
      ],
      "parameters": {
        "color": 3,
        "width": 288,
        "height": 624,
        "content": "### 2️⃣ 连接 PDF.co"
      },
      "typeVersion": 1
    },
    {
      "id": "2fe228de-8f55-4f3f-8856-a2d0216c3dd3",
      "name": "便签60",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1888,
        32
      ],
      "parameters": {
        "color": 3,
        "width": 224,
        "height": 576,
        "content": "### 1️⃣ 准备您的 Google Sheet"
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "Sum Spend": {
      "main": [
        [
          {
            "node": "Combine All",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Combine All": {
      "main": [
        [
          {
            "node": "Convert to PDF Upload",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Write Summary": {
      "main": [
        [
          {
            "node": "Combine All",
            "type": "main",
            "index": 2
          }
        ]
      ]
    },
    "Covert to 1 row": {
      "main": [
        [
          {
            "node": "Combine All",
            "type": "main",
            "index": 1
          },
          {
            "node": "Write Summary",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "Write Summary",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Get Marketing Data": {
      "main": [
        [
          {
            "node": "Sum Spend",
            "type": "main",
            "index": 0
          },
          {
            "node": "Sum Spend by Channel",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Sum Spend by Channel": {
      "main": [
        [
          {
            "node": "Covert to 1 row",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Convert to PDF Upload": {
      "main": [
        [
          {
            "node": "Create PDF",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Structured Output Parser": {
      "ai_outputParser": [
        [
          {
            "node": "Write Summary",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "When clicking ‘Execute workflow’": {
      "main": [
        [
          {
            "node": "Get Marketing Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}