8
n8n 中文网amn8n.com

完整启动概览

中级

这是一个Market Research, AI Summarization领域的自动化工作流，包含 13 个节点。主要使用 If, Set, Code, Wait, FormTrigger 等节点。 使用Extruct.ai到Google Sheets自动化初创公司研究与画像

前置要求
  • •可能需要目标 API 的认证凭证
  • •Google Sheets API 凭证

使用的节点 (13)

If
Set
Code
Wait
StickyNote
FormTrigger
HttpRequest
GoogleSheets

分类

市场调研
AI 摘要总结
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "id": "QLS1VSLlm1Y6KG6C",
  "meta": {
    "instanceId": "afeb9bf6b44bcf071458717ba2725fb9cfe8e80d1545ad9879e786f1aaf7a15f"
  },
  "name": "完整启动概览",
  "tags": [],
  "nodes": [
    {
      "id": "68a0cf39-493c-4381-9140-bd9e98774aa7",
      "name": "表单提交时",
      "type": "n8n-nodes-base.formTrigger",
      "position": [
        1120,
        160
      ],
      "webhookId": "61233cba-6ff5-4736-a38f-3a53c7428723",
      "parameters": {
        "options": {},
        "formTitle": "Complete Startup Overview",
        "formFields": {
          "values": [
            {
              "fieldLabel": "Name"
            }
          ]
        },
        "formDescription": "Submit a startup’s name or website to gather a full profile"
      },
      "typeVersion": 2.2
    },
    {
      "id": "fdcb2e4f-3539-4813-a6ec-280442f5ed37",
      "name": "丰富表单输入",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1520,
        160
      ],
      "parameters": {
        "url": "={{'https://api.extruct.ai/v1/tables/' + $json.EXTRUCT_TABLE_ID + '/rows'}}",
        "method": "POST",
        "options": {},
        "jsonBody": "={\n  \"rows\": [\n    {\n      \"data\": {\n        \"input\": \"{{ $('On form submission').item.json.Name }}\"\n      }\n    }\n  ],\n  \"run\": true\n} ",
        "sendBody": true,
        "specifyBody": "json",
        "authentication": "genericCredentialType",
        "genericAuthType": "httpBearerAuth"
      },
      "credentials": {
        "httpBearerAuth": {
          "id": "PnJ0FDuGkKYiN4MZ",
          "name": "Bearer Auth account"
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "ac0eea8d-b62e-45f0-ac87-e5a1c6d3d1ba",
      "name": "获取状态",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1880,
        160
      ],
      "parameters": {
        "url": "=https://api.extruct.ai/v1/tables/{{ $('Variables').item.json.EXTRUCT_TABLE_ID }}",
        "options": {},
        "authentication": "genericCredentialType",
        "genericAuthType": "httpBearerAuth"
      },
      "credentials": {
        "httpBearerAuth": {
          "id": "PnJ0FDuGkKYiN4MZ",
          "name": "Bearer Auth account"
        }
      },
      "typeVersion": 4.2,
      "alwaysOutputData": true
    },
    {
      "id": "4d8663d5-60fc-48e7-8eb5-3cc2ec4c71f7",
      "name": "如果正在运行",
      "type": "n8n-nodes-base.if",
      "position": [
        2060,
        160
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "f8432dca-c337-4644-8163-fa83f12e5ded",
              "operator": {
                "name": "filter.operator.equals",
                "type": "string",
                "operation": "equals"
              },
              "leftValue": "={{ $json.status.run_status }}",
              "rightValue": "=running"
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "0a630d2a-5eef-459e-950a-cd7f4ca4dcd9",
      "name": "等待",
      "type": "n8n-nodes-base.wait",
      "position": [
        1700,
        160
      ],
      "webhookId": "10face1b-ef18-4357-ad22-0c4f32e25f90",
      "parameters": {
        "amount": 10
      },
      "typeVersion": 1.1
    },
    {
      "id": "da774bb1-669d-4ba7-8781-5756a4feee14",
      "name": "获取数据",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        2340,
        160
      ],
      "parameters": {
        "url": "=https://api.extruct.ai/v1/tables/{{ $('Variables').item.json.EXTRUCT_TABLE_ID }}/data",
        "options": {},
        "authentication": "genericCredentialType",
        "genericAuthType": "httpBearerAuth"
      },
      "credentials": {
        "httpBearerAuth": {
          "id": "PnJ0FDuGkKYiN4MZ",
          "name": "Bearer Auth account"
        }
      },
      "typeVersion": 4.2,
      "alwaysOutputData": true
    },
    {
      "id": "82527be3-43f1-44f6-b183-bfd87e055377",
      "name": "导入到 Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2660,
        160
      ],
      "parameters": {
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "",
          "cachedResultUrl": "",
          "cachedResultName": ""
        },
        "documentId": {
          "__rl": true,
          "mode": "url",
          "value": ""
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "AGhkvHtD8bZNcSya",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "95d08fda-590c-474f-bc97-704c4aa15815",
      "name": "变量",
      "type": "n8n-nodes-base.set",
      "position": [
        1280,
        160
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "1bfeac42-8afa-409a-806c-8262553270ec",
              "name": "=EXTRUCT_TABLE_ID",
              "type": "string",
              "value": "=YOUR_EXTRUCT_TABLE_ID"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "5b77747a-a849-4c4a-9a7d-1985fe0c95bb",
      "name": "格式化最后输入",
      "type": "n8n-nodes-base.code",
      "position": [
        2500,
        160
      ],
      "parameters": {
        "jsCode": "// Get rows from the first object\nconst rows = items[0].json.rows || items[0].json[0]?.rows;\n\n// Take the last row\nconst lastRow = rows[rows.length - 1];\nconst data = lastRow.data;\nlet flatRow = {};\n\n// Transform the data object to a flat object for Sheets\nfor (const key in data) {\n  if (data[key] && data[key].value && data[key].value.answer !== undefined) {\n    flatRow[key] = data[key].value.answer;\n  } else if (data[key] && data[key].value !== undefined) {\n    flatRow[key] = data[key].value;\n  } else {\n    flatRow[key] = '';\n  }\n}\n\nreturn [{ json: flatRow }];"
      },
      "typeVersion": 2
    },
    {
      "id": "f407c881-746e-4c84-badc-5e2e1afd2502",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        0
      ],
      "parameters": {
        "width": 1020,
        "height": 1640,
        "content": "## 完整启动概览快速入门指南"
      },
      "typeVersion": 1
    },
    {
      "id": "bd390841-1163-4644-8795-eaa74892d406",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1080,
        0
      ],
      "parameters": {
        "color": 5,
        "width": 340,
        "height": 340,
        "content": "## 输入："
      },
      "typeVersion": 1
    },
    {
      "id": "2bff3f63-b3ae-4485-9ba0-d1379940769b",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1480,
        0
      ],
      "parameters": {
        "color": 2,
        "width": 740,
        "height": 340,
        "content": "## 丰富处理："
      },
      "typeVersion": 1
    },
    {
      "id": "15a45ab8-a32f-4106-8c8b-660ff7e26224",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2280,
        0
      ],
      "parameters": {
        "width": 580,
        "height": 340,
        "content": "## 输出："
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "fe3cd4dc-58c9-4d54-9ecf-5bce47953974",
  "connections": {
    "Wait": {
      "main": [
        [
          {
            "node": "Get status",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get data": {
      "main": [
        [
          {
            "node": "Format last input",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Variables": {
      "main": [
        [
          {
            "node": "Enrich form input",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get status": {
      "main": [
        [
          {
            "node": "If running",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "If running": {
      "main": [
        [
          {
            "node": "Wait",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Get data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Enrich form input": {
      "main": [
        [
          {
            "node": "Wait",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Format last input": {
      "main": [
        [
          {
            "node": "Import to Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "On form submission": {
      "main": [
        [
          {
            "node": "Variables",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

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

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

中级 - 市场调研, AI 摘要总结

需要付费吗？

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

相关工作流推荐

社交媒体资料丰富流程
使用Extruct.ai收集公司社交媒体资料并存储到Google表格
If
Set
Code
+5
13 节点Extruct AI
潜在客户开发
选题捕手模板
使用Gemini分析Reddit、YouTube和X生成内容策略报告
If
Set
Code
+14
34 节点Sheryl
市场调研
Slack 潜在客户丰富器
Extruct AI线程内回复的Slack实时线索丰富
If
Set
Code
+5
17 节点Extruct AI
潜在客户开发
潜在客户开发与邮件工作流
使用Google Maps、SendGrid和AI自动化B2B潜在客户开发与邮件营销
If
Set
Code
+21
141 节点Ezema Kingsley Chibuzo
潜在客户开发
使用 Gemini 和 Jina AI 自动化供应商尽职调查研究
使用 Gemini 和 Jina AI 自动化供应商尽职调查研究
If
Set
Code
+12
27 节点Adnan
文档提取
我的工作流11
通过RapidAPI批量导出亚马逊产品评论到Google Sheets
If
Set
Code
+7
11 节点Hunyao
市场调研
工作流信息
难度等级
中级
节点数量13
分类2
节点类型8
难度说明

适合有一定经验的用户，包含 6-15 个节点的中等复杂度工作流

作者
Extruct AI

Extruct AI

@extruct-ai

Turn natural language into structured company data with one API call. Skip the web scraping, HTML parsing, and data cleaning - just describe the companies you're looking for and get back verified, enriched results. Perfect for enriching CRMs, building lead generation workflows, or automating market research. Built by developers who understand that the best company data isn't trapped in static databases - it's live on the web.

外部链接
在 n8n.io 查看 →

分享此工作流