8
n8n 中文网amn8n.com

使用SignSnapHome、HubSpot和Twilio自动化房地产开放日跟进

高级

这是一个Content Creation, Multimodal AI领域的自动化工作流,包含 32 个节点。主要使用 If, Set, Code, Wait, Twilio 等节点。 通过SignSnapHome、HubSpot和Twilio实现房地产开放日跟进的自动化

前置要求
  • HubSpot API Key
  • HTTP Webhook 端点(n8n 会自动生成)
  • 可能需要目标 API 的认证凭证
  • Google Sheets API 凭证
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "meta": {
    "instanceId": "105694f414213a0eca348284005921253960bd1b0223294a4970522d0da53055"
  },
  "nodes": [
    {
      "id": "306d7ce6-9e54-49a0-8fbd-5ace7fab8d18",
      "name": "Webhook:SignSnap主页",
      "type": "n8n-nodes-base.webhook",
      "position": [
        -944,
        -144
      ],
      "webhookId": "89c63504-3651-4865-a2f3-b187cf22e255",
      "parameters": {
        "path": "signsnap-drip-crm",
        "options": {},
        "httpMethod": "POST"
      },
      "typeVersion": 2.1
    },
    {
      "id": "b84af1e1-e49f-4fa9-8ec2-1d3b6b9cbd81",
      "name": "解析SignSnap数据",
      "type": "n8n-nodes-base.code",
      "position": [
        -736,
        -144
      ],
      "parameters": {
        "jsCode": "const items = $input.all();\nconst guestData = items[0].json.body;\nconst email = guestData.email || null;\nconst firstName = guestData.first_name || '';\nconst lastName = guestData.last_name || '';\nconst phone = guestData.phone_number || null;\nconst propertyAddress = guestData.openHouseTitle || '';\nconst visitDate = guestData.submissionTimestamp || new Date().toISOString();\nconst hasAgent = guestData.are_you_currently_working_with_an_agent || 'Not specified';\nconst rating = guestData.what_did_you_rate_the_house || null;\nconst buyerAgreement = guestData.do_you_have_a_signed_buyer_agreement || null;\nlet leadScore = 50;\nif (hasAgent === 'No' || hasAgent === 'no') leadScore += 30;\nif (rating && parseInt(rating) >= 4) leadScore += 20;\nif (rating && parseInt(rating) <= 2) leadScore -= 20;\nif (buyerAgreement === 'No' || buyerAgreement === 'no') leadScore += 10;\nleadScore = Math.max(0, Math.min(100, leadScore));\nlet leadStatus = 'OPEN';\nif (leadScore >= 70) leadStatus = 'HOT';\nelse if (leadScore >= 50) leadStatus = 'WARM';\nelse if (leadScore < 40) leadStatus = 'COLD';\nconst qualifiesForFollowUp = (hasAgent.toLowerCase() === 'no' || (hasAgent.toLowerCase() === 'yes' && buyerAgreement && buyerAgreement.toLowerCase() === 'no'));\nconst notes = `Property: ${propertyAddress}\\nVisit: ${visitDate}\\nHas Agent: ${hasAgent}\\nLead Score: ${leadScore}\\nStatus: ${leadStatus}`;\nreturn [{json: {email, firstname: firstName, lastname: lastName, phone, propertyAddress: propertyAddress, visitDate, hasAgent, rating, buyerAgreement, leadScore, leadStatus, qualifiesForFollowUp, notes, lifecyclestage: 'lead', _raw: guestData}}];"
      },
      "typeVersion": 2
    },
    {
      "id": "f8b4dbf0-111e-4324-bcdc-a168e15d79c3",
      "name": "有邮箱吗?",
      "type": "n8n-nodes-base.if",
      "position": [
        -512,
        -144
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "1",
              "operator": {
                "type": "string",
                "operation": "notEmpty"
              },
              "leftValue": "={{ $json.email }}",
              "rightValue": ""
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "37eea75a-1562-40b9-b5e8-b9f86b9dd804",
      "name": "发送感谢邮件",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        -304,
        -400
      ],
      "webhookId": "726c63db-812e-43ff-9a85-a7055fe50ace",
      "parameters": {
        "html": "=Hi {{ $json.firstname }}!\n\nThank you for visiting {{ $json.propertyAddress }} today.\n\nBest regards,\nYour Real Estate Team",
        "options": {},
        "subject": "=Thank You for Visiting {{ $json.propertyAddress }}!",
        "toEmail": "={{ $json.email }}",
        "fromEmail": "YOUR_EMAIL@DOMAIN.COM"
      },
      "typeVersion": 2.1
    },
    {
      "id": "af2b0a12-b231-4e74-b988-51b3a909ab6d",
      "name": "记录到主表格",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -304,
        -144
      ],
      "parameters": {
        "columns": {
          "value": {
            "Email": "={{ $json.email }}",
            "Phone": "={{ $json.phone }}",
            "Property": "={{ $json.propertyAddress }}",
            "Last Name": "={{ $json.lastname }}",
            "Timestamp": "={{ $json.visitDate }}",
            "First Name": "={{ $json.firstname }}",
            "Lead Score": "={{ $json.leadScore }}",
            "Lead Status": "={{ $json.leadStatus }}",
            "Qualifies for Follow-up": "={{ $json.qualifiesForFollowUp ? 'YES' : 'NO' }}"
          },
          "schema": [
            {
              "id": "Timestamp",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Timestamp",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "First Name",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "First Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Last Name",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Last Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Email",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Email",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Phone",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Phone",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Property",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Property",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Lead Score",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Lead Score",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Lead Status",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Lead Status",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Has Agent",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Has Agent",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Buyer Agreement",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Buyer Agreement",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Qualifies for Follow-up",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Qualifies for Follow-up",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Source",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Source",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 490817884,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1xWqUC4fGVpjB7c2rYnosAn1mKShs3SKizgA-M8P9tZg/edit#gid=490817884",
          "cachedResultName": "SignSnap Log Test"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1xWqUC4fGVpjB7c2rYnosAn1mKShs3SKizgA-M8P9tZg",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1xWqUC4fGVpjB7c2rYnosAn1mKShs3SKizgA-M8P9tZg/edit?usp=drivesdk",
          "cachedResultName": "Agent Google Maps Scrape n8n"
        },
        "authentication": "serviceAccount"
      },
      "credentials": {
        "googleApi": {
          "id": "Rcg87wOoQqOfBbHi",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "0c10f03a-1bd4-42aa-b2cb-db1442bf603f",
      "name": "创建/更新HubSpot联系人",
      "type": "n8n-nodes-base.hubspot",
      "position": [
        -64,
        -336
      ],
      "parameters": {
        "email": "={{ $('Parse SignSnap Data').item.json.email }}",
        "options": {},
        "authentication": "appToken",
        "additionalFields": {
          "lastName": "={{ $json['Last Name'] }}",
          "firstName": "={{ $json['First Name'] }}",
          "phoneNumber": "={{ $('Parse SignSnap Data').item.json.phone }}",
          "membershipNote": "={{ $('Parse SignSnap Data').item.json.notes }}"
        }
      },
      "credentials": {
        "hubspotAppToken": {
          "id": "XUCfDvhuGiD9t0za",
          "name": "HubSpot account"
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "b7e1cdb0-507d-4ddd-8fb5-58f2b3fec618",
      "name": "同步到Follow Up Boss",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -64,
        -144
      ],
      "parameters": {
        "url": "https://api.followupboss.com/v1/people",
        "method": "POST",
        "options": {},
        "sendBody": true,
        "authentication": "genericCredentialType",
        "bodyParameters": {
          "parameters": [
            {
              "name": "email",
              "value": "={{ $json.email }}"
            },
            {
              "name": "firstName",
              "value": "={{ $json.firstname }}"
            },
            {
              "name": "lastName",
              "value": "={{ $json.lastname }}"
            },
            {
              "name": "phones[0].value",
              "value": "={{ $json.phone }}"
            },
            {
              "name": "phones[0].type",
              "value": "mobile"
            },
            {
              "name": "source",
              "value": "=SignSnap Home {{ json.propertyAddress }}"
            },
            {
              "name": "notes",
              "value": "={{ $json.notes }}"
            }
          ]
        },
        "genericAuthType": "httpBasicAuth"
      },
      "typeVersion": 4.2
    },
    {
      "id": "26b97759-43bd-4046-a118-8ea7df44471f",
      "name": "同步到Monday.com",
      "type": "n8n-nodes-base.mondayCom",
      "position": [
        -64,
        32
      ],
      "parameters": {
        "name": "={{ $json.firstname }} {{ $json.lastname }} - {{ $json.propertyAddress }}",
        "boardId": "YOUR_MONDAY_BOARD_ID",
        "groupId": "topics",
        "resource": "boardItem",
        "additionalFields": {}
      },
      "typeVersion": 1
    },
    {
      "id": "c06c92c0-ddf0-490a-b846-b8ba32ba51fe",
      "name": "是否符合跟进条件?",
      "type": "n8n-nodes-base.if",
      "position": [
        160,
        -144
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "1",
              "operator": {
                "type": "boolean",
                "operation": "true"
              },
              "leftValue": "={{ $('Parse SignSnap Data').item.json.qualifiesForFollowUp }}",
              "rightValue": true
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "819cec37-f9d3-4362-81d9-9e7153483b2a",
      "name": "等待2天",
      "type": "n8n-nodes-base.wait",
      "position": [
        384,
        -144
      ],
      "webhookId": "d0b0689b-eac5-44db-90b6-d0195c78b84c",
      "parameters": {
        "amount": 2
      },
      "typeVersion": 1.1,
      "alwaysOutputData": true
    },
    {
      "id": "7df4434d-196d-465f-8f84-2c790e9fbe23",
      "name": "发送短信跟进(第2天)",
      "type": "n8n-nodes-base.twilio",
      "position": [
        592,
        -144
      ],
      "parameters": {
        "to": "={{ $('Parse SignSnap Data').item.json.phone }}",
        "from": "YOUR_TWILIO_PHONE_NUMBER",
        "message": "=Hi {{ $('Parse SignSnap Data').item.json.firstname }}! Great meeting you at {{ $('Parse SignSnap Data').item.json.propertyAddress }}. Any questions? Reply to this text!\n\nReply STOP to unsubscribe",
        "options": {}
      },
      "typeVersion": 1
    },
    {
      "id": "3369be2a-2dd5-489c-9b75-90827583c441",
      "name": "记录短信活动",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        816,
        -144
      ],
      "parameters": {
        "columns": {
          "value": {
            "Notes": "={{ $('Parse SignSnap Data').item.json.notes }}",
            "Message": "Day 2 SMS",
            "Property": "={{ $('Parse SignSnap Data').item.json.propertyAddress }}",
            "Timestamp": "={{ $now.toISO() }}",
            "Contact Name": "={{ $('Parse SignSnap Data').item.json.firstname }} {{ $('Parse SignSnap Data').item.json.lastname }}",
            "Activity Type": "SMS",
            "Contact Email": "={{ $('Parse SignSnap Data').item.json.email }}"
          },
          "schema": [
            {
              "id": "Timestamp",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Timestamp",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Contact Email",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Contact Email",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Contact Name",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Contact Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Activity Type",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Activity Type",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Message",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Message",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Property",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Property",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Success",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Success",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Notes",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Notes",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 288628652,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1xWqUC4fGVpjB7c2rYnosAn1mKShs3SKizgA-M8P9tZg/edit#gid=288628652",
          "cachedResultName": "SMS SignSnap Log Test"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1xWqUC4fGVpjB7c2rYnosAn1mKShs3SKizgA-M8P9tZg",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1xWqUC4fGVpjB7c2rYnosAn1mKShs3SKizgA-M8P9tZg/edit?usp=drivesdk",
          "cachedResultName": "Agent Google Maps Scrape n8n"
        },
        "authentication": "serviceAccount"
      },
      "credentials": {
        "googleApi": {
          "id": "Rcg87wOoQqOfBbHi",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "d4e56171-d817-479c-802e-dd6c9131fff3",
      "name": "再等待3天",
      "type": "n8n-nodes-base.wait",
      "position": [
        1040,
        -144
      ],
      "webhookId": "5f4dbdfe-4e5d-4eeb-8597-8fc7b8d1c574",
      "parameters": {
        "unit": "days",
        "amount": 3
      },
      "typeVersion": 1.1
    },
    {
      "id": "3540a701-4bdb-4e0f-ba3f-9e793294c47e",
      "name": "发送市场更新邮件(第5天)",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        1264,
        -144
      ],
      "webhookId": "8ee59399-1d42-4990-afb6-32f77ea0ea2e",
      "parameters": {
        "html": "=Hi {{ $('Parse SignSnap Data').item.json.firstname }},\n\nYOUR_MESSAGE_HERE.\n\nBest regards\nYOUR_NAME_HERE",
        "options": {},
        "subject": "=Market Update",
        "toEmail": "={{ $json.email }}",
        "fromEmail": "YOUR_EMAIL@DOMAIN.COM"
      },
      "typeVersion": 2.1
    },
    {
      "id": "0d1452f4-6e0c-4e1b-b99b-847fc966afc0",
      "name": "记录邮件活动",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1472,
        -144
      ],
      "parameters": {
        "columns": {
          "value": {
            "Notes": "={{ $('Parse SignSnap Data').item.json.notes }}",
            "Message": "Day 5 Email",
            "Property": "={{ $('Parse SignSnap Data').item.json.propertyAddress }}",
            "Timestamp": "={{ $now.toISO() }}",
            "Contact Name": "={{ $('Parse SignSnap Data').item.json.firstname }} {{ $('Parse SignSnap Data').item.json.lastname }}",
            "Activity Type": "Email",
            "Contact Email": "={{ $json.email }}"
          },
          "schema": [
            {
              "id": "Timestamp",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Timestamp",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Contact Email",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Contact Email",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Contact Name",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Contact Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Activity Type",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Activity Type",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Message",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Message",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Property",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Property",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Success",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Success",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Notes",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Notes",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 288628652,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1xWqUC4fGVpjB7c2rYnosAn1mKShs3SKizgA-M8P9tZg/edit#gid=288628652",
          "cachedResultName": "SMS SignSnap Log Test"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1xWqUC4fGVpjB7c2rYnosAn1mKShs3SKizgA-M8P9tZg",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1xWqUC4fGVpjB7c2rYnosAn1mKShs3SKizgA-M8P9tZg/edit?usp=drivesdk",
          "cachedResultName": "Agent Google Maps Scrape n8n"
        },
        "authentication": "serviceAccount"
      },
      "credentials": {
        "googleApi": {
          "id": "Rcg87wOoQqOfBbHi",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "cd4c3e51-cdb3-4869-9357-89fd3113130d",
      "name": "最后等待2天",
      "type": "n8n-nodes-base.wait",
      "position": [
        1696,
        -144
      ],
      "webhookId": "b62e73a2-fb7e-477d-a553-ff5c140c8924",
      "parameters": {
        "unit": "days",
        "amount": 2
      },
      "typeVersion": 1.1
    },
    {
      "id": "4bb2f67f-a640-4daf-850e-0c6ac7c206a1",
      "name": "创建跟进任务(第7天)",
      "type": "n8n-nodes-base.hubspot",
      "position": [
        1920,
        -144
      ],
      "parameters": {
        "resource": "task",
        "authentication": "appToken"
      },
      "credentials": {
        "hubspotAppToken": {
          "id": "XUCfDvhuGiD9t0za",
          "name": "HubSpot account"
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "5ca2bf5a-57a8-4972-9300-10b95c5d4a86",
      "name": "记录缺失邮箱",
      "type": "n8n-nodes-base.set",
      "position": [
        -304,
        144
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "1",
              "name": "error_reason",
              "type": "string",
              "value": "No email"
            },
            {
              "id": "2",
              "name": "guest_name",
              "type": "string",
              "value": "={{ $json.firstname }} {{ $json.lastname }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "23890819-d826-4c9a-9391-3755eada8049",
      "name": "记录到错误表格",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -64,
        320
      ],
      "parameters": {
        "columns": {
          "value": {
            "Timestamp": "={{ $now.toISO() }}",
            "Guest Name": "={{ $json.guest_name }}",
            "Error Reason": "={{ $json.error_reason }}"
          },
          "mappingMode": "defineBelow"
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "mode": "list",
          "value": "Errors"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1xWqUC4fGVpjB7c2rYnosAn1mKShs3SKizgA-M8P9tZg",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1xWqUC4fGVpjB7c2rYnosAn1mKShs3SKizgA-M8P9tZg/edit?usp=drivesdk",
          "cachedResultName": "Agent Google Maps Scrape n8n"
        },
        "authentication": "serviceAccount"
      },
      "credentials": {
        "googleApi": {
          "id": "Rcg87wOoQqOfBbHi",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "5710d148-ccb0-4324-9f41-3de8a547a8f7",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1504,
        -928
      ],
      "parameters": {
        "color": 5,
        "width": 352,
        "height": 736,
        "content": "## 📋 设置说明"
      },
      "typeVersion": 1
    },
    {
      "id": "13fe6aaa-dc6a-4495-ae62-504d3515857f",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1072,
        -640
      ],
      "parameters": {
        "width": 224,
        "height": 384,
        "content": "## 🎯 WEBHOOK触发器"
      },
      "typeVersion": 1
    },
    {
      "id": "3158bc54-e489-4466-af5b-ce0bc9bb0670",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -784,
        -768
      ],
      "parameters": {
        "height": 496,
        "content": "## ⚙️ 数据处理"
      },
      "typeVersion": 1
    },
    {
      "id": "5a6fd21b-1bc1-45b4-ade3-af26679eb627",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -528,
        -1456
      ],
      "parameters": {
        "color": 4,
        "height": 368,
        "content": "## 🎯 HUBSPOT"
      },
      "typeVersion": 1
    },
    {
      "id": "f6a03f6a-df91-4fc8-8b99-17fd12715a04",
      "name": "便签4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -256,
        -1456
      ],
      "parameters": {
        "color": 4,
        "height": 608,
        "content": "## 🔑 FOLLOW UP BOSS"
      },
      "typeVersion": 1
    },
    {
      "id": "c1454018-03d8-463f-870a-27595fda1d8e",
      "name": "便利贴5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        32,
        -1456
      ],
      "parameters": {
        "color": 4,
        "height": 688,
        "content": "## 📋 MONDAY.COM"
      },
      "typeVersion": 1
    },
    {
      "id": "2cad509e-ec9a-4972-b090-894fa95a410a",
      "name": "便签 6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        128,
        -736
      ],
      "parameters": {
        "color": 5,
        "width": 336,
        "height": 496,
        "content": "## 🎯 智能资格判定"
      },
      "typeVersion": 1
    },
    {
      "id": "ea992704-fe3a-4830-9cca-e0d716f19bc9",
      "name": "便签 7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -256,
        -576
      ],
      "parameters": {
        "color": 4,
        "height": 128,
        "content": "## 查看上方各别设置"
      },
      "typeVersion": 1
    },
    {
      "id": "c97076de-ae72-418e-bbaa-fb5b6d723c8f",
      "name": "便签8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        560,
        -768
      ],
      "parameters": {
        "width": 352,
        "height": 528,
        "content": "## 📱 TWILIO短信(第2天)"
      },
      "typeVersion": 1
    },
    {
      "id": "5f585c80-1984-4505-a408-08f697b9ef69",
      "name": "便签 9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        272,
        48
      ],
      "parameters": {
        "color": 5,
        "width": 720,
        "height": 1008,
        "content": "## 📊 GOOGLE SHEETS结构 + 设置"
      },
      "typeVersion": 1
    },
    {
      "id": "f28a2b08-52e1-43ab-bc68-c86f6e54ef15",
      "name": "便签10",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1040,
        -1040
      ],
      "parameters": {
        "color": 4,
        "width": 448,
        "height": 784,
        "content": "## ⏱️ 7天跟进序列"
      },
      "typeVersion": 1
    },
    {
      "id": "9138414d-76a4-4d31-9c18-d91ba2f67404",
      "name": "便签11",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1024,
        96
      ],
      "parameters": {
        "color": 3,
        "width": 368,
        "height": 928,
        "content": "## 🔧 故障排除"
      },
      "typeVersion": 1
    },
    {
      "id": "10db297e-9808-48bf-a230-eba11e372253",
      "name": "便签12",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1520,
        -64
      ],
      "parameters": {
        "color": 5,
        "width": 400,
        "height": 880,
        "content": "## 💡 专业提示与自定义"
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "Has Email?": {
      "main": [
        [
          {
            "node": "Log to Master Sheet",
            "type": "main",
            "index": 0
          },
          {
            "node": "Send Thank You Email",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Log Missing Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait 2 Days": {
      "main": [
        [
          {
            "node": "Send SMS Follow-up (Day 2)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Log SMS Activity": {
      "main": [
        [
          {
            "node": "Wait 3 More Days",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait 3 More Days": {
      "main": [
        [
          {
            "node": "Send Market Update Email (Day 5)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Log Missing Email": {
      "main": [
        [
          {
            "node": "Log to Error Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait 2 Final Days": {
      "main": [
        [
          {
            "node": "Create Follow-up Task (Day 7)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Log Email Activity": {
      "main": [
        [
          {
            "node": "Wait 2 Final Days",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Sync to Monday.com": {
      "main": [
        [
          {
            "node": "Qualifies for Follow-up?",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Log to Master Sheet": {
      "main": [
        [
          {
            "node": "Create/Update HubSpot Contact",
            "type": "main",
            "index": 0
          },
          {
            "node": "Sync to Follow Up Boss",
            "type": "main",
            "index": 0
          },
          {
            "node": "Sync to Monday.com",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Parse SignSnap Data": {
      "main": [
        [
          {
            "node": "Has Email?",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Sync to Follow Up Boss": {
      "main": [
        [
          {
            "node": "Qualifies for Follow-up?",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Webhook: SignSnap Home": {
      "main": [
        [
          {
            "node": "Parse SignSnap Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Qualifies for Follow-up?": {
      "main": [
        [
          {
            "node": "Wait 2 Days",
            "type": "main",
            "index": 0
          }
        ],
        []
      ]
    },
    "Send SMS Follow-up (Day 2)": {
      "main": [
        [
          {
            "node": "Log SMS Activity",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create/Update HubSpot Contact": {
      "main": [
        [
          {
            "node": "Qualifies for Follow-up?",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send Market Update Email (Day 5)": {
      "main": [
        [
          {
            "node": "Log Email Activity",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流?

复制上方的 JSON 配置代码,在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」,粘贴配置后根据需要修改凭证设置即可。

这个工作流适合什么场景?

高级 - 内容创作, 多模态 AI

需要付费吗?

本工作流完全免费,您可以直接导入使用。但请注意,工作流中使用的第三方服务(如 OpenAI API)可能需要您自行付费。

工作流信息
难度等级
高级
节点数量32
分类2
节点类型12
难度说明

适合高级用户,包含 16+ 个节点的复杂工作流

作者
Kaden Reese

Kaden Reese

@kadenreese

I started automating with Python in 2020 and still use it in workflows when needed, but I’ve recently leaned into n8n for client-facing solutions. Lately I’ve focused on real estate automations, though I also build workflows for email, scraping, and other use cases. Currently Building 👇🏻

外部链接
在 n8n.io 查看

分享此工作流