使用Dumpling AI从Google地图提取商业线索并保存到Google表格
初级
这是一个Sales, AI, Marketing领域的自动化工作流，包含 5 个节点。主要使用 SplitOut, HttpRequest, GoogleSheets, ManualTrigger 等节点，结合人工智能技术实现智能自动化。 使用Dumpling AI从Google地图提取商业线索到Google表格
前置要求
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "YZpFvpXOTYkBpiUU",
"meta": {
"instanceId": "a1ae5c8dc6c65e674f9c3947d083abcc749ef2546dff9f4ff01de4d6a36ebfe6"
},
"name": "使用 Dumpling AI 从 Google Maps 提取商业线索并保存到 Google Sheets",
"tags": [
{
"id": "TlcNkmb96fUfZ2eA",
"name": "Tutorials",
"createdAt": "2025-04-15T17:02:00.249Z",
"updatedAt": "2025-04-15T17:02:00.249Z"
}
],
"nodes": [
{
"id": "3a49e594-6c62-4128-825e-99cdfd7e6ed5",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-660,
-200
],
"parameters": {
"width": 600,
"height": 700,
"content": "#### 🔍 工作流目标"
},
"typeVersion": 1
},
{
"id": "0a4ee00a-19cf-4d1e-a145-b5c5619ce636",
"name": "触发器：手动测试运行",
"type": "n8n-nodes-base.manualTrigger",
"position": [
0,
120
],
"parameters": {},
"typeVersion": 1
},
{
"id": "26fdb640-93a0-4312-beaf-4c07fff87751",
"name": "通过 Dumpling AI 搜索 Google Maps",
"type": "n8n-nodes-base.httpRequest",
"position": [
220,
120
],
"parameters": {
"url": "https://app.dumplingai.com/api/v1/search-maps",
"method": "POST",
"options": {},
"jsonBody": "={\n \"query\": \"best+restaurants+in+New+York\", \n \"language\": \"en\"\n}",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth"
},
"credentials": {
"httpHeaderAuth": {
"id": "xamyMqCpAech5BeT",
"name": "Header Auth account"
}
},
"typeVersion": 4.2
},
{
"id": "d3fafc2c-0b9d-4e83-83aa-de24d11fc0e1",
"name": "拆分地点列表进行处理",
"type": "n8n-nodes-base.splitOut",
"position": [
440,
120
],
"parameters": {
"options": {},
"fieldToSplitOut": "places"
},
"typeVersion": 1
},
{
"id": "83b48532-b1fb-4ab3-9596-6e96526bfd49",
"name": "将结果保存到 Google 表格（地点信息）",
"type": "n8n-nodes-base.googleSheets",
"position": [
660,
120
],
"parameters": {
"columns": {
"value": {
"type": "={{ $json.type }}",
"Name ": "={{ $json.title }}",
"rating": "={{ $json.rating }}",
"Address": "={{ $json.address }}",
"Website": "={{ $json.website }}",
"Position": "={{ $json.position }}",
"priceLevel": "={{ $json.priceLevel }}",
"Booking Link": "={{ $json.bookingLinks[0] }}",
"Phone number": "={{ $json.phoneNumber }}"
},
"schema": [
{
"id": "Name ",
"type": "string",
"display": true,
"required": false,
"displayName": "Name ",
"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": "priceLevel",
"type": "string",
"display": true,
"required": false,
"displayName": "priceLevel",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "type",
"type": "string",
"display": true,
"required": false,
"displayName": "type",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "I use an HTTP request in n8n, I returned up to 10",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "I use an HTTP request in n8n, I returned up to 10",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Booking Link",
"type": "string",
"display": true,
"required": false,
"displayName": "Booking Link",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Website",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Website",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone number",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Phone number",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Position",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Position",
"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/1pb4WLqv2EruLM1z9-utehcINolSj0vlUqZionyLoRUs/edit#gid=1069765279",
"cachedResultName": "Google Maps"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1pb4WLqv2EruLM1z9-utehcINolSj0vlUqZionyLoRUs/edit?usp=drivesdk",
"cachedResultName": "Places"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "GaJqJHuS5mQxap7q",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
}
],
"active": false,
"pinData": {
"Search Google Maps via Dumpling AI": [
{
"json": {
"ll": "@40.7381076,-73.9928178,13z",
"places": [
{
"cid": "14366891226444778354",
"fid": "0x89c25993862d9fab:0xc76173738eeacb72",
"type": "French restaurant",
"title": "Boucherie West Village",
"types": [
"French restaurant"
],
"rating": 4.7,
"address": "99 7th Ave S, New York, NY 10014",
"placeId": "ChIJq58thpNZwokRcsvqjnNzYcc",
"website": "https://www.boucherieus.com/",
"latitude": 40.733047,
"position": 1,
"longitude": -74.0028772,
"priceLevel": "$50–100",
"description": "Two-floor bistro serving dry-aged steaks and other French fare, with a bar that's strong on absinthe.",
"phoneNumber": "(212) 837-1616",
"ratingCount": 6138,
"bookingLinks": [
"https://www.opentable.com/restaurant/profile/346609?ref=1068",
"https://www.google.com/maps/reserve/v/dine/c/ECNC2O-BTkI?source=pa&opi=79508299"
],
"openingHours": {
"Friday": "11 AM–12 AM",
"Monday": "11 AM–12 AM",
"Sunday": "10 AM–12 AM",
"Tuesday": "11 AM–12 AM",
"Saturday": "10 AM–12 AM",
"Thursday": "11 AM–12 AM",
"Wednesday": "11 AM–12 AM"
},
"thumbnailUrl": "https://lh3.googleusercontent.com/p/AF1QipOIjrjzX_gCxhEnqpn_1KwaVrrTIdgTOZv9FrJY"
},
{
"cid": "13799948123386944265",
"fid": "0x89c259892cccb7b7:0xbf8343b3f54c1b09",
"type": "French restaurant",
"title": "Balthazar",
"types": [
"French restaurant",
"Bakery",
"Seafood restaurant"
],
"rating": 4.4,
"address": "80 Spring St, New York, NY 10012",
"placeId": "ChIJt7fMLIlZwokRCRtM9bNDg78",
"website": "http://www.balthazarny.com/",
"latitude": 40.722668,
"position": 2,
"longitude": -73.99822979999999,
"priceLevel": "$50–100",
"description": "Iconic French brasserie with steak frites, brunch & pastries in a classy space with red banquettes.",
"phoneNumber": "(212) 965-1414",
"ratingCount": 7020,
"bookingLinks": [
"https://resy.com/cities/new-york-ny/venues/balthazar-nyc?rwg_token=AAiGsoaFc5Wv1TTL-PUVXIuvsKOdGTH7uz27wICtr-QZZbjYmtOgFXVt1boLwB31S7tdch1sPVym_QaoNS3VfiwZhmQrQOLWbA%3D%3D"
],
"openingHours": {
"Friday": "8 AM–12 AM",
"Monday": "8 AM–12 AM",
"Sunday": "9 AM–12 AM",
"Tuesday": "8 AM–12 AM",
"Saturday": "9 AM–12 AM",
"Thursday": "8 AM–12 AM",
"Wednesday": "8 AM–12 AM"
},
"thumbnailUrl": "https://lh3.googleusercontent.com/p/AF1QipMPYp_acWrBa6fa2F0TsosyYI-wDt_rL9wFVcvC"
},
{
"cid": "3132777853886366741",
"fid": "0x89c259a1820824bd:0x2b79dcdc251b8415",
"type": "Restaurant",
"title": "Gramercy Tavern",
"types": [
"Restaurant",
"American restaurant",
"Bar",
"Fine dining restaurant",
"Lunch restaurant",
"New American restaurant"
],
"rating": 4.6,
"address": "42 E 20th St, New York, NY 10003",
"placeId": "ChIJvSQIgqFZwokRFYQbJdzceSs",
"website": "http://www.gramercytavern.com/?utm_source=GoogleBusinessProfile&utm_medium=Website&utm_campaign=MapLabs",
"latitude": 40.7384555,
"position": 3,
"longitude": -73.98850639999999,
"priceLevel": "$100+",
"description": "Danny Meyer's Flatiron District tavern with a fixed-price-only dining room & a bustling bar area.",
"phoneNumber": "(212) 477-0777",
"ratingCount": 4319,
"openingHours": {
"Friday": "11:30 AM–10:30 PM",
"Monday": "11:30 AM–10:30 PM",
"Sunday": "11:30 AM–10:30 PM",
"Tuesday": "11:30 AM–10:30 PM",
"Saturday": "11:30 AM–10:30 PM",
"Thursday": "11:30 AM–10:30 PM",
"Wednesday": "11:30 AM–10:30 PM"
},
"thumbnailUrl": "https://lh3.googleusercontent.com/p/AF1QipP-6Q-5hmlzRWjc4E5FDa7K2OeNqJS3BxQMp_ln"
},
{
"cid": "7298340055988969067",
"fid": "0x89c25947ea10b457:0x6548e99cd73a1e6b",
"type": "French restaurant",
"title": "Le Bernardin",
"types": [
"French restaurant",
"Fine dining restaurant",
"Restaurant"
],
"rating": 4.6,
"address": "155 W 51st St, New York, NY 10019",
"placeId": "ChIJV7QQ6kdZwokRax4615zpSGU",
"website": "https://www.le-bernardin.com/home",
"latitude": 40.7614218,
"position": 4,
"longitude": -73.9817558,
"priceLevel": "$100+",
"description": "Elite French restaurant offers chef Eric Ripert's refined seafood, expert service & luxurious decor.",
"phoneNumber": "(212) 554-1515",
"ratingCount": 3762,
"openingHours": {
"Friday": "12–2:30 PM, 5–11 PM",
"Monday": "12–2:30 PM, 5–10:30 PM",
"Sunday": "Closed",
"Tuesday": "12–2:30 PM, 5–10:30 PM",
"Saturday": "5–11 PM",
"Thursday": "12–2:30 PM, 5–10:30 PM",
"Wednesday": "12–2:30 PM, 5–10:30 PM"
},
"thumbnailUrl": "https://lh3.googleusercontent.com/p/AF1QipMC-dJ9gfcpFIX8PS-8yPYhjCMfjl6q35zAn1t8"
},
{
"cid": "3442553861032018645",
"fid": "0x89c259a1ec5f5573:0x2fc6687f46f682d5",
"type": "French restaurant",
"title": "Boucherie Union Square",
"types": [
"French restaurant",
"Steak house"
],
"rating": 4.7,
"address": "225 Park Ave S, New York, NY 10003",
"placeId": "ChIJc1Vf7KFZwokR1YL2Rn9oxi8",
"website": "https://www.boucherieus.com/",
"latitude": 40.7372552,
"position": 5,
"longitude": -73.9882246,
"priceLevel": "$50–100",
"description": "Bistro for dry-aged steaks and other French fare, with a bar that's strong on absinthe.",
"phoneNumber": "(212) 353-0200",
"ratingCount": 3890,
"bookingLinks": [
"https://www.opentable.com/restaurant/profile/1004143?ref=1068",
"https://www.google.com/maps/reserve/v/dine/c/4rmpVcuKUVY?source=pa&opi=79508299"
],
"openingHours": {
"Friday": "11 AM–12 AM",
"Monday": "11 AM–12 AM",
"Sunday": "11 AM–12 AM",
"Tuesday": "11 AM–12 AM",
"Saturday": "11 AM–12 AM",
"Thursday": "11 AM–12 AM",
"Wednesday": "11 AM–12 AM"
},
"thumbnailUrl": "https://lh3.googleusercontent.com/p/AF1QipOa4JTlKpkY1_xlxnfahmd6H2FquTfCHzJJWto7"
},
{
"cid": "5472139628830047106",
"fid": "0x89c2598c596508a3:0x4bf0f1fff1c0bb82",
"type": "Italian restaurant",
"title": "Piccola Cucina Osteria Siciliana",
"types": [
"Italian restaurant",
"Sicilian restaurant"
],
"rating": 4.6,
"address": "196 Spring St, New York, NY 10012",
"placeId": "ChIJowhlWYxZwokRgrvA8f_x8Es",
"website": "http://www.piccolacucinagroup.com/",
"latitude": 40.7250308,
"position": 6,
"longitude": -74.0032774,
"priceLevel": "$30–50",
"description": "Simple Italian outpost serving salads & homestyle pastas along with an extensive wine list.",
"phoneNumber": "(646) 478-7488",
"ratingCount": 2199,
"bookingLinks": [
"https://www.opentable.com/restaurant/profile/105838?ref=1068",
"https://www.google.com/maps/reserve/v/dine/c/Psao8Sv98GA?source=pa&opi=79508299"
],
"openingHours": {
"Friday": "11:30 AM–11 PM",
"Monday": "11:30 AM–11 PM",
"Sunday": "11:30 AM–11 PM",
"Tuesday": "11:30 AM–11 PM",
"Saturday": "11:30 AM–11 PM",
"Thursday": "11:30 AM–11 PM",
"Wednesday": "11:30 AM–11 PM"
},
"thumbnailUrl": "https://lh3.googleusercontent.com/p/AF1QipMk3ppXOP_aW2Yrb-krDInf1tjUY6K8adRhg5XT"
},
{
"cid": "12751425680490052044",
"fid": "0x89c258fbc4a06f31:0xb0f62a18b16739cc",
"type": "Restaurant",
"title": "The Modern",
"types": [
"Restaurant",
"American restaurant",
"Fine dining restaurant",
"French restaurant",
"Lunch restaurant",
"New American restaurant"
],
"rating": 4.6,
"address": "9 W 53rd St, New York, NY 10019",
"placeId": "ChIJMW-gxPtYwokRzDlnsRgq9rA",
"website": "https://www.themodernnyc.com/?utm_source=GoogleBusinessProfile&utm_medium=Website&utm_campaign=MapLabs",
"latitude": 40.761081,
"position": 7,
"longitude": -73.976753,
"priceLevel": "$100+",
"description": "French/New American fare in a modernist space with garden views at the Museum of Modern Art.",
"phoneNumber": "(212) 333-1220",
"ratingCount": 2477,
"bookingLinks": [
"https://resy.com/cities/new-york-ny/venues/the-modern?rwg_token=AAiGsobdabLYAQWI0wKR3bXQzJR2xZTshjVp3Uxere391AzDkVal9-Ur8wUduvr_d8bjXUYgsQ2UBTV3fUaQ4cK8AL4sIDHf9g%3D%3D",
"https://www.google.com/maps/reserve/v/dine/c/IqhMF1j7prg?source=pa&opi=79508299"
],
"openingHours": {
"Friday": "12–2 PM, 5–9 PM",
"Monday": "12–2 PM, 5:30–9 PM",
"Sunday": "12–2 PM",
"Tuesday": "12–2 PM, 5:30–9 PM",
"Saturday": "12–2 PM, 5–9 PM",
"Thursday": "12–2 PM, 5:30–9 PM",
"Wednesday": "12–2 PM, 5:30–9 PM"
},
"thumbnailUrl": "https://lh3.googleusercontent.com/p/AF1QipPFegcqnHSeW_Ngyd9kDff_bofmJx6cA0Woh95o"
},
{
"cid": "12769026215543562150",
"fid": "0x89c259941967edc9:0xb134b1b0991fdfa6",
"type": "French restaurant",
"title": "Petite Boucherie",
"types": [
"French restaurant"
],
"rating": 4.7,
"address": "First Floor, 14 Christopher St, New York, NY 10014",
"placeId": "ChIJye1nGZRZwokRpt8fmbCxNLE",
"website": "https://www.boucherieus.com/",
"latitude": 40.733870599999996,
"position": 8,
"longitude": -74.0004319,
"priceLevel": "$50–100",
"description": "Parisian-style cafe serving comforting French fare in a snug space with an open kitchen.",
"phoneNumber": "(646) 756-4145",
"ratingCount": 1787,
"bookingLinks": [
"https://www.opentable.com/restaurant/profile/157048?ref=1068",
"https://www.google.com/maps/reserve/v/dine/c/E_LrlO_LqlY?source=pa&opi=79508299"
],
"openingHours": {
"Friday": "11 AM–12 AM",
"Monday": "11 AM–12 AM",
"Sunday": "10 AM–12 AM",
"Tuesday": "11 AM–12 AM",
"Saturday": "10 AM–12 AM",
"Thursday": "11 AM–12 AM",
"Wednesday": "11 AM–12 AM"
},
"thumbnailUrl": "https://lh3.googleusercontent.com/p/AF1QipO9zp1up2rYreJpE-GCYOSwGAiFxyl_iQO2No91"
},
{
"cid": "6967162704871465124",
"fid": "0x89c25bc797d635a1:0x60b055910436a0a4",
"type": "Restaurant",
"title": "Manhatta",
"types": [
"Restaurant",
"Bar",
"Cocktail bar",
"Event venue",
"Fine dining restaurant",
"New American restaurant",
"Wine bar"
],
"rating": 4.7,
"address": "28 Liberty St 60th floor, New York, NY 10005",
"placeId": "ChIJoTXWl8dbwokRpKA2BJFVsGA",
"website": "https://www.manhattarestaurant.com/?utm_source=GoogleBusinessProfile&utm_medium=Website&utm_campaign=MapLabs",
"latitude": 40.707997399999996,
"position": 9,
"longitude": -74.00888259999999,
"priceLevel": "$100+",
"description": "Set on the 60th floor, this ritzy, high-end restaurant features New American cuisine and city views.",
"phoneNumber": "(212) 230-5788",
"ratingCount": 2764,
"bookingLinks": [
"https://www.google.com/maps/reserve/v/dine/c/pyjjUZqJ9lQ?source=pa&opi=79508299"
],
"openingHours": {
"Friday": "11:30 AM–10:30 PM",
"Monday": "11:30 AM–9:30 PM",
"Sunday": "11:30 AM–9:30 PM",
"Tuesday": "11:30 AM–9:30 PM",
"Saturday": "11:30 AM–10:30 PM",
"Thursday": "11:30 AM–9:30 PM",
"Wednesday": "11:30 AM–9:30 PM"
},
"thumbnailUrl": "https://lh3.googleusercontent.com/p/AF1QipObmWt-zmje4apfGS8o6xO7AQ2Y38KE_0Nzlo3L"
},
{
"cid": "8813431814842646952",
"fid": "0x89c25986daaa7ce7:0x7a4f998a3fd281a8",
"type": "American restaurant",
"title": "Russ & Daughters Cafe",
"types": [
"American restaurant",
"Breakfast restaurant",
"Brunch restaurant",
"Jewish restaurant",
"Lunch restaurant",
"Restaurant"
],
"rating": 4.6,
"address": "127 Orchard St, New York, NY 10002",
"placeId": "ChIJ53yq2oZZwokRqIHSP4qZT3o",
"website": "https://russanddaughterscafe.com/",
"latitude": 40.7196181,
"position": 10,
"longitude": -73.9895779,
"priceLevel": "$20–30",
"description": "From a legendary appetizing shop comes this retro, full-service outpost serving Jewish comfort food.",
"phoneNumber": "(212) 475-4881",
"ratingCount": 3319,
"openingHours": {
"Friday": "8:30 AM–3:30 PM",
"Monday": "8:30 AM–2:30 PM",
"Sunday": "8:30 AM–3:30 PM",
"Tuesday": "8:30 AM–2:30 PM",
"Saturday": "8:30 AM–3:30 PM",
"Thursday": "8:30 AM–2:30 PM",
"Wednesday": "8:30 AM–2:30 PM"
},
"thumbnailUrl": "https://lh3.googleusercontent.com/p/AF1QipPCCdN4u4VxmoNVS3aFIXzgR3lvU2XOcmHf_our"
},
{
"cid": "2975234135803511093",
"fid": "0x89c25996bd0915fd:0x294a27aedc2f4135",
"type": "Italian restaurant",
"title": "OLIO E PIÙ",
"types": [
"Italian restaurant",
"Restaurant"
],
"rating": 4.7,
"address": "3 Greenwich Ave, New York, NY 10014",
"placeId": "ChIJ_RUJvZZZwokRNUEv3K4nSik",
"website": "https://www.olioepiu.com/",
"latitude": 40.7338208,
"position": 11,
"longitude": -73.99979309999999,
"priceLevel": "$50–100",
"description": "Naples meets NYC at this trattoria with thin-crust pizza, Italian wines & ample sidewalk seating.",
"phoneNumber": "(212) 243-6546",
"ratingCount": 8301,
"bookingLinks": [
"https://www.opentable.com/restaurant/profile/55837?ref=1068",
"https://www.google.com/maps/reserve/v/dine/c/2Ujk-qKjG0Y?source=pa&opi=79508299"
],
"openingHours": {
"Friday": "11 AM–12 AM",
"Monday": "11 AM–12 AM",
"Sunday": "10 AM–12 AM",
"Tuesday": "11 AM–12 AM",
"Saturday": "10 AM–12 AM",
"Thursday": "11 AM–12 AM",
"Wednesday": "11 AM–12 AM"
},
"thumbnailUrl": "https://lh3.googleusercontent.com/p/AF1QipNdy8VOWBkFpkuFzY4WdZ0v7TRcquFXviC1hFyW"
},
{
"cid": "5618924015427954654",
"fid": "0x89c2585492286ae9:0x4dfa6d9f277ea7de",
"type": "Taco restaurant",
"title": "LOS TACOS No.1",
"types": [
"Taco restaurant",
"Mexican restaurant"
],
"rating": 4.8,
"address": "229 W 43rd St, New York, NY 10036",
"placeId": "ChIJ6WooklRYwokR3qd-J59t-k0",
"website": "http://www.lostacos1.com/",
"latitude": 40.757321399999995,
"position": 12,
"longitude": -73.98765399999999,
"priceLevel": "$10–20",
"description": "Small pit stop with standing tables serving authentic Mexican street food.",
"ratingCount": 12659,
"openingHours": {
"Friday": "11 AM–11 PM",
"Monday": "11 AM–11 PM",
"Sunday": "11 AM–9 PM",
"Tuesday": "11 AM–11 PM",
"Saturday": "11 AM–11 PM",
"Thursday": "11 AM–11 PM",
"Wednesday": "11 AM–11 PM"
},
"thumbnailUrl": "https://lh3.googleusercontent.com/p/AF1QipPaLR3wTNi8SIIqvDFYGFJ-nG_sAiR6sZCOFqOZ"
},
{
"cid": "16472713729583313083",
"fid": "0x89c259937f4eb1af:0xe49ad5dc628370bb",
"type": "Italian restaurant",
"title": "Via Carota",
"types": [
"Italian restaurant"
],
"rating": 4.4,
"address": "51 Grove St, New York, NY 10014",
"placeId": "ChIJr7FOf5NZwokRu3CDYtzVmuQ",
"website": "http://viacarota.com/",
"latitude": 40.7331437,
"position": 13,
"longitude": -74.0036671,
"priceLevel": "$50–100",
"description": "Italian trattoria serving traditional plates & apéritifs in a rustic, cozy space.",
"phoneNumber": "(212) 255-1962",
"ratingCount": 2842,
"openingHours": {
"Friday": "10 AM–11 PM",
"Monday": "11 AM–11 PM",
"Sunday": "10 AM–11 PM",
"Tuesday": "11 AM–11 PM",
"Saturday": "10 AM–11 PM",
"Thursday": "11 AM–11 PM",
"Wednesday": "11 AM–11 PM"
},
"thumbnailUrl": "https://lh3.googleusercontent.com/p/AF1QipOpMXlOGFvZovcoxb-XjqCV2kdYQHODTlpUbc8I"
},
{
"cid": "9312603855358623759",
"fid": "0x89c259f337272b95:0x813d03ddbc95800f",
"type": "American restaurant",
"title": "RH Rooftop Restaurant at RH New York",
"types": [
"American restaurant",
"Restaurant"
],
"rating": 4.4,
"address": "9 9th Ave, New York, NY 10014",
"placeId": "ChIJlSsnN_NZwokRD4CVvN0DPYE",
"website": "http://www.rh.com/newyork/restaurant",
"latitude": 40.73985,
"position": 14,
"longitude": -74.00639,
"priceLevel": "$50–100",
"description": "Glamorous rooftop restaurant offering American fare amid chandeliers, greenery, and skyline views.",
"phoneNumber": "(212) 217-2210",
"ratingCount": 2176,
"bookingLinks": [
"https://www.opentable.com/restaurant/profile/1050247?ref=1068",
"https://www.google.com/maps/reserve/v/dine/c/YEEToh7bBlo?source=pa&opi=79508299"
],
"openingHours": {
"Friday": "11:30 AM–9 PM",
"Monday": "11:30 AM–9 PM",
"Sunday": "10 AM–9 PM",
"Tuesday": "11:30 AM–9 PM",
"Saturday": "10 AM–9 PM",
"Thursday": "11:30 AM–9 PM",
"Wednesday": "11:30 AM–9 PM"
},
"thumbnailUrl": "https://lh3.googleusercontent.com/p/AF1QipNrIo_odwUa7D5xnOrEfdeOq7vGMprNLMPnyOhT"
},
{
"cid": "18303949408079626176",
"fid": "0x89c25b5ac3fc353f:0xfe04b102174ebfc0",
"type": "Taco restaurant",
"title": "LOS TACOS No.1",
"types": [
"Taco restaurant",
"Restaurant"
],
"rating": 4.7,
"address": "75 9th Ave, New York, NY 10011",
"placeId": "ChIJPzX8w1pbwokRwL9OFwKxBP4",
"website": "https://www.lostacos1.com/",
"latitude": 40.742252099999995,
"position": 15,
"longitude": -74.0059635,
"priceLevel": "$10–20",
"description": "Bustling taqueria serving tacos, quesadillas & aguas frescas in a street-style setup (no seating).",
"ratingCount": 4772,
"openingHours": {
"Friday": "11 AM–10 PM",
"Monday": "11 AM–10 PM",
"Sunday": "11 AM–9 PM",
"Tuesday": "11 AM–10 PM",
"Saturday": "11 AM–10 PM",
"Thursday": "11 AM–10 PM",
"Wednesday": "11 AM–10 PM"
},
"thumbnailUrl": "https://lh3.googleusercontent.com/p/AF1QipPqkAkh_eP9f-WUBiRoN-_nlyKVWCSTUp-47dpu"
},
{
"cid": "1412917795118885020",
"fid": "0x89c2598c5dde0695:0x139bb13faae3a89c",
"type": "Italian restaurant",
"title": "Piccola Cucina Estiatorio",
"types": [
"Italian restaurant",
"Seafood market"
],
"rating": 4.7,
"address": "75 Thompson St, New York, NY 10012",
"placeId": "ChIJlQbeXYxZwokRnKjjqj-xmxM",
"website": "http://www.piccolacucinagroup.com/",
"latitude": 40.7246336,
"position": 16,
"longitude": -74.00297619999999,
"priceLevel": "$30–50",
"phoneNumber": "(646) 781-9183",
"ratingCount": 1660,
"bookingLinks": [
"https://www.opentable.com/restaurant/profile/343939?ref=1068",
"https://www.google.com/maps/reserve/v/dine/c/pcvDAa-RKIU?source=pa&opi=79508299"
],
"openingHours": {
"Friday": "11:30 AM–12 AM",
"Monday": "11:30 AM–11 PM",
"Sunday": "11:30 AM–11 PM",
"Tuesday": "11:30 AM–11 PM",
"Saturday": "11:30 AM–12 AM",
"Thursday": "11:30 AM–11 PM",
"Wednesday": "11:30 AM–11 PM"
},
"thumbnailUrl": "https://lh3.googleusercontent.com/p/AF1QipNoIV4fOazNCv4q04hA-CLCxMmuV9q3-ua81HR8"
},
{
"cid": "6783566240304368229",
"fid": "0x89c258f62fec73a7:0x5e24118dffac8a65",
"type": "Fine dining restaurant",
"title": "Per Se",
"types": [
"Fine dining restaurant",
"French restaurant"
],
"rating": 4.5,
"address": "10 Columbus Cir, New York, NY 10019",
"placeId": "ChIJp3PsL_ZYwokRZYqs_40RJF4",
"website": "https://www.thomaskeller.com/perseny",
"latitude": 40.768217799999995,
"position": 17,
"longitude": -73.9828988,
"priceLevel": "$100+",
"description": "Chef Thomas Keller's New American restaurant offers luxe fixed-price menus, with Central Park views.",
"phoneNumber": "(212) 823-9335",
"ratingCount": 1863,
"openingHours": {
"Friday": "4:30–8:30 PM",
"Monday": "4:30–8:30 PM",
"Sunday": "4:30–8:30 PM",
"Tuesday": "4:30–8:30 PM",
"Saturday": "4:30–8:30 PM",
"Thursday": "4:30–8:30 PM",
"Wednesday": "4:30–8:30 PM"
},
"thumbnailUrl": "https://lh3.googleusercontent.com/p/AF1QipO7nQNiCyD5Fw4CUQ17RSfRfjX-pDQkD26wXJHy"
},
{
"cid": "3538632692129109557",
"fid": "0x89c258f6339d1b6f:0x311bbfaf5cf09635",
"type": "American restaurant",
"title": "ROBERT",
"types": [
"American restaurant"
],
"rating": 4.5,
"address": "2 Columbus Cir, New York, NY 10019",
"placeId": "ChIJbxudM_ZYwokRNZbwXK-_GzE",
"website": "https://robertnyc.com/",
"latitude": 40.767438,
"position": 18,
"longitude": -73.9819871,
"priceLevel": "$$$",
"description": "New American fare & city views in an arty space on the top-floor of the Museum of Arts & Design.",
"phoneNumber": "(212) 299-7730",
"ratingCount": 1719,
"bookingLinks": [
"https://www.opentable.com/r/robert-new-york"
],
"openingHours": {
"Friday": "12–11 PM",
"Monday": "12–10 PM",
"Sunday": "11 AM–11 PM",
"Tuesday": "12–10 PM",
"Saturday": "11 AM–11 PM",
"Thursday": "12–10 PM",
"Wednesday": "12–10 PM"
},
"thumbnailUrl": "https://lh3.googleusercontent.com/p/AF1QipMn17D7rwlR14fK8bCmgxV_UqzsK4fBzNP6fFaw"
},
{
"cid": "3545819340560108778",
"fid": "0x89c2598f7ff4aa09:0x313547e757cb8cea",
"type": "Restaurant",
"title": "Katz's Delicatessen",
"types": [
"Restaurant",
"American restaurant",
"Jewish restaurant",
"Deli",
"Sandwich shop"
],
"rating": 4.5,
"address": "205 E Houston St, New York, NY 10002",
"placeId": "ChIJCar0f49ZwokR6ozLV-dHNTE",
"website": "https://katzsdelicatessen.com/",
"latitude": 40.722232999999996,
"position": 19,
"longitude": -73.98742899999999,
"priceLevel": "$20–30",
"description": "No-frills deli with theatrically cranky service serving mile-high sandwiches since 1888.",
"phoneNumber": "(212) 254-2246",
"ratingCount": 44962,
"openingHours": {
"Friday": "8 AM–11:30 PM",
"Monday": "8 AM–11 PM",
"Sunday": "12 AM–11 PM",
"Tuesday": "8 AM–11 PM",
"Saturday": "Open 24 hours",
"Thursday": "8 AM–11 PM",
"Wednesday": "8 AM–11 PM"
},
"thumbnailUrl": "https://lh3.googleusercontent.com/p/AF1QipNedb29MPPEqzCoheQ79l26VPnn6dcTGtcvF4w7"
},
{
"cid": "1614607817747620329",
"fid": "0x89c25a1f689722d3:0x16683d41746a61e9",
"type": "Cajun restaurant",
"title": "1803 NYC",
"types": [
"Cajun restaurant",
"Bar",
"Brunch restaurant",
"Creole restaurant",
"Event venue",
"Live music venue",
"Lunch restaurant",
"Restaurant",
"Seafood restaurant",
"Soul food restaurant"
],
"rating": 4.5,
"address": "82 Reade St, New York, NY 10007",
"placeId": "ChIJ0yKXaB9awokR6WFqdEE9aBY",
"website": "https://1803nyc.com/",
"latitude": 40.7154539,
"position": 20,
"longitude": -74.00733009999999,
"priceLevel": "$30–50",
"description": "Elevated Cajun-Creole food and drinks served in a New Orleans's French quarters-inspired restaurant.",
"phoneNumber": "(212) 267-3000",
"ratingCount": 1791,
"bookingLinks": [
"https://1803nyc.com/#reservation",
"https://resy.com/cities/new-york-ny/venues/1803?rwg_token=AAiGsoZQZUVMZ4dhDz6Sg9qsvG6tjLIhQZvXBSU9opEklGTc20X2Oby6LmmRgAp1IrhjAUd79G_k3s0VP3tEuEu5J_T1DCCazwmMhQpGVRyVaiJWH8RBrM0%3D",
"https://www.google.com/maps/reserve/v/dine/c/knKVX6xdexM?source=pa&opi=79508299"
],
"openingHours": {
"Friday": "11:30 AM–11 PM",
"Monday": "11:30 AM–11 PM",
"Sunday": "11 AM–11 PM",
"Tuesday": "11:30 AM–11 PM",
"Saturday": "11 AM–12 AM",
"Thursday": "11:30 AM–11 PM",
"Wednesday": "11:30 AM–11 PM"
},
"thumbnailUrl": "https://lh3.googleusercontent.com/p/AF1QipMD6CTvhAgGtyrqyIkqwTB_iiJh1FKAdDcV_XKA"
}
],
"credits": 3,
"searchParameters": {
"q": "best+restaurants+in+New+York",
"hl": "en",
"type": "maps",
"engine": "google"
}
}
}
],
"Save Results to Google Sheet (Place Info)": [
{
"json": {
"type": "French restaurant",
"Name ": "Boucherie West Village",
"rating": 4.7,
"Address": "99 7th Ave S, New York, NY 10014",
"Website": "https://www.boucherieus.com/",
"Position": 1,
"priceLevel": "$50–100",
"Description": "Two-floor bistro serving dry-aged steaks and other French fare, with a bar that's strong on absinthe.",
"Booking Link": "https://www.opentable.com/restaurant/profile/346609?ref=1068",
"Phone number": "(212) 837-1616"
}
},
{
"json": {
"type": "French restaurant",
"Name ": "Balthazar",
"rating": 4.4,
"Address": "80 Spring St, New York, NY 10012",
"Website": "http://www.balthazarny.com/",
"Position": 2,
"priceLevel": "$50–100",
"Description": "Iconic French brasserie with steak frites, brunch & pastries in a classy space with red banquettes.",
"Booking Link": "https://resy.com/cities/new-york-ny/venues/balthazar-nyc?rwg_token=AAiGsoaFc5Wv1TTL-PUVXIuvsKOdGTH7uz27wICtr-QZZbjYmtOgFXVt1boLwB31S7tdch1sPVym_QaoNS3VfiwZhmQrQOLWbA%3D%3D",
"Phone number": "(212) 965-1414"
}
},
{
"json": {
"type": "Restaurant",
"Name ": "Gramercy Tavern",
"rating": 4.6,
"Address": "42 E 20th St, New York, NY 10003",
"Website": "http://www.gramercytavern.com/?utm_source=GoogleBusinessProfile&utm_medium=Website&utm_campaign=MapLabs",
"Position": 3,
"priceLevel": "$100+",
"Description": "Danny Meyer's Flatiron District tavern with a fixed-price-only dining room & a bustling bar area.",
"Phone number": "(212) 477-0777"
}
},
{
"json": {
"type": "French restaurant",
"Name ": "Le Bernardin",
"rating": 4.6,
"Address": "155 W 51st St, New York, NY 10019",
"Website": "https://www.le-bernardin.com/home",
"Position": 4,
"priceLevel": "$100+",
"Description": "Elite French restaurant offers chef Eric Ripert's refined seafood, expert service & luxurious decor.",
"Phone number": "(212) 554-1515"
}
},
{
"json": {
"type": "French restaurant",
"Name ": "Boucherie Union Square",
"rating": 4.7,
"Address": "225 Park Ave S, New York, NY 10003",
"Website": "https://www.boucherieus.com/",
"Position": 5,
"priceLevel": "$50–100",
"Description": "Bistro for dry-aged steaks and other French fare, with a bar that's strong on absinthe.",
"Booking Link": "https://www.opentable.com/restaurant/profile/1004143?ref=1068",
"Phone number": "(212) 353-0200"
}
},
{
"json": {
"type": "Italian restaurant",
"Name ": "Piccola Cucina Osteria Siciliana",
"rating": 4.6,
"Address": "196 Spring St, New York, NY 10012",
"Website": "http://www.piccolacucinagroup.com/",
"Position": 6,
"priceLevel": "$30–50",
"Description": "Simple Italian outpost serving salads & homestyle pastas along with an extensive wine list.",
"Booking Link": "https://www.opentable.com/restaurant/profile/105838?ref=1068",
"Phone number": "(646) 478-7488"
}
},
{
"json": {
"type": "Restaurant",
"Name ": "The Modern",
"rating": 4.6,
"Address": "9 W 53rd St, New York, NY 10019",
"Website": "https://www.themodernnyc.com/?utm_source=GoogleBusinessProfile&utm_medium=Website&utm_campaign=MapLabs",
"Position": 7,
"priceLevel": "$100+",
"Description": "French/New American fare in a modernist space with garden views at the Museum of Modern Art.",
"Booking Link": "https://resy.com/cities/new-york-ny/venues/the-modern?rwg_token=AAiGsobdabLYAQWI0wKR3bXQzJR2xZTshjVp3Uxere391AzDkVal9-Ur8wUduvr_d8bjXUYgsQ2UBTV3fUaQ4cK8AL4sIDHf9g%3D%3D",
"Phone number": "(212) 333-1220"
}
},
{
"json": {
"type": "French restaurant",
"Name ": "Petite Boucherie",
"rating": 4.7,
"Address": "First Floor, 14 Christopher St, New York, NY 10014",
"Website": "https://www.boucherieus.com/",
"Position": 8,
"priceLevel": "$50–100",
"Description": "Parisian-style cafe serving comforting French fare in a snug space with an open kitchen.",
"Booking Link": "https://www.opentable.com/restaurant/profile/157048?ref=1068",
"Phone number": "(646) 756-4145"
}
},
{
"json": {
"type": "Restaurant",
"Name ": "Manhatta",
"rating": 4.7,
"Address": "28 Liberty St 60th floor, New York, NY 10005",
"Website": "https://www.manhattarestaurant.com/?utm_source=GoogleBusinessProfile&utm_medium=Website&utm_campaign=MapLabs",
"Position": 9,
"priceLevel": "$100+",
"Description": "Set on the 60th floor, this ritzy, high-end restaurant features New American cuisine and city views.",
"Booking Link": "https://www.google.com/maps/reserve/v/dine/c/pyjjUZqJ9lQ?source=pa&opi=79508299",
"Phone number": "(212) 230-5788"
}
},
{
"json": {
"type": "American restaurant",
"Name ": "Russ & Daughters Cafe",
"rating": 4.6,
"Address": "127 Orchard St, New York, NY 10002",
"Website": "https://russanddaughterscafe.com/",
"Position": 10,
"priceLevel": "$20–30",
"Description": "From a legendary appetizing shop comes this retro, full-service outpost serving Jewish comfort food.",
"Phone number": "(212) 475-4881"
}
},
{
"json": {
"type": "Italian restaurant",
"Name ": "OLIO E PIÙ",
"rating": 4.7,
"Address": "3 Greenwich Ave, New York, NY 10014",
"Website": "https://www.olioepiu.com/",
"Position": 11,
"priceLevel": "$50–100",
"Description": "Naples meets NYC at this trattoria with thin-crust pizza, Italian wines & ample sidewalk seating.",
"Booking Link": "https://www.opentable.com/restaurant/profile/55837?ref=1068",
"Phone number": "(212) 243-6546"
}
},
{
"json": {
"type": "Taco restaurant",
"Name ": "LOS TACOS No.1",
"rating": 4.8,
"Address": "229 W 43rd St, New York, NY 10036",
"Website": "http://www.lostacos1.com/",
"Position": 12,
"priceLevel": "$10–20",
"Description": "Small pit stop with standing tables serving authentic Mexican street food."
}
},
{
"json": {
"type": "Italian restaurant",
"Name ": "Via Carota",
"rating": 4.4,
"Address": "51 Grove St, New York, NY 10014",
"Website": "http://viacarota.com/",
"Position": 13,
"priceLevel": "$50–100",
"Description": "Italian trattoria serving traditional plates & apéritifs in a rustic, cozy space.",
"Phone number": "(212) 255-1962"
}
},
{
"json": {
"type": "American restaurant",
"Name ": "RH Rooftop Restaurant at RH New York",
"rating": 4.4,
"Address": "9 9th Ave, New York, NY 10014",
"Website": "http://www.rh.com/newyork/restaurant",
"Position": 14,
"priceLevel": "$50–100",
"Description": "Glamorous rooftop restaurant offering American fare amid chandeliers, greenery, and skyline views.",
"Booking Link": "https://www.opentable.com/restaurant/profile/1050247?ref=1068",
"Phone number": "(212) 217-2210"
}
},
{
"json": {
"type": "Taco restaurant",
"Name ": "LOS TACOS No.1",
"rating": 4.7,
"Address": "75 9th Ave, New York, NY 10011",
"Website": "https://www.lostacos1.com/",
"Position": 15,
"priceLevel": "$10–20",
"Description": "Bustling taqueria serving tacos, quesadillas & aguas frescas in a street-style setup (no seating)."
}
},
{
"json": {
"type": "Italian restaurant",
"Name ": "Piccola Cucina Estiatorio",
"rating": 4.7,
"Address": "75 Thompson St, New York, NY 10012",
"Website": "http://www.piccolacucinagroup.com/",
"Position": 16,
"priceLevel": "$30–50",
"Booking Link": "https://www.opentable.com/restaurant/profile/343939?ref=1068",
"Phone number": "(646) 781-9183"
}
},
{
"json": {
"type": "Fine dining restaurant",
"Name ": "Per Se",
"rating": 4.5,
"Address": "10 Columbus Cir, New York, NY 10019",
"Website": "https://www.thomaskeller.com/perseny",
"Position": 17,
"priceLevel": "$100+",
"Description": "Chef Thomas Keller's New American restaurant offers luxe fixed-price menus, with Central Park views.",
"Phone number": "(212) 823-9335"
}
},
{
"json": {
"type": "American restaurant",
"Name ": "ROBERT",
"rating": 4.5,
"Address": "2 Columbus Cir, New York, NY 10019",
"Website": "https://robertnyc.com/",
"Position": 18,
"priceLevel": "$$$",
"Description": "New American fare & city views in an arty space on the top-floor of the Museum of Arts & Design.",
"Booking Link": "https://www.opentable.com/r/robert-new-york",
"Phone number": "(212) 299-7730"
}
},
{
"json": {
"type": "Restaurant",
"Name ": "Katz's Delicatessen",
"rating": 4.5,
"Address": "205 E Houston St, New York, NY 10002",
"Website": "https://katzsdelicatessen.com/",
"Position": 19,
"priceLevel": "$20–30",
"Description": "No-frills deli with theatrically cranky service serving mile-high sandwiches since 1888.",
"Phone number": "(212) 254-2246"
}
},
{
"json": {
"type": "Cajun restaurant",
"Name ": "1803 NYC",
"rating": 4.5,
"Address": "82 Reade St, New York, NY 10007",
"Website": "https://1803nyc.com/",
"Position": 20,
"priceLevel": "$30–50",
"Description": "Elevated Cajun-Creole food and drinks served in a New Orleans's French quarters-inspired restaurant.",
"Booking Link": "https://1803nyc.com/#reservation",
"Phone number": "(212) 267-3000"
}
}
]
},
"settings": {
"executionOrder": "v1"
},
"versionId": "171ef405-bac6-42c0-a3c3-c28cb49ff21a",
"connections": {
"Trigger: Manual Test Run": {
"main": [
[
{
"node": "Search Google Maps via Dumpling AI",
"type": "main",
"index": 0
}
]
]
},
"Split Places List for Processing": {
"main": [
[
{
"node": "Save Results to Google Sheet (Place Info)",
"type": "main",
"index": 0
}
]
]
},
"Search Google Maps via Dumpling AI": {
"main": [
[
{
"node": "Split Places List for Processing",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
初级 - 销售, 人工智能, 营销
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
AI新闻简报构建器：使用Dumpling AI抓取网站，GPT-4o摘要
AI新闻简报构建器：Dumpling AI抓取网站，GPT-4o摘要
Set
Code
Gmail
+6
10 节点Yang
人工智能
使用Dumpling AI和GPT-4o自动生成AI新闻评论
使用Dumpling AI和GPT-4o自动生成AI新闻评论
Code
Wait
Split Out
+8
14 节点Yang
人工智能
使用Dumpling AI和GPT-4o从文章自动生成LinkedIn帖子
使用Dumpling AI和GPT-4o从文章自动生成LinkedIn帖子
Set
Http Request
Google Sheets
+4
10 节点Yang
人工智能
使用 Browserflow 和 Google Sheets 自动化 LinkedIn 请求与破冰消息
使用 Browserflow 和 Google Sheets 自动化 LinkedIn 请求与破冰消息
If
Set
Sort
+15
44 节点PollupAI
销售
我的工作流5
使用AI邮件个性化的自动化LinkedIn潜在客户生成（未完成）
If
Set
Code
+9
37 节点Matthieu
销售
使用Dumpling AI和GPT-4o从网页截图提取产品信息
通过Dumpling AI和GPT-4o从网页截图中提取产品信息
Split Out
Google Drive
Http Request
+4
11 节点Yang
人工智能
