8
n8n 中文网amn8n.com

使用Mistral AI、Firecrawl和竞品分析创建结构化公司档案

高级

这是一个Market Research, AI Summarization领域的自动化工作流,包含 35 个节点。主要使用 Switch, Supabase, FormTrigger, GoogleDrive, McpClientTool 等节点。 使用Mistral AI、Firecrawl和竞品分析创建结构化公司档案

前置要求
  • Supabase URL 和 API Key
  • Google Drive API 凭证
  • 可能需要目标 API 的认证凭证
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "meta": {
    "instanceId": "e4680277d6b9c8b80748f71c2c1d0f9a640576175738ea2675967f762eeaf9df",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "1ffe080e-073c-46cb-83a7-81b417f8123b",
      "name": "Supabase",
      "type": "n8n-nodes-base.supabase",
      "position": [
        -6000,
        -688
      ],
      "parameters": {
        "tableId": "companies",
        "fieldsUi": {
          "fieldValues": [
            {
              "fieldId": "name",
              "fieldValue": "={{ $json.output.company_name }}"
            },
            {
              "fieldId": "mission",
              "fieldValue": "={{ $json.output.about_summary.mission }}"
            },
            {
              "fieldId": "vision",
              "fieldValue": "={{ $json.output.about_summary.vision }}"
            },
            {
              "fieldId": "values",
              "fieldValue": "={{ $json.output.about_summary.values }}"
            },
            {
              "fieldId": "services",
              "fieldValue": "={{ $json.output.services }}"
            },
            {
              "fieldId": "social_links",
              "fieldValue": "={{ $json.output.social_media_links }}"
            },
            {
              "fieldId": "contact_details",
              "fieldValue": "={{ $json.output.contact_details }}"
            },
            {
              "fieldId": "target_audience",
              "fieldValue": "={{ $json.output.target_audience.client_types }}"
            },
            {
              "fieldId": "testimonials",
              "fieldValue": "={{ $json.output.testimonials_or_clients }}"
            },
            {
              "fieldId": "blogs",
              "fieldValue": "={{ $json.output.recent_blog_or_news }}"
            },
            {
              "fieldId": "seo_keywords",
              "fieldValue": "={{ $json.output.seo_keywords }}"
            },
            {
              "fieldId": "notable_features",
              "fieldValue": "={{ $json.output.notable_features_or_differentiators }}"
            },
            {
              "fieldId": "location",
              "fieldValue": "={{ $json.output.location }}"
            },
            {
              "fieldId": "tone_of_voice",
              "fieldValue": "={{ $json.output.tone_of_voice }}"
            },
            {
              "fieldId": "calls_to_action",
              "fieldValue": "={{ $json.output.calls_to_action }}"
            },
            {
              "fieldId": "slug",
              "fieldValue": "={{ $json.output.company_name }}"
            },
            {
              "fieldId": "brand_story",
              "fieldValue": "={{ $json.output.one_liner }}"
            },
            {
              "fieldId": "social_links",
              "fieldValue": "={{ $json.output.social_media_links }}"
            }
          ]
        },
        "useCustomSchema": true
      },
      "typeVersion": 1
    },
    {
      "id": "0a72433a-bf91-4c15-a3c5-6298cfa9ac50",
      "name": "Mistral Cloud Chat Model3",
      "type": "@n8n/n8n-nodes-langchain.lmChatMistralCloud",
      "position": [
        -5312,
        -64
      ],
      "parameters": {
        "model": "mistral-small-latest",
        "options": {}
      },
      "typeVersion": 1
    },
    {
      "id": "acb8f32a-8abe-4bdb-b3f8-a6897020f412",
      "name": "列出工具",
      "type": "n8n-nodes-mcp.mcpClientTool",
      "position": [
        -5040,
        -32
      ],
      "parameters": {},
      "credentials": {},
      "typeVersion": 1
    },
    {
      "id": "264e6a97-1609-4555-ae55-40db0685b81c",
      "name": "执行工具",
      "type": "n8n-nodes-mcp.mcpClientTool",
      "position": [
        -5184,
        -32
      ],
      "parameters": {},
      "credentials": {},
      "typeVersion": 1
    },
    {
      "id": "68ba6ec3-0e73-4d36-8e8a-e6fdd16d9de4",
      "name": "查找竞争对手",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        -5280,
        -256
      ],
      "parameters": {
        "text": "={{ $json.name }} {{ $json.location.headquarters }}",
        "options": {
          "systemMessage": "you are ai webs search -utilize Tavily to search\n\nBegin by listing all available tools using list tools.\n\nThen, based on the tools available, use select tool to execute\n\ndo a tavily_search for given user prompt than find brands competing or is direct competitor to them in similar scale to them use crunbase.com to get accurate result"
        },
        "promptType": "define",
        "hasOutputParser": true
      },
      "typeVersion": 2
    },
    {
      "id": "7d7d4012-5ec8-4e4c-a1c9-53bcc2f8264e",
      "name": "结构化输出解析器",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        -4864,
        -32
      ],
      "parameters": {
        "jsonSchemaExample": "{\n  \"company_name\": \"\",\n  \"address\": {\n    \"city\": \"\",\n    \"state\": \"\",\n    \"country\": \"\"\n  },\n  \"industry\": \"\",\n  \"website\": \"\",\n  \"description\": \"\",\n  \"competitors\": [\n    {\n      \"name\": \"\",\n      \"industry\": \"\",\n      \"location\": \"\",\n      \"is_market_leader\": false,\n      \"notes\": \"\"\n    }\n  ],\n  \"additional_info\": {\n    \"company_size\": \"\",\n    \"linkedin_followers\": 0,\n    \"certifications\": [\"\"],\n    \"specializations\": [\"\"]\n  }\n}"
      },
      "typeVersion": 1.2
    },
    {
      "id": "b5527b66-2f03-42ac-bb59-3a76fabe9b12",
      "name": "Supabase4",
      "type": "n8n-nodes-base.supabase",
      "position": [
        -4432,
        -256
      ],
      "parameters": {
        "tableId": "competitors",
        "fieldsUi": {
          "fieldValues": [
            {
              "fieldId": "company_id",
              "fieldValue": "={{ $('Supabase').item.json.id }}"
            },
            {
              "fieldId": "industry",
              "fieldValue": "={{ $json.industry }}"
            },
            {
              "fieldId": "location",
              "fieldValue": "={{ $json.location }}"
            },
            {
              "fieldId": "website",
              "fieldValue": "={{ $json.website }}"
            },
            {
              "fieldId": "notes",
              "fieldValue": "={{ $json.notes }}"
            },
            {
              "fieldId": "is_market_leader",
              "fieldValue": "={{ $json.is_market_leader }}"
            },
            {
              "fieldId": "competitor_name",
              "fieldValue": "={{ $json.name }}"
            }
          ]
        }
      },
      "typeVersion": 1
    },
    {
      "id": "7e4f5bf2-e208-43f0-8e08-8d8eb681d4f0",
      "name": "爬取与抓取",
      "type": "n8n-nodes-crawl-and-scrape.crawleeNode",
      "position": [
        -6320,
        -1104
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "8cac5c1d-068a-420b-b66b-57d73be87cc6",
      "name": "表单提交时",
      "type": "n8n-nodes-base.formTrigger",
      "position": [
        -7184,
        -880
      ],
      "webhookId": "6a0e5a4e-2987-4f24-9eb6-a7cee7f1b911",
      "parameters": {
        "options": {},
        "formTitle": "profiler",
        "formFields": {
          "values": [
            {
              "fieldLabel": "Website url"
            },
            {
              "fieldType": "dropdown",
              "fieldLabel": "Scrapping type ",
              "fieldOptions": {
                "values": [
                  {
                    "option": "basic"
                  },
                  {
                    "option": "deep scraping"
                  }
                ]
              }
            },
            {
              "fieldType": "dropdown",
              "fieldLabel": "Competitor anaylsis",
              "fieldOptions": {
                "values": [
                  {
                    "option": "YES"
                  },
                  {
                    "option": "NO"
                  }
                ]
              }
            },
            {
              "fieldType": "dropdown",
              "fieldLabel": "Social Media scraping",
              "fieldOptions": {
                "values": [
                  {
                    "option": "YES"
                  },
                  {
                    "option": "NO"
                  }
                ]
              }
            }
          ]
        },
        "formDescription": "create am profile for the company"
      },
      "typeVersion": 2.2
    },
    {
      "id": "5f780b78-c924-48f2-b654-2d17d69f0b66",
      "name": "切换",
      "type": "n8n-nodes-base.switch",
      "position": [
        -6880,
        -880
      ],
      "parameters": {
        "rules": {
          "values": [
            {
              "outputKey": "for crawlee",
              "conditions": {
                "options": {
                  "version": 2,
                  "leftValue": "",
                  "caseSensitive": true,
                  "typeValidation": "strict"
                },
                "combinator": "and",
                "conditions": [
                  {
                    "id": "08c512fc-b8f6-4325-9a3d-897a154cba46",
                    "operator": {
                      "type": "string",
                      "operation": "equals"
                    },
                    "leftValue": "={{ $json['Scrapping type '] }}",
                    "rightValue": "basic"
                  }
                ]
              },
              "renameOutput": true
            },
            {
              "outputKey": "crawlai",
              "conditions": {
                "options": {
                  "version": 2,
                  "leftValue": "",
                  "caseSensitive": true,
                  "typeValidation": "strict"
                },
                "combinator": "and",
                "conditions": [
                  {
                    "id": "32135bfb-947f-46d8-960d-afa65480cc7a",
                    "operator": {
                      "name": "filter.operator.equals",
                      "type": "string",
                      "operation": "equals"
                    },
                    "leftValue": "={{ $json['Scrapping type '] }}",
                    "rightValue": "deep scraping"
                  }
                ]
              },
              "renameOutput": true
            }
          ]
        },
        "options": {
          "allMatchingOutputs": false
        }
      },
      "typeVersion": 3.2
    },
    {
      "id": "26e8dec4-d627-493c-82b1-ae25c30f4c67",
      "name": "基础网页抓取器",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        -6112,
        -1104
      ],
      "parameters": {
        "text": "={{ $json.data.text }}",
        "options": {
          "systemMessage": "=You are a brand analyst.\n\nAnalyze the following raw website  {{ $json.data.text }} content and return a complete Company Profile in valid JSON format.\n\nFill in or infer values where possible. If any section is missing, infer based on tone and context. Do NOT skip any section.\n\n\n\n\n\n"
        },
        "promptType": "define"
      },
      "typeVersion": 2
    },
    {
      "id": "6f6968ae-58bb-499a-956d-463e1f484f52",
      "name": "社交媒体数据库",
      "type": "n8n-nodes-base.supabase",
      "position": [
        -4848,
        -944
      ],
      "parameters": {
        "tableId": "social_links",
        "fieldsUi": {
          "fieldValues": [
            {
              "fieldId": "company_id",
              "fieldValue": "={{ $('Supabase').item.json.id }}"
            }
          ]
        }
      },
      "typeVersion": 1
    },
    {
      "id": "2326530e-37c7-4913-9f0a-7600b60d3359",
      "name": "关键词",
      "type": "n8n-nodes-base.supabase",
      "position": [
        -4832,
        -768
      ],
      "parameters": {
        "tableId": "seo_keywords",
        "fieldsUi": {
          "fieldValues": [
            {
              "fieldId": "company_id",
              "fieldValue": "={{ $json.company_id }}"
            },
            {
              "fieldId": "keyword",
              "fieldValue": "={{ $('Supabase').item.json.seo_keywords }}"
            }
          ]
        }
      },
      "typeVersion": 1
    },
    {
      "id": "5d84d70f-0eed-43c7-9c85-31803b8db0dc",
      "name": "Mistral Cloud Chat Model5",
      "type": "@n8n/n8n-nodes-langchain.lmChatMistralCloud",
      "position": [
        -6160,
        -960
      ],
      "parameters": {
        "model": "mistral-small-latest",
        "options": {}
      },
      "typeVersion": 1
    },
    {
      "id": "cda8951a-f654-4a63-8597-a0261e95d937",
      "name": "信息提取器1",
      "type": "@n8n/n8n-nodes-langchain.informationExtractor",
      "position": [
        -5776,
        -1104
      ],
      "parameters": {
        "text": "={{ $json.output }}",
        "options": {},
        "schemaType": "fromJson",
        "jsonSchemaExample": "{\n  \"NAME\":\"....\",\n  \"Company Summary\": \"...\",\n  \"Mission & Vision\": {\n    \"Mission\": \"...\",\n    \"Vision\": \"...\"\n  },\n  \"Products/Services\": [\n    {\n      \"Product/Service\": \"...\",\n      \"Description\": \"...\"\n    }\n  ],\n  \"Target Audience\": \"...\",\n  \"Tone of Voice\": [\"...\", \"...\", \"...\"],\n  \"Core Brand Values\": [\"...\", \"...\", \"...\"],\n  \"Digital Presence\": [\"...\"],\n  \"Founding Story\": \"...\",\n  \"Visual Identity\": [\"...\", \"...\"],\n  \"Unique Selling Points (USPs)\": [\n    \"...\", \"...\", \"...\"\n  ]\n}"
      },
      "typeVersion": 1.1
    },
    {
      "id": "17bccd88-c696-4d30-9575-f863ea2a0c39",
      "name": "Mistral Cloud Chat Model6",
      "type": "@n8n/n8n-nodes-langchain.lmChatMistralCloud",
      "position": [
        -5696,
        -944
      ],
      "parameters": {
        "model": "mistral-small-latest",
        "options": {}
      },
      "typeVersion": 1
    },
    {
      "id": "2beb0004-5196-44d6-aec6-0a493f49a0e4",
      "name": "Google Drive2",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        -4640,
        -560
      ],
      "parameters": {
        "name": "={{ $json.output.company_name }}(detailed)",
        "driveId": {
          "__rl": true,
          "mode": "list",
          "value": "My Drive",
          "cachedResultUrl": "https://drive.google.com/drive/my-drive",
          "cachedResultName": "My Drive"
        },
        "options": {},
        "folderId": {
          "__rl": true,
          "mode": "list",
          "value": "1eW5r0x6mSG0xnfq-Hjuc49AbDUg-dgf_",
          "cachedResultUrl": "https://drive.google.com/drive/folders/1eW5r0x6mSG0xnfq-Hjuc49AbDUg-dgf_",
          "cachedResultName": "Companies_profiles"
        }
      },
      "typeVersion": 3
    },
    {
      "id": "24e7982a-aaf9-4d74-bbfe-360fa321182b",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -6384,
        -1216
      ],
      "parameters": {
        "color": 6,
        "width": 980,
        "height": 380,
        "content": "基础网页抓取器"
      },
      "typeVersion": 1
    },
    {
      "id": "8c45093d-981b-425d-95f7-fd8a52a860a4",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -5392,
        -336
      ],
      "parameters": {
        "color": 6,
        "width": 700,
        "height": 420,
        "content": "TAVILY MCP(通过专业搜索寻找竞争对手)"
      },
      "typeVersion": 1
    },
    {
      "id": "8b0fcac9-8f27-4716-af56-e8bb62e0ef64",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -6672,
        -768
      ],
      "parameters": {
        "color": 6,
        "width": 820,
        "height": 420,
        "content": "FIRECRAWL MCP(基于深度AI的抓取)"
      },
      "typeVersion": 1
    },
    {
      "id": "615593af-45e3-406d-8737-ee5ff9fd4e11",
      "name": "Firecrawl工具1",
      "type": "n8n-nodes-mcp.mcpClientTool",
      "position": [
        -6336,
        -464
      ],
      "parameters": {},
      "credentials": {},
      "typeVersion": 1
    },
    {
      "id": "8232bd8a-05b1-4672-828c-00e7de9d58bc",
      "name": "Mistral Cloud Chat Model2",
      "type": "@n8n/n8n-nodes-langchain.lmChatMistralCloud",
      "position": [
        -6608,
        -480
      ],
      "parameters": {
        "model": "mistral-small-latest",
        "options": {}
      },
      "typeVersion": 1
    },
    {
      "id": "efc64bb5-09f2-47ed-a104-152721d3791b",
      "name": "Firecrawl列表1",
      "type": "n8n-nodes-mcp.mcpClientTool",
      "position": [
        -6480,
        -464
      ],
      "parameters": {},
      "credentials": {},
      "typeVersion": 1
    },
    {
      "id": "416b8711-6a9d-4c3b-866f-3e6f443b2f8b",
      "name": "结构化输出解析器1",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        -6208,
        -464
      ],
      "parameters": {
        "jsonSchemaExample": "{\n  \"company_name\": \"\",\n  \"one_liner\": \"\",\n  \"about_summary\": {\n    \"mission\": \"\",\n    \"vision\": \"\",\n    \"values\": []\n  },\n  \"services\": [],\n  \"target_audience\": {\n    \"industries_served\": [],\n    \"client_types\": []\n  },\n  \"founders_and_team\": {\n    \"leadership_team\": []\n  },\n  \"slogans_or_taglines\": [],\n  \"social_media_links\": {\n    \"LinkedIn\": \"\",\n    \"Instagram\": \"\",\n    \"Facebook\": \"\",\n    \"Twitter\": \"\",\n    \"YouTube\": \"\",\n    \"TikTok\": \"\"\n  },\n  \"testimonials_or_clients\": {\n    \"clients\": [],\n    \"case_studies\": [],\n    \"links\": []\n  },\n  \"recent_blog_or_news\": [\n    {\n      \"title\": \"\",\n      \"summary\": \"\",\n      \"date\": \"\"\n    }\n  ],\n  \"tone_of_voice\": \"\",\n  \"calls_to_action\": [],\n  \"seo_keywords\": [],\n  \"notable_features_or_differentiators\": [],\n  \"location\": {\n    \"headquarters\": \"\",\n    \"address\": \"\",\n    \"city\": \"\",\n    \"state\": \"\",\n    \"country\": \"\",\n    \"zip_code\": \"\"\n  },\n  \"contact_details\": {\n    \"email\": \"\",\n    \"phone\": \"\",\n    \"contact_page_url\": \"\"\n  }\n}"
      },
      "typeVersion": 1.2
    },
    {
      "id": "1a930c18-72e3-480f-ba3e-b8228f82f745",
      "name": "网页搜索工具",
      "type": "@n8n/n8n-nodes-langchain.toolHttpRequest",
      "position": [
        -6064,
        -464
      ],
      "parameters": {
        "url": "https://api.tavily.com/search",
        "method": "POST",
        "jsonBody": "={\n  \"query\": \"{query}\",\n  \"topic\": \"general\",\n  \"search_depth\": \"advanced\",\n  \"max_results\": 20,\n  \"include_answer\": true,\n  \"include_raw_content\": false,\n  \"include_images\": false,\n  \"include_image_descriptions\": false,\n  \"include_domains\": [\"\"],\n  \"exclude_domains\": []\n}",
        "sendBody": true,
        "sendHeaders": true,
        "specifyBody": "json",
        "toolDescription": "Web Search tool only SAP websites",
        "parametersHeaders": {
          "values": [
            {
              "name": "Authorization",
              "value": "Bearer YOUR_TOKEN_HERE",
              "valueProvider": "fieldValue"
            },
            {
              "name": "Content-Type",
              "value": "application/json",
              "valueProvider": "fieldValue"
            }
          ]
        },
        "placeholderDefinitions": {
          "values": [
            {
              "name": "query",
              "type": "string",
              "description": "Search Querry"
            }
          ]
        }
      },
      "typeVersion": 1.1
    },
    {
      "id": "6daa8dea-e362-4b74-ad55-0c4a61f76808",
      "name": "无操作,不执行任何动作",
      "type": "n8n-nodes-base.noOp",
      "position": [
        -3792,
        -1120
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "74b06226-fec4-4277-96d0-776ddb25fb22",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -7312,
        -1056
      ],
      "parameters": {
        "color": 5,
        "width": 352,
        "height": 368,
        "content": "## 用户填写表单"
      },
      "typeVersion": 1
    },
    {
      "id": "b4ff76b3-e5a8-4acb-8b1d-719d5804c611",
      "name": "便签4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -6944,
        -1056
      ],
      "parameters": {
        "color": 5,
        "width": 256,
        "height": 384,
        "content": "## 根据用户选择切换抓取器"
      },
      "typeVersion": 1
    },
    {
      "id": "f78e28d4-7a4f-448f-9d0f-269b9b45b466",
      "name": "基于MCP的抓取器 FIRECRAWLER",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        -6448,
        -672
      ],
      "parameters": {
        "text": "={{ $json['Website url'] }}",
        "options": {
          "maxIterations": 30,
          "systemMessage": "you are ai webs scraper\n\n-utilize firecrawl to crape website\n\nBegin by listing all available Firecrawl tools using `listTools`.\n\nThen, based on the tools available, use `executeTools` to perform the appropriate actions required for the task.\n\nYour objective is to visit the provided company website and extract all key information needed to generate personalized, high-quality social media content.\n\nUtilize both Firecrawl's `list` and `tools` capabilities to extract:\n\n1. **company_name**: Full official name of the company.\n2. **one_liner**: Short summary of what the company does.\n3. **about_summary**: Mission, vision, values, and brand story.\n4. **services**: List of all services/products offered (with categories if available).\n5. **target_audience**: Who the company serves (e.g., startups, B2B, education, healthcare).\n6. **founders_and_team**: Names and roles of founders or leadership team.\n7. **slogans_or_taglines**: Any brand slogans, taglines, or mottos.\n8. **social_media_links**: All social media links with platform names (LinkedIn, Instagram, Twitter/X, Facebook, YouTube, TikTok, etc.).\n9. **testimonials_or_clients**: Any testimonials, case studies, or client logos.\n10. **recent_blog_or_news**: Titles + summaries of 3 most recent blog/news posts.\n11. **tone_of_voice**: Brand communication tone (e.g., friendly, expert, playful, technical).\n12. **calls_to_action**: CTAs like “Get Started”, “Book a Demo”, “Contact Us”.\n13. **seo_keywords**: Key phrases that frequently describe the company.\n14. **notable_features_or_differentiators**: What sets this company apart from competitors.\n\nReturn output in **structured JSON format**. Prioritize clarity and value. Ignore unrelated legal, cookie, or footer links.\n\nMake sure all data collected can directly support AI systems that generate brand-aligned social media content. \n\nseparate all data in respective manner    i need their location address as well and plus contact details use web search tool"
        },
        "promptType": "define",
        "hasOutputParser": true
      },
      "typeVersion": 2
    },
    {
      "id": "2c121b2a-172b-40e8-bd85-a1e45e8fcef6",
      "name": "转换为文件以便存储",
      "type": "n8n-nodes-base.convertToFile",
      "position": [
        -4848,
        -560
      ],
      "parameters": {
        "options": {
          "fileName": "={{ $json.output.company_name }}"
        },
        "operation": "toJson"
      },
      "typeVersion": 1.1
    },
    {
      "id": "d8bb3385-4871-41e1-93a7-e3761e9ed10f",
      "name": "便签5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -4928,
        -1392
      ],
      "parameters": {
        "color": 5,
        "width": 592,
        "height": 992,
        "content": "## 将所有提取数据保存到云端硬盘和Supabase"
      },
      "typeVersion": 1
    },
    {
      "id": "bdcc087b-0b3f-499f-a174-e95ba9bcaa91",
      "name": "转换为文件以便存储1",
      "type": "n8n-nodes-base.convertToFile",
      "position": [
        -4864,
        -1104
      ],
      "parameters": {
        "options": {
          "fileName": "={{ $json.output.NAME }}"
        },
        "operation": "toJson"
      },
      "typeVersion": 1.1
    },
    {
      "id": "2d7ff3e1-b712-4c66-948f-4887bd5693f2",
      "name": "保存到Google Drive1",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        -4528,
        -1088
      ],
      "parameters": {
        "name": "={{ $('Information Extractor1').item.json.output.NAME }}",
        "driveId": {
          "__rl": true,
          "mode": "list",
          "value": "My Drive",
          "cachedResultUrl": "https://drive.google.com/drive/my-drive",
          "cachedResultName": "My Drive"
        },
        "options": {},
        "folderId": {
          "__rl": true,
          "mode": "list",
          "value": "1eW5r0x6mSG0xnfq-Hjuc49AbDUg-dgf_",
          "cachedResultUrl": "https://drive.google.com/drive/folders/1eW5r0x6mSG0xnfq-Hjuc49AbDUg-dgf_",
          "cachedResultName": "Companies_profiles"
        }
      },
      "typeVersion": 3
    },
    {
      "id": "46eb337a-8bd3-4d08-b8a6-afc7dcc96682",
      "name": "保存到Supabase",
      "type": "n8n-nodes-base.supabase",
      "position": [
        -4880,
        -1264
      ],
      "parameters": {
        "tableId": "company_basicprofiles",
        "fieldsUi": {
          "fieldValues": [
            {
              "fieldId": "name",
              "fieldValue": "={{ $json.output.NAME }}"
            },
            {
              "fieldId": "summary",
              "fieldValue": "={{ $json.output['Company Summary'] }}"
            },
            {
              "fieldId": "mission",
              "fieldValue": "={{ $json.output['Mission & Vision'].Mission }}"
            },
            {
              "fieldId": "vision",
              "fieldValue": "={{ $json.output['Mission & Vision'].Vision }}"
            },
            {
              "fieldId": "target_audience",
              "fieldValue": "={{ $json.output['Target Audience'] }}"
            },
            {
              "fieldId": "founding_story",
              "fieldValue": "={{ $json.output['Founding Story'] }}"
            },
            {
              "fieldId": "digital_presence",
              "fieldValue": "={{ $json.output['Digital Presence'] }}"
            },
            {
              "fieldId": "visual_identity",
              "fieldValue": "={{ $json.output['Visual Identity'] }}"
            },
            {
              "fieldId": "core_values",
              "fieldValue": "={{ $json.output['Core Brand Values'] }}"
            },
            {
              "fieldId": "products_services",
              "fieldValue": "={{ $json.output['Products/Services'] }}"
            },
            {
              "fieldId": "unique_selling_points",
              "fieldValue": "={{ $json.output['Unique Selling Points (USPs)'] }}"
            }
          ]
        }
      },
      "typeVersion": 1
    },
    {
      "id": "49071423-4a6a-4233-af67-e8e52deb2faa",
      "name": "便签7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -7088,
        -144
      ],
      "parameters": {
        "color": 5,
        "width": 1328,
        "height": 512,
        "content": "# 🌐 AI网站抓取与企业智能工作流"
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "Switch": {
      "main": [
        [],
        [
          {
            "node": "MCP based scraper FIRECRAWLER",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Supabase": {
      "main": [
        [
          {
            "node": "find competitor",
            "type": "main",
            "index": 0
          },
          {
            "node": "social media db",
            "type": "main",
            "index": 0
          },
          {
            "node": "keywords",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "keywords": {
      "main": [
        [
          {
            "node": "No Operation, do nothing",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Supabase4": {
      "main": [
        [
          {
            "node": "No Operation, do nothing",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Web Search tool": {
      "ai_tool": [
        [
          {
            "node": "MCP based scraper FIRECRAWLER",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "find competitor": {
      "main": [
        [
          {
            "node": "Supabase4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "save to Supabase": {
      "main": [
        [
          {
            "node": "No Operation, do nothing",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "basic web scraper": {
      "main": [
        [
          {
            "node": "Information Extractor1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "On form submission": {
      "main": [
        [
          {
            "node": "Switch",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "save to Google Drive1": {
      "main": [
        [
          {
            "node": "No Operation, do nothing",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Information Extractor1": {
      "main": [
        [
          {
            "node": "save to Supabase",
            "type": "main",
            "index": 0
          },
          {
            "node": "Convert to File  for storage1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Structured Output Parser": {
      "ai_outputParser": [
        [
          {
            "node": "find competitor",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "Mistral Cloud Chat Model2": {
      "ai_languageModel": [
        [
          {
            "node": "MCP based scraper FIRECRAWLER",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Mistral Cloud Chat Model3": {
      "ai_languageModel": [
        [
          {
            "node": "find competitor",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Mistral Cloud Chat Model5": {
      "ai_languageModel": [
        [
          {
            "node": "basic web scraper",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Mistral Cloud Chat Model6": {
      "ai_languageModel": [
        [
          {
            "node": "Information Extractor1",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Structured Output Parser1": {
      "ai_outputParser": [
        [
          {
            "node": "MCP based scraper FIRECRAWLER",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "Convert to File  for storage": {
      "main": [
        [
          {
            "node": "Google Drive2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Convert to File  for storage1": {
      "main": [
        [
          {
            "node": "save to Google Drive1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "MCP based scraper FIRECRAWLER": {
      "main": [
        [
          {
            "node": "Supabase",
            "type": "main",
            "index": 0
          },
          {
            "node": "Convert to File  for storage",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流?

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

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

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

需要付费吗?

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

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

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

作者
DIGITAL BIZ TECH

DIGITAL BIZ TECH

@dbt

Digital Biz Tech empowers organizations to unlock their knowledge and creativity with AI. From zero-retention assistants that deliver secure, source-linked answers to intelligent content engines that generate and schedule on-brand campaigns, we transform how teams access, create, and act on information. 📩 For consulting or collaborations, contact shilpa.raaju@digitalbiz.tech

外部链接
在 n8n.io 查看

分享此工作流