8
n8n 中文网amn8n.com

通过 Dumpling AI 抓取 Google Places 并自动保存到 Google Sheets

中级

这是一个AI, IT Ops领域的自动化工作流，包含 6 个节点。主要使用 SplitOut, HttpRequest, GoogleSheets, ScheduleTrigger 等节点，结合人工智能技术实现智能自动化。 通过 Dumpling AI 抓取 Google Places 并自动保存到 Google Sheets

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

使用的节点 (6)

SplitOut
StickyNote
HttpRequest
GoogleSheets
ScheduleTrigger

分类

人工智能
IT 运维
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "id": "zKOSqoH6TJA6fmuM",
  "meta": {
    "instanceId": "a1ae5c8dc6c65e674f9c3947d083abcc749ef2546dff9f4ff01de4d6a36ebfe6",
    "templateCredsSetupCompleted": true
  },
  "name": "通过 Dumpling AI 抓取 Google Places 并自动保存到 Google Sheets",
  "tags": [],
  "nodes": [
    {
      "id": "191b5e95-a169-421a-b922-951055926604",
      "name": "每天下午 1 点运行",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -480,
        -180
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "triggerAtHour": 13
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "1738c371-415e-48cc-8449-48f2c2fc4e53",
      "name": "使用 Dumpling AI 抓取 Google Places",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -20,
        -180
      ],
      "parameters": {
        "url": "https://app.dumplingai.com/api/v1/search-places",
        "method": "POST",
        "options": {},
        "jsonBody": "={\n  \"query\": \"{{ $json['places '] }}\"\n}",
        "sendBody": true,
        "specifyBody": "json",
        "authentication": "genericCredentialType",
        "genericAuthType": "httpHeaderAuth"
      },
      "credentials": {
        "httpHeaderAuth": {
          "id": "RLFzAcGRepr5eXZB",
          "name": "Dumpling AI-n8n"
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "70965a94-732e-4eac-b8c3-fdd3240ed9a7",
      "name": "分割结果地点列表",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        200,
        -180
      ],
      "parameters": {
        "options": {},
        "fieldToSplitOut": "places"
      },
      "typeVersion": 1
    },
    {
      "id": "c017e3c2-8d58-412e-9d5b-41d3ee079a82",
      "name": "将抓取的数据保存到表格",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        420,
        -180
      ],
      "parameters": {
        "columns": {
          "value": {
            "title": "={{ $json.title }}",
            "rating": "={{ $json.rating }}",
            "address": "={{ $json.address }}",
            "website": "={{ $json.website }}",
            "category": "={{ $json.category }}",
            "phoneNumber": "={{ $json.phoneNumber }}"
          },
          "schema": [
            {
              "id": "title",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "title",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "address",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "address",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "rating",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "rating",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "category",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "category",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "phoneNumber",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "phoneNumber",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "website",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "website",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1NkLQ4ZZ3qSv8HybYuKyW2BgViUij68ux4_SnoBphmWE/edit#gid=645811013",
          "cachedResultName": "Sheet 2"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1NkLQ4ZZ3qSv8HybYuKyW2BgViUij68ux4_SnoBphmWE/edit?usp=drivesdk",
          "cachedResultName": "Google places"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "GaJqJHuS5mQxap7q",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "93d4c184-363b-4dac-a87c-c60ec2ec91f8",
      "name": "从表格获取搜索词",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -240,
        -180
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1NkLQ4ZZ3qSv8HybYuKyW2BgViUij68ux4_SnoBphmWE/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1NkLQ4ZZ3qSv8HybYuKyW2BgViUij68ux4_SnoBphmWE/edit?usp=drivesdk",
          "cachedResultName": "Google places"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "GaJqJHuS5mQxap7q",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "dce04c8d-5991-4ddb-86ad-faaaca388048",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -500,
        -360
      ],
      "parameters": {
        "width": 660,
        "height": 240,
        "content": "### 🗺️ 抓取并保存 Google Places 列表"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "c1bbe36f-5b6d-4cd0-827f-67990b139917",
  "connections": {
    "Run Every Day at 1 PM": {
      "main": [
        [
          {
            "node": "Fetch Search Terms from Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Resulting Places List": {
      "main": [
        [
          {
            "node": " Save Scraped Data to Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch Search Terms from Sheet": {
      "main": [
        [
          {
            "node": " Scrape Google Places with Dumpling AI",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    " Scrape Google Places with Dumpling AI": {
      "main": [
        [
          {
            "node": "Split Resulting Places List",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

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

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

中级 - 人工智能, IT 运维

需要付费吗？

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

相关工作流推荐

使用Dumpling AI从Google Drive提取发票数据至Sheets
使用Dumpling AI从Google Drive提取发票数据并保存至Sheets
Code
Split Out
Google Drive
+5
8 节点Yang
人工智能
使用Dumpling AI和GPT-4o自动生成AI新闻评论
使用Dumpling AI和GPT-4o自动生成AI新闻评论
Code
Wait
Split Out
+8
14 节点Yang
人工智能
使用Dumpling AI + GPT-4o根据自动补全建议生成标题
使用Dumpling AI + GPT-4o从自动补全建议生成标题
Set
Split Out
Http Request
+4
8 节点Yang
设计
使用 Dumpling AI 从 URL 抓取书籍，清理 HTML，保存到 Sheets，通过邮件发送 CSV
使用 Dumpling AI 从 URL 抓取书籍，清理 HTML，保存到表格，邮件发送 CSV
Html
Sort
Gmail
+5
11 节点Yang
工程
使用 Dumpling AI 抓取 TikTok 个人资料和文字记录并保存到 Google Sheets
使用 Dumpling AI 抓取 TikTok 个人资料和文字记录并保存到 Google Sheets
Set
Http Request
Google Sheets
+2
6 节点Yang
人工智能
AI新闻简报构建器：使用Dumpling AI抓取网站，GPT-4o摘要
AI新闻简报构建器：Dumpling AI抓取网站，GPT-4o摘要
Set
Code
Gmail
+6
10 节点Yang
人工智能
工作流信息
难度等级
中级
节点数量6
分类2
节点类型5
难度说明

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

作者
Yang

Yang

@yang
外部链接
在 n8n.io 查看 →

分享此工作流