使用 Jotform、GDrive、Gemini 的自动化售后产品交付与追加销售

• •Google 账号和 Gmail API 凭证
• •Google Drive API 凭证
• •Google Sheets API 凭证
• •Google Gemini API Key

{
  "meta": {
    "instanceId": "93f396852104089b8670e7494b0f3668b420464668ae4a8c1d6b4b5799f8e3ef",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "4272efa5-4d7d-40e5-b600-369d09de57fb",
      "name": "JotForm 触发器",
      "type": "n8n-nodes-base.jotFormTrigger",
      "position": [
        -1168,
        -560
      ],
      "webhookId": "52831063-e303-4e51-b899-6c8e7df68029",
      "parameters": {
        "form": "252855528344060"
      },
      "credentials": {
        "jotFormApi": {
          "id": "I2Xm5wbkEW1qEJC5",
          "name": "JotForm account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "2f4a728e-c663-4cef-a138-ad855df84cd4",
      "name": "分享文件",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        -944,
        -560
      ],
      "parameters": {
        "fileId": {
          "__rl": true,
          "mode": "list",
          "value": "1u73RpV-HJhNPtJHIwPZH3NPnjeaeFqAFbkgP_fRvkZM",
          "cachedResultUrl": "https://docs.google.com/document/d/1u73RpV-HJhNPtJHIwPZH3NPnjeaeFqAFbkgP_fRvkZM/edit?usp=drivesdk",
          "cachedResultName": "n8n workflow json"
        },
        "options": {},
        "operation": "share",
        "permissionsUi": {
          "permissionsValues": {
            "role": "reader",
            "type": "user",
            "emailAddress": "={{ $json['Email Address'] }}"
          }
        },
        "authentication": "serviceAccount"
      },
      "credentials": {
        "googleApi": {
          "id": "mYRmmCMyWcLawmcE",
          "name": "Google Service Account account"
        }
      },
      "typeVersion": 3
    },
    {
      "id": "c77f8cd7-2d5c-417f-b962-8349982e043a",
      "name": "在表格中追加或更新行",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -736,
        -560
      ],
      "parameters": {
        "columns": {
          "value": {
            "name": "={{ $('JotForm Trigger').item.json['Full Name'].first }} {{ $('JotForm Trigger').item.json['Full Name'].last }}",
            "email": "={{ $('JotForm Trigger').item.json['Email Address'] }}",
            "phone": "={{ $('JotForm Trigger').item.json['Phone Number'].full }}",
            "products": "={{ $('JotForm Trigger').item.json['My Products'].products[0].productName }}",
            "amount of sale": "={{ $('JotForm Trigger').item.json['My Products'].products[0].subTotal }} {{ $('JotForm Trigger').item.json['My Products'].products[0].currency }}"
          },
          "schema": [
            {
              "id": "name",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "email",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "email",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "phone",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "phone",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "products",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "products",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "amount of sale",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "amount of sale",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "email"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1-obvaY2DHnSBXloq8zLr8Ky0sSuBgGNF8eOF9fv8ucE/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1-obvaY2DHnSBXloq8zLr8Ky0sSuBgGNF8eOF9fv8ucE",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1-obvaY2DHnSBXloq8zLr8Ky0sSuBgGNF8eOF9fv8ucE/edit?usp=drivesdk",
          "cachedResultName": "Sales - n8n workflow"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "vemTjHgIvPJgj9C5",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "33166744-7cac-4448-99d3-3f1c5abaafdc",
      "name": "AI Agent",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        -528,
        -560
      ],
      "parameters": {
        "text": "=Create a subject line and email body for a post-purchase thank you email. The email body must be in HTML.\n\nInstructions:\n\nSubject Line: Write a warm and inviting subject line that thanks the customer for their order and hints at a community invitation.\n\nEmail Body (in HTML):\n\nCreate a visually appealing and well-structured HTML email body.\n\nStart with a personalized greeting using the placeholder {{ $json.name }}.\n\nAcknowledge their recent purchase of {{ $json.products }}.\n\nExpress excitement for them and invite them to join an exclusive community on Discord.\n\nInclude a prominent, clickable HTML <a> tag or button for the Discord invitation link: https://discord.gg/sARWmykk.\n\nExplain the benefits of joining the Discord server (e.g., connecting with other users, getting tips, receiving support).\n\nEnd with a friendly closing.\n\nThe overall tone should be appreciative, friendly, and enthusiastic.\n\nAND SIGN THE NAME WITH \"IAMVAAR\" INSTEAD OF ANY RANDOM COMPANY\n\nExpected JSON Output Example:\n\n{\n  \"subject\": \"Thank you for your order, Jane Doe! You're invited!\",\n  \"body\": \"<!DOCTYPE html>\\n<html>\\n<head>\\n<style>\\n  body { font-family: sans-serif; color: #333; }\\n  .container { max-width: 600px; margin: 0 auto; padding: 20px; border: 1px solid #eee; border-radius: 8px; }\\n  .header { font-size: 24px; font-weight: bold; margin-bottom: 15px; }\\n  .button { background-color: #5865F2; color: white; padding: 12px 25px; text-decoration: none; border-radius: 5px; display: inline-block; font-weight: bold; }\\n  .footer { margin-top: 20px; font-size: 12px; color: #777; }\\n</style>\\n</head>\\n<body>\\n  <div class=\\\"container\\\">\\n    <p class=\\\"header\\\">Thanks for your purchase, Jane Doe!</p>\\n    <p>We're so excited for you to receive your new products: <strong>The Ultimate Gadget, Super-Fast Charger</strong>. We know you're going to love them!</p>\\n    <p>As a thank you, we'd like to invite you to join our exclusive Discord community. It's the best place to connect with other users, get tips & tricks, and receive dedicated support from our team.</p>\\n    <p style=\\\"text-align: center; margin: 30px 0;\\\">\\n      <a href=\\\"https://discord.gg/sARWmykk\\\" class=\\\"button\\\">Join the Discord Server</a>\\n    </p>\\n    <p>We can't wait to see you there!</p>\\n    <p class=\\\"footer\\\">Best regards,<br>The Team</p>\\n  </div>\\n</body>\\n</html>\"\n}\n",
        "options": {},
        "promptType": "define",
        "hasOutputParser": true
      },
      "typeVersion": 2.2
    },
    {
      "id": "fd1a518f-8f04-4b9a-935e-2752c3b341cb",
      "name": "Google Gemini聊天模型",
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "position": [
        -528,
        -352
      ],
      "parameters": {
        "options": {}
      },
      "credentials": {
        "googlePalmApi": {
          "id": "qsaK3VMNWQDWLweQ",
          "name": "Google Gemini(PaLM) Api account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "25f19e5c-c843-4fc6-9008-0966d8fde407",
      "name": "发送消息",
      "type": "n8n-nodes-base.gmail",
      "position": [
        -176,
        -560
      ],
      "webhookId": "1182f61e-25f2-4713-ac5a-b40a4249af0a",
      "parameters": {
        "sendTo": "={{ $('Append or update row in sheet').item.json.email }}",
        "message": "={{ $json.output.body }}",
        "options": {},
        "subject": "={{ $json.output.subject }}"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "wreuF4NMkPPxXkKm",
          "name": "Abhiram.bvb"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "2a0d43d2-5c81-4459-9899-a48978593212",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1232,
        -816
      ],
      "parameters": {
        "width": 1264,
        "height": 656,
        "content": "### 此自动化处理客户在在线表单完成购买后的后续操作。它会自动与他们共享文档，在电子表格中记录销售信息，使用 AI 撰写个性化感谢邮件，然后发送到他们的收件箱。"
      },
      "typeVersion": 1
    },
    {
      "id": "74832848-4bf5-4743-985e-9433eac7283e",
      "name": "结构化输出解析器",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        -352,
        -352
      ],
      "parameters": {
        "jsonSchemaExample": "{\n  \"subject\": \"Thank you for your order, Jane Doe! You're invited!\",\n  \"body\": \"<!DOCTYPE html>\\n<html>\\n<head>\\n<style>\\n  body { font-family: sans-serif; color: #333; }\\n  .container { max-width: 600px; margin: 0 auto; padding: 20px; border: 1px solid #eee; border-radius: 8px; }\\n  .header { font-size: 24px; font-weight: bold; margin-bottom: 15px; }\\n  .button { background-color: #5865F2; color: white; padding: 12px 25px; text-decoration: none; border-radius: 5px; display: inline-block; font-weight: bold; }\\n  .footer { margin-top: 20px; font-size: 12px; color: #777; }\\n</style>\\n</head>\\n<body>\\n  <div class=\\\"container\\\">\\n    <p class=\\\"header\\\">Thanks for your purchase, Jane Doe!</p>\\n    <p>We're so excited for you to receive your new products: <strong>The Ultimate Gadget, Super-Fast Charger</strong>. We know you're going to love them!</p>\\n    <p>As a thank you, we'd like to invite you to join our exclusive Discord community. It's the best place to connect with other users, get tips & tricks, and receive dedicated support from our team.</p>\\n    <p style=\\\"text-align: center; margin: 30px 0;\\\">\\n      <a href=\\\"https://discord.gg/sARWmykk\\\" class=\\\"button\\\">Join the Discord Server</a>\\n    </p>\\n    <p>We can't wait to see you there!</p>\\n    <p class=\\\"footer\\\">Best regards,<br>The Team</p>\\n  </div>\\n</body>\\n</html>\"\n}"
      },
      "typeVersion": 1.3
    }
  ],
  "pinData": {},
  "connections": {
    "AI Agent": {
      "main": [
        [
          {
            "node": "Send a message",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Share file": {
      "main": [
        [
          {
            "node": "Append or update row in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "JotForm Trigger": {
      "main": [
        [
          {
            "node": "Share file",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Gemini Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "AI Agent",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Structured Output Parser": {
      "ai_outputParser": [
        [
          {
            "node": "AI Agent",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "Append or update row in sheet": {
      "main": [
        [
          {
            "node": "AI Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}