使用 Telegram、Web 表单和 Google Sheets 筛选正面 Google 评价
高级
这是一个Content Creation, Multimodal AI领域的自动化工作流，包含 33 个节点。主要使用 If, Set, Wait, Webhook, Telegram 等节点。 通过 Telegram、Web 表单和 Google Sheets 筛选正面 Google 评价
前置要求
- •HTTP Webhook 端点（n8n 会自动生成）
- •Telegram Bot Token
- •Google Sheets API 凭证
使用的节点 (33)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "3d5da29ecb74ce7e2d987bbf535eab46b9724880017cbe267c2cb8d22899447c",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "22c9f809-df01-4dd2-aa0f-893d2aed3a17",
"name": "初始用户消息",
"type": "n8n-nodes-base.telegramTrigger",
"position": [
-1040,
-448
],
"webhookId": "25d6622d-5441-400d-9cde-9b9a232b72d8",
"parameters": {
"updates": [
"message"
],
"additionalFields": {}
},
"typeVersion": 1.2
},
{
"id": "7f7f07f5-fcc7-4fd9-ad9c-51d55ed559bd",
"name": "从表格获取行",
"type": "n8n-nodes-base.googleSheets",
"notes": "Checks if its a returning customer",
"position": [
-848,
-448
],
"parameters": {
"options": {},
"filtersUI": {
"values": [
{
"lookupValue": "={{ $json.message.from.id.toString() }}",
"lookupColumn": "ID"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/Your Google sheet ID/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "Your Google sheet ID",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/Your Google sheet ID/edit?usp=drivesdk",
"cachedResultName": "Google review Agent"
}
},
"notesInFlow": true,
"typeVersion": 4.7,
"alwaysOutputData": true
},
{
"id": "5f204297-2a27-4b40-a5f8-a91de5b65d2f",
"name": "更新客户详情",
"type": "n8n-nodes-base.googleSheets",
"position": [
-416,
-624
],
"parameters": {
"columns": {
"value": {
"ID": "={{ $('Initial User Message').item.json.message.from.id }}",
"Is Bot": "={{ $('Initial User Message').item.json.message.from.is_bot }}",
"Status": "pending",
"Last Name": "={{ $('Initial User Message').item.json.message.from.last_name }}",
"Timestamp": "={{ $now }}",
"First Name ": "={{ $('Initial User Message').item.json.message.from.first_name }}"
},
"schema": [
{
"id": "ID",
"type": "string",
"display": true,
"required": false,
"displayName": "ID",
"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": "Is Bot",
"type": "string",
"display": true,
"required": false,
"displayName": "Is Bot",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Feedback Message",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Feedback Message",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Timestamp",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Timestamp",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/Your Google sheet ID/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "Your Google sheet ID",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/Your Google sheet ID/edit?usp=drivesdk",
"cachedResultName": "Google review Agent"
}
},
"notesInFlow": false,
"typeVersion": 4.7
},
{
"id": "33002dd5-2c11-4216-939b-4041a6013f59",
"name": "更新状态",
"type": "n8n-nodes-base.googleSheets",
"position": [
-16,
-624
],
"parameters": {
"columns": {
"value": {
"ID": "={{ $('Initial User Message').item.json.message.from.id }}",
"Status": "contacted"
},
"schema": [
{
"id": "ID",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "ID",
"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": "Is Bot",
"type": "string",
"display": true,
"required": false,
"displayName": "Is Bot",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Feedback Message",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Feedback Message",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Timestamp",
"type": "string",
"display": true,
"required": false,
"displayName": "Timestamp",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"ID"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/Your Google sheet ID/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "Your Google sheet ID",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/Your Google sheet ID/edit?usp=drivesdk",
"cachedResultName": "Google review Agent"
}
},
"typeVersion": 4.7
},
{
"id": "3259cacc-d95a-48c4-be74-704f517b93a3",
"name": "已领取优惠消息",
"type": "n8n-nodes-base.telegram",
"position": [
-224,
-352
],
"webhookId": "87af6a07-b3c8-490e-bb67-b68c3e3c96f3",
"parameters": {
"text": "=Sorry {{ $('Initial User Message').item.json.message.chat.first_name }}, You have already Claimed this Offer. ",
"chatId": "={{ $('Initial User Message').item.json.message.chat.id }}",
"additionalFields": {
"appendAttribution": false
}
},
"typeVersion": 1.2
},
{
"id": "c7d82216-0388-4f2d-bc4d-33bc76c9f9db",
"name": "反馈消息",
"type": "n8n-nodes-base.webhook",
"position": [
-864,
-64
],
"webhookId": "b3ac4af4-a8fc-43ba-a2ef-be1de79fb2f1",
"parameters": {
"path": "b3ac4af4-a8fc-43ba-a2ef-be1de79fb2f1",
"options": {},
"httpMethod": "POST"
},
"typeVersion": 2.1
},
{
"id": "3b4d326b-400f-4899-b9b9-5c8f5acf8525",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1136,
-144
],
"parameters": {
"width": 912,
"height": 256,
"content": "## 反馈审核到Google Sheets"
},
"typeVersion": 1
},
{
"id": "e74201cb-d0eb-40d9-8107-98e298a81719",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-208,
-144
],
"parameters": {
"width": 832,
"height": 256,
"content": "## 链接点击跟踪"
},
"typeVersion": 1
},
{
"id": "8e3a7e0b-6250-496e-9975-023e417d749d",
"name": "链接点击跟踪",
"type": "n8n-nodes-base.webhook",
"position": [
48,
-64
],
"webhookId": "366b2145-1d50-45b1-84c0-25bf8765c953",
"parameters": {
"path": "366b2145-1d50-45b1-84c0-25bf8765c953",
"options": {},
"httpMethod": "POST"
},
"typeVersion": 2.1
},
{
"id": "94bf1a7a-8c39-44aa-a6ce-9cd2d08c794d",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1136,
-752
],
"parameters": {
"color": 4,
"width": 1760,
"height": 592,
"content": "## 初始客户引导和审核消息工作流"
},
"typeVersion": 1
},
{
"id": "b7bee03a-5c93-44da-ac42-cf18eb7dd0ad",
"name": "计划触发器",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-1024,
240
],
"parameters": {
"rule": {
"interval": [
{
"field": "minutes"
}
]
}
},
"typeVersion": 1.2
},
{
"id": "6f4c36e7-12e0-4efa-83af-1eacfc0f81e8",
"name": "在sheet1中获取行",
"type": "n8n-nodes-base.googleSheets",
"position": [
-816,
240
],
"parameters": {
"options": {},
"filtersUI": {
"values": [
{
"lookupValue": "contacted",
"lookupColumn": "Status"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/Your Google sheet ID/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "Your Google sheet ID",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/Your Google sheet ID/edit?usp=drivesdk",
"cachedResultName": "Google review Agent"
}
},
"typeVersion": 4.7
},
{
"id": "d7a5e922-79cc-4136-a1a6-32b4be2f3a35",
"name": "遍历项目",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-608,
240
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "c5597f2d-3926-4bac-8fd7-148f294e537f",
"name": "如果已过23小时",
"type": "n8n-nodes-base.if",
"position": [
-176,
240
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "2d460e62-dd33-4296-ad96-f97f063f8d63",
"operator": {
"type": "boolean",
"operation": "true",
"singleValue": true
},
"leftValue": "={{ $json.is_deadline_in_past }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "897e5fba-45fe-49dd-a699-9701aede5614",
"name": "更新状态为已发送跟进",
"type": "n8n-nodes-base.googleSheets",
"position": [
368,
240
],
"parameters": {
"columns": {
"value": {
"Status": "Follow-up Sent",
"Phone Number": "={{ $('Loop Over Items').item.json['Phone Number'] }}"
},
"schema": [
{
"id": "Phone Number",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Phone Number",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Full Name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Full Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Feedback Message",
"type": "string",
"display": true,
"required": false,
"displayName": "Feedback Message",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Timestamp",
"type": "string",
"display": true,
"required": false,
"displayName": "Timestamp",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "number",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Phone Number"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/Your Google sheet ID/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "Your Google sheet ID",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/Your Google sheet ID/edit?usp=drivesdk",
"cachedResultName": "Google review Agent"
}
},
"typeVersion": 4.7
},
{
"id": "2fb51e66-cd53-4bc0-bb34-c3a281ceeb3b",
"name": "2小时延迟等待反馈",
"type": "n8n-nodes-base.wait",
"position": [
208,
-624
],
"webhookId": "a1d2c560-a825-4513-96a4-11e9ff36a7bc",
"parameters": {
"unit": "hours",
"amount": 2
},
"typeVersion": 1.1
},
{
"id": "87e5713a-d453-4a0f-a41a-bf66739f77ed",
"name": "检查客户是否存在于表格中",
"type": "n8n-nodes-base.if",
"position": [
-656,
-448
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "baf45120-c886-40d9-9e83-55308b2c6e4a",
"operator": {
"type": "string",
"operation": "empty",
"singleValue": true
},
"leftValue": "={{ $json.ID.toString() }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "93c8d4cb-6221-4419-a8db-99de0a40a10f",
"name": "检查他们是否仍未领取优惠",
"type": "n8n-nodes-base.if",
"position": [
-416,
-336
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "or",
"conditions": [
{
"id": "3105bcfd-71a6-428b-acb9-bd30b9353084",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.Status }}",
"rightValue": "contacted"
},
{
"id": "311db6b1-1b87-4b8d-9d31-a51840ee7486",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.Status }}",
"rightValue": "clicked"
},
{
"id": "04d697a3-c67f-480f-ac7c-79f83852e0be",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.Status }}",
"rightValue": "Follow-up Sent"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "1eac73dc-0dad-4ced-a845-650b3b3bdcab",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1136,
128
],
"parameters": {
"color": 5,
"width": 1760,
"height": 352,
"content": ""
},
"typeVersion": 1
},
{
"id": "2b97bfa6-9bf3-4e83-a0b4-c2c3d303f801",
"name": "时间戳转布尔值",
"type": "n8n-nodes-base.set",
"position": [
-368,
240
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "d36b9dce-e4c0-40f3-851c-86db00097bf2",
"name": "is_deadline_in_past",
"type": "boolean",
"value": "={{ new Date(new Date($json.Timestamp).getTime() + (23 * 60 * 60 * 1000)) < new Date() }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "bef8f6b9-fc5a-4f75-a647-434d41a14760",
"name": "发送审核页面链接",
"type": "n8n-nodes-base.telegram",
"position": [
384,
-624
],
"webhookId": "b585b128-be42-457e-b478-042a27dbfb97",
"parameters": {
"text": "=Hi {{ $('Send Incentive Offer').item.json.result.chat.first_name }},\n\nThank you again for your visit today. Could you please take a moment to rate your experience out of 5 stars?\n\nIt's just one tap and helps us a lot.",
"chatId": "={{ $('Initial User Message').item.json.message.chat.id }}",
"replyMarkup": "inlineKeyboard",
"inlineKeyboard": {
"rows": [
{
"row": {
"buttons": [
{
"text": "Rate Your Visit",
"additionalFields": {
"url": "=https://\"Your webpage URl\"/?userId={{ $('Initial User Message').item.json.message.chat.id }}"
}
}
]
}
}
]
},
"additionalFields": {}
},
"typeVersion": 1.2
},
{
"id": "58c7b89f-0d97-442f-b3e0-c6c629c44465",
"name": "发送激励优惠",
"type": "n8n-nodes-base.telegram",
"position": [
-224,
-624
],
"webhookId": "87af6a07-b3c8-490e-bb67-b68c3e3c96f3",
"parameters": {
"text": "=Congratulations {{ $('Initial User Message').item.json.message.chat.first_name }},\n\nHere's Your discount of 5%. \n\nTo claim this show this message to the receptionist. ",
"chatId": "={{ $('Initial User Message').item.json.message.chat.id }}",
"additionalFields": {
"appendAttribution": false
}
},
"typeVersion": 1.2
},
{
"id": "6670b4ae-b24c-46a7-aebb-0d769776ae40",
"name": "发送审核链接提醒",
"type": "n8n-nodes-base.telegram",
"position": [
112,
240
],
"webhookId": "b585b128-be42-457e-b478-042a27dbfb97",
"parameters": {
"text": "=Hi {{ $('Loop Over Items').item.json['First Name '] }},\n\nThis is just a friendly reminder that we'd love to get your star rating on your recent visit. It only takes a second and helps us a lot!",
"chatId": "={{ $('Loop Over Items').item.json.ID }}",
"replyMarkup": "inlineKeyboard",
"inlineKeyboard": {
"rows": [
{
"row": {
"buttons": [
{
"text": "Rate Your Visit",
"additionalFields": {
"url": "=https://\"Your Webpage URL\"/?userId={{ $('Loop Over Items').item.json.ID }}"
}
}
]
}
}
]
},
"additionalFields": {}
},
"typeVersion": 1.2
},
{
"id": "be79b0fd-ac32-4891-b5c8-2b0a0b98fd7d",
"name": "更新状态为'已点击'",
"type": "n8n-nodes-base.googleSheets",
"position": [
256,
-64
],
"parameters": {
"columns": {
"value": {
"ID": "={{ $json.body.userId }}",
"Status": "clicked"
},
"schema": [
{
"id": "ID",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "ID",
"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": "Is Bot",
"type": "string",
"display": true,
"required": false,
"displayName": "Is Bot",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Feedback Message",
"type": "string",
"display": true,
"required": false,
"displayName": "Feedback Message",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Timestamp",
"type": "string",
"display": true,
"required": false,
"displayName": "Timestamp",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "number",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"ID"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/Your Google sheet ID/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "Your Google sheet ID",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/Your Google sheet ID/edit?usp=drivesdk",
"cachedResultName": "Google review Agent"
}
},
"typeVersion": 4.7
},
{
"id": "eb9a1614-0506-42c1-bfd3-643de8670ebf",
"name": "保存私人反馈到表格",
"type": "n8n-nodes-base.googleSheets",
"position": [
-656,
-64
],
"parameters": {
"columns": {
"value": {
"ID": "={{ $json.body.userId }}",
"Feedback Message": "={{ $('Feedback message').item.json.body.feedback }}"
},
"schema": [
{
"id": "ID",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "ID",
"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": "Is Bot",
"type": "string",
"display": true,
"required": false,
"displayName": "Is Bot",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Feedback Message",
"type": "string",
"display": true,
"required": false,
"displayName": "Feedback Message",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"ID"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/Your Google sheet ID/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "Your Google sheet ID",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/Your Google sheet ID/edit?usp=drivesdk",
"cachedResultName": "Google review Agent"
}
},
"typeVersion": 4.7
},
{
"id": "75613bca-9dc4-4140-ab10-80b52a02247f",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2144,
-1232
],
"parameters": {
"width": 560,
"height": 416,
"content": "========================="
},
"typeVersion": 1
},
{
"id": "416e3b5e-6d47-4d62-8442-83edb03c4437",
"name": "便签5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2144,
-768
],
"parameters": {
"color": 5,
"width": 416,
"height": 960,
"content": "## 试试看！"
},
"typeVersion": 1
},
{
"id": "0f409df6-2adb-4292-b824-674aa292abbd",
"name": "便签6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1136,
-944
],
"parameters": {
"width": 272,
"content": "### 注意："
},
"typeVersion": 1
},
{
"id": "7df82cf7-f836-4a46-bd4d-4e9579cc3b53",
"name": "便签7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1408,
-80
],
"parameters": {
"color": 3,
"width": 256,
"height": 112,
"content": "**-->此流程将把反馈从网页发送到表格（可以是数据库）**"
},
"typeVersion": 1
},
{
"id": "972ac8ba-73e0-4fbf-8c87-607d21b5f4b7",
"name": "便签8",
"type": "n8n-nodes-base.stickyNote",
"position": [
656,
-80
],
"parameters": {
"color": 3,
"width": 256,
"height": 96,
"content": "**-->如果链接被打开，此流程将更新状态为\"已点击\"**"
},
"typeVersion": 1
},
{
"id": "2c6714a7-3622-4cf1-8e71-456c22819fa3",
"name": "便签9",
"type": "n8n-nodes-base.stickyNote",
"position": [
-784,
-944
],
"parameters": {
"width": 320,
"content": "### -->动态链接"
},
"typeVersion": 1
},
{
"id": "c2ccc53f-fbbc-4bfe-b692-0e7d7eb907fa",
"name": "便签10",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1456,
160
],
"parameters": {
"color": 3,
"width": 304,
"height": 288,
"content": "**此流程将每5分钟检查一次时间戳是否超过\"23小时标记\"，以向未点击链接的客户发送跟进。"
},
"typeVersion": 1
},
{
"id": "af651e46-8818-42e0-8a5a-7587b143b422",
"name": "便利贴11",
"type": "n8n-nodes-base.stickyNote",
"position": [
656,
-752
],
"parameters": {
"width": 288,
"height": 320,
"content": "### 创建Telegram机器人"
},
"typeVersion": 1
}
],
"pinData": {
"Feedback message": [
{
"body": {
"rating": 3,
"userId": "7530337802",
"feedback": "You good"
},
"query": {},
"params": {},
"headers": {
"via": "2.0 Caddy",
"host": "n8n-digital.firmflare.in",
"accept": "*/*",
"origin": "https://google-review.firmflare.in",
"referer": "https://google-review.firmflare.in/",
"priority": "u=1, i",
"sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Android WebView\";v=\"140\"",
"user-agent": "Mozilla/5.0 (Linux; Android 14; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.7339.207 Mobile Safari/537.36",
"content-type": "application/json",
"content-length": "56",
"sec-fetch-dest": "empty",
"sec-fetch-mode": "cors",
"sec-fetch-site": "same-site",
"accept-encoding": "gzip, deflate, br, zstd",
"accept-language": "en,en-GB;q=0.9,en-US;q=0.8",
"x-forwarded-for": "49.47.196.213",
"sec-ch-ua-mobile": "?1",
"x-forwarded-host": "n8n-digital.firmflare.in",
"x-requested-with": "org.telegram.messenger",
"x-forwarded-proto": "https",
"sec-ch-ua-platform": "\"Android\""
},
"webhookUrl": "https://n8n-digital.firmflare.in/webhook/b3ac4af4-a8fc-43ba-a2ef-be1de79fb2f1",
"executionMode": "production"
}
],
"Schedule Trigger": [
{
"Hour": "19",
"Year": "2025",
"Month": "October",
"Minute": "40",
"Second": "03",
"Timezone": "Asia/Kolkata (UTC+05:30)",
"timestamp": "2025-10-04T19:40:03.005+05:30",
"Day of week": "Saturday",
"Day of month": "04",
"Readable date": "October 4th 2025, 7:40:03 pm",
"Readable time": "7:40:03 pm"
}
]
},
"connections": {
"Updates Status": {
"main": [
[
{
"node": "2 hours delay for feedback",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[],
[
{
"node": "Timestamp to Boolean",
"type": "main",
"index": 0
}
]
]
},
"Feedback message": {
"main": [
[
{
"node": "Save Private Feedback to Sheet",
"type": "main",
"index": 0
}
]
]
},
"Link Click Track": {
"main": [
[
{
"node": "Update Status to 'Clicked'",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "Get row(s) in sheet1",
"type": "main",
"index": 0
}
]
]
},
"if 23 hours passed": {
"main": [
[
{
"node": "Send Review Link Reminder",
"type": "main",
"index": 0
}
]
]
},
"Get row(s) in sheet1": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Initial User Message": {
"main": [
[
{
"node": "Fetch Rows from sheet",
"type": "main",
"index": 0
}
]
]
},
"Send Incentive Offer": {
"main": [
[
{
"node": "Updates Status",
"type": "main",
"index": 0
}
]
]
},
"Timestamp to Boolean": {
"main": [
[
{
"node": "if 23 hours passed",
"type": "main",
"index": 0
}
]
]
},
"Fetch Rows from sheet": {
"main": [
[
{
"node": "checks if customer exists in sheets",
"type": "main",
"index": 0
}
]
]
},
"Updates customer details": {
"main": [
[
{
"node": "Send Incentive Offer",
"type": "main",
"index": 0
}
]
]
},
"Send Review Link Reminder": {
"main": [
[
{
"node": "update status to follow up sent",
"type": "main",
"index": 0
}
]
]
},
"2 hours delay for feedback": {
"main": [
[
{
"node": "Send Review Page Link",
"type": "main",
"index": 0
}
]
]
},
"update status to follow up sent": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"checks if customer exists in sheets": {
"main": [
[
{
"node": "Updates customer details",
"type": "main",
"index": 0
}
],
[
{
"node": "checks if they still didn't claim the offer",
"type": "main",
"index": 0
}
]
]
},
"checks if they still didn't claim the offer": {
"main": [
[
{
"node": "Already claimed offer msg",
"type": "main",
"index": 0
}
],
[
{
"node": "Send Incentive Offer",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 内容创作, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
LinkedIn和X病毒内容自动引擎
使用AI生成和发布自动创建LinkedIn和X的病毒内容
If
Set
Wait
+26
156 节点Diptamoy Barman
内容创作
完整的 B2B 销售流程：Apollo 潜在客户生成、Mailgun 外展和 AI 回复管理
完整的 B2B 销售流程：Apollo 潜在客户生成、Mailgun 外展和 AI 回复管理
If
Set
Code
+26
116 节点Paul
内容创作
1. 播放列表详情设置机器人副本
使用 Suno、GPT-4、Runway 和 Creatomate 创建 AI 生成的 YouTube 音乐播放列表
If
Set
Code
+22
203 节点Joseph
内容创作
合并
使用Suno API、Claude和Telegram机器人创建完整的20首YouTube播放列表
If
Set
Code
+17
150 节点Joseph
内容创作
AI驱动视频创作与上传至Instagram、TikTok和YouTube
从云端硬盘进行AI驱动视频创作并上传至Instagram、TikTok和YouTube
If
Set
Code
+14
53 节点DevCode Journey
内容创作
💥 使用NanoBanana、Seedream 4、ChatGPT Image和Veo 3自动化视频广告 - VIDE
使用AI（NanoBanana、Seedream、GPT-4o、Veo 3）自动化和发布视频广告活动
Set
Code
Wait
+16
63 节点Dr. Firas
内容创作
