定时从Google Sheets通过Outlook发送新潜在客户邮件

• •Google Sheets API 凭证

{
  "meta": {
    "instanceId": "ad0113c344ee237399e44e9f11798b05baeb83a6196d514a9ae9d2ad71c3b5c9",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "425810c5-874c-41db-8fdd-59450e7f280e",
      "name": "发送消息",
      "type": "n8n-nodes-base.microsoftOutlook",
      "position": [
        -784,
        9472
      ],
      "webhookId": "028da3bf-3bd3-4c4f-883a-4e0f18c67f81",
      "parameters": {
        "subject": "Build AI Agents & Automations with n8n",
        "bodyContent": "Hi There,\n\nI help people learn how to build AI agents and create powerful AI automations using n8n. If you’re exploring ways to save time or scale your workflows, I’d love to share what’s possible.\n\nYou can check out my n8n Creator profile here with 70+ ready-to-use automations:\n👉 https://n8n.io/creators/rbreen\n\nIf you’d like help getting started or want to see what AI + n8n can do for your business, just reply to this email.\n\nBest,\nRobert Breen\n📞 +1 814-882-1293\n🔗 https://www.linkedin.com/in/robert-breen-29429625/",
        "toRecipients": "={{ $json.Email }}",
        "additionalFields": {}
      },
      "credentials": {
        "microsoftOutlookOAuth2Api": {
          "id": "9z1nG9ReKLXU309r",
          "name": "Microsoft Outlook account 4"
        }
      },
      "typeVersion": 2,
      "alwaysOutputData": true
    },
    {
      "id": "e84f0281-eb13-4afa-b831-eae6f1a5cf54",
      "name": "计划触发器",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -2416,
        9072
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "triggerAtHour": 9
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "1d3ef656-0288-45c2-8b82-a9aa7b57e2b0",
      "name": "获取 sheet3 中的行",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -2080,
        9232
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1sXXVbl2kKdYTzCmZDe7QyeMp1N9wZg9K63oGK2UIaeU/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1sXXVbl2kKdYTzCmZDe7QyeMp1N9wZg9K63oGK2UIaeU",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1sXXVbl2kKdYTzCmZDe7QyeMp1N9wZg9K63oGK2UIaeU/edit?usp=drivesdk",
          "cachedResultName": "New Leads"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "HlBW2puZbuCCq8jJ",
          "name": "Google Sheets account 3"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "7fa47640-1e65-491d-9457-ef32d0b7f600",
      "name": "过滤器1",
      "type": "n8n-nodes-base.filter",
      "position": [
        -1744,
        9088
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "914418a9-8c96-4959-abb7-ad3bb52f420d",
              "operator": {
                "type": "string",
                "operation": "empty",
                "singleValue": true
              },
              "leftValue": "={{ $json.Contacted }}",
              "rightValue": ""
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "3b4a33f6-c810-4dcb-9b19-3abc6b982e9f",
      "name": "在 sheet1 中追加或更新行",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -1312,
        8736
      ],
      "parameters": {
        "columns": {
          "value": {
            "Email": "={{ $json.Email }}",
            "Contacted": "Yes"
          },
          "schema": [
            {
              "id": "Email",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Email",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Contacted",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Contacted",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Created",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Created",
              "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/14T6rilaOl1LBTwNnu7ILE3T1equWOz0noI-OIUaI3zU/edit#gid=0",
          "cachedResultName": "leads"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "14T6rilaOl1LBTwNnu7ILE3T1equWOz0noI-OIUaI3zU",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/14T6rilaOl1LBTwNnu7ILE3T1equWOz0noI-OIUaI3zU/edit?usp=drivesdk",
          "cachedResultName": "New Leads - Real"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "HlBW2puZbuCCq8jJ",
          "name": "Google Sheets account 3"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "65e19508-beb8-4b3d-8ec8-55093f437fd5",
      "name": "便签58",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2688,
        8576
      ],
      "parameters": {
        "color": 7,
        "width": 2144,
        "height": 1056,
        "content": "## 按计划通过 Outlook 从 Google Sheets 发送邮件给新潜在客户"
      },
      "typeVersion": 1
    },
    {
      "id": "6736dbfa-79fc-4aa6-9890-5b60b3b98cd1",
      "name": "便签6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -3120,
        8576
      ],
      "parameters": {
        "width": 400,
        "height": 1056,
        "content": "## 如何设置"
      },
      "typeVersion": 1
    },
    {
      "id": "79a41cd6-d72f-4cd5-81a2-3341a21ceeb8",
      "name": "便签 70",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2144,
        8784
      ],
      "parameters": {
        "color": 3,
        "width": 224,
        "height": 656,
        "content": "### 1) 连接 Google Sheets (OAuth2)"
      },
      "typeVersion": 1
    },
    {
      "id": "49825745-adc3-4a5e-ba1c-0a65e31fd177",
      "name": "便签7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -848,
        8608
      ],
      "parameters": {
        "color": 3,
        "height": 992,
        "content": "### 2) Outlook (Microsoft Graph) OAuth2"
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "Filter1": {
      "main": [
        [
          {
            "node": "Append or update row in sheet1",
            "type": "main",
            "index": 0
          },
          {
            "node": "Send a message",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Get row(s) in sheet3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get row(s) in sheet3": {
      "main": [
        [
          {
            "node": "Filter1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}