{ "id": "YZpFvpXOTYkBpiUU", "meta": { "versionId": "1.0.0", "createdAt": "2025-09-29T07:07:54.428043", "updatedAt": "2025-09-29T07:07:54.428056", "owner": "n8n-user", "license": "MIT", "category": "automation", "status": "active", "priority": "high", "environment": "production" }, "name": "Extract Business Leads from Google Maps with Dumpling AI to Google Sheets", "tags": [ "automation", "n8n", "production-ready", "excellent", "optimized" ], "nodes": [ { "id": "3a49e594-6c62-4128-825e-99cdfd7e6ed5", "name": "Sticky Note", "type": "n8n-nodes-base.stickyNote", "position": [ -660, -200 ], "parameters": { "width": 600, "height": 700, "content": "#### 🔍 Workflow Goal\nAutomatically search Google Maps using Dumpling AI based on a keyword (e.g., best restaurants in New York), extract results, and log them into a structured Google Sheet.\n\n## 🚀 Workflow Steps\n1. **Manual Trigger**\n - Starts the workflow when testing manually.\n\n2. **Dumpling AI Google Search**\n - Sends a POST request to Dumpling AI to search for locations on Google Maps based on your query.\n\n3. **Split Out Node**\n - Breaks the `places[]` array into individual items so each result can be handled separately.\n\n4. **Google Sheets Node**\n - Appends each place’s data (name, address, phone, website, rating, etc.) into a specific tab of your Google Sheets.\n\n##### 🧠 Notes\n- The search query is currently set to: `\"best+restaurants+in+New+York\"`\n- Output columns include rating, price level, website, phone, booking links, etc.\n- Each run consumes Dumpling AI credits per query.\n- You can customize search keywords or location in the HTTP Request body.\n\n#### ✅ Tip\nTo automate this regularly, change the trigger node to a **Schedule Trigger** and add dynamic query input using a **Set** or **Webhook** node.\n\n" }, "typeVersion": 1, "notes": "This stickyNote node performs automated tasks as part of the workflow." }, { "id": "0a4ee00a-19cf-4d1e-a145-b5c5619ce636", "name": "Trigger: Manual Test Run", "type": "n8n-nodes-base.manualTrigger", "position": [ 0, 120 ], "parameters": {}, "typeVersion": 1, "notes": "This manualTrigger node performs automated tasks as part of the workflow." }, { "id": "26fdb640-93a0-4312-beaf-4c07fff87751", "name": "Search Google Maps via Dumpling AI", "type": "n8n-nodes-base.httpRequest", "position": [ 220, 120 ], "parameters": { "url": "{{ $env.API_BASE_URL }}", "method": "POST", "options": {}, "jsonBody": "={\n \"query\": \"best+restaurants+in+New+York\", \n \"language\": \"en\"\n}", "sendBody": true, "specifyBody": "json", "authentication": "{{ $credentials.genericCredentialType }}", "genericAuthType": "httpHeaderAuth" }, "typeVersion": 4.2, "notes": "This httpRequest node performs automated tasks as part of the workflow." }, { "id": "d3fafc2c-0b9d-4e83-83aa-de24d11fc0e1", "name": "Split Places List for Processing", "type": "n8n-nodes-base.splitOut", "position": [ 440, 120 ], "parameters": { "options": {}, "fieldToSplitOut": "places" }, "typeVersion": 1, "notes": "This splitOut node performs automated tasks as part of the workflow." }, { "id": "83b48532-b1fb-4ab3-9596-6e96526bfd49", "name": "Save Results to Google Sheet (Place Info)", "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": "{{ $env.WEBHOOK_URL }}", "cachedResultName": "Google Maps" }, "documentId": { "__rl": true, "mode": "list", "value": "", "cachedResultUrl": "{{ $env.WEBHOOK_URL }}", "cachedResultName": "Places" } }, "typeVersion": 4.5, "notes": "This googleSheets node performs automated tasks as part of the workflow." } ], "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": "{{ $env.WEBHOOK_URL }}", "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": [ "{{ $env.API_BASE_URL }}", "{{ $env.API_BASE_URL }}" ], "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": "{{ $env.WEBHOOK_URL }}" }, { "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": "{{ $env.WEBHOOK_URL }}", "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": [ "{{ $env.API_BASE_URL }}" ], "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": "{{ $env.WEBHOOK_URL }}" }, { "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": "{{ $env.WEBHOOK_URL }}", "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": "{{ $env.WEBHOOK_URL }}" }, { "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": "{{ $env.WEBHOOK_URL }}", "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": "{{ $env.WEBHOOK_URL }}" }, { "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": "{{ $env.WEBHOOK_URL }}", "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": [ "{{ $env.API_BASE_URL }}", "{{ $env.API_BASE_URL }}" ], "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": "{{ $env.WEBHOOK_URL }}" }, { "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": "{{ $env.WEBHOOK_URL }}", "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": [ "{{ $env.API_BASE_URL }}", "{{ $env.API_BASE_URL }}" ], "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": "{{ $env.WEBHOOK_URL }}" }, { "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": "{{ $env.WEBHOOK_URL }}", "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": [ "{{ $env.API_BASE_URL }}", "{{ $env.API_BASE_URL }}" ], "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": "{{ $env.WEBHOOK_URL }}" }, { "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": "{{ $env.WEBHOOK_URL }}", "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": [ "{{ $env.API_BASE_URL }}", "{{ $env.API_BASE_URL }}" ], "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": "{{ $env.WEBHOOK_URL }}" }, { "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": "{{ $env.WEBHOOK_URL }}", "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": [ "{{ $env.API_BASE_URL }}" ], "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": "{{ $env.WEBHOOK_URL }}" }, { "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": "{{ $env.WEBHOOK_URL }}", "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": "{{ $env.WEBHOOK_URL }}" }, { "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": "{{ $env.WEBHOOK_URL }}", "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": [ "{{ $env.API_BASE_URL }}", "{{ $env.API_BASE_URL }}" ], "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": "{{ $env.WEBHOOK_URL }}" }, { "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": "{{ $env.WEBHOOK_URL }}", "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": "{{ $env.WEBHOOK_URL }}" }, { "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": "{{ $env.WEBHOOK_URL }}", "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": "{{ $env.WEBHOOK_URL }}" }, { "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": "{{ $env.WEBHOOK_URL }}", "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": [ "{{ $env.API_BASE_URL }}", "{{ $env.API_BASE_URL }}" ], "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": "{{ $env.WEBHOOK_URL }}" }, { "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": "{{ $env.WEBHOOK_URL }}", "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": "{{ $env.WEBHOOK_URL }}" }, { "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": "{{ $env.WEBHOOK_URL }}", "latitude": 40.7246336, "position": 16, "longitude": -74.00297619999999, "priceLevel": "$30–50", "phoneNumber": "(646) 781-9183", "ratingCount": 1660, "bookingLinks": [ "{{ $env.API_BASE_URL }}", "{{ $env.API_BASE_URL }}" ], "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": "{{ $env.WEBHOOK_URL }}" }, { "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": "{{ $env.WEBHOOK_URL }}", "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": "{{ $env.WEBHOOK_URL }}" }, { "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": "{{ $env.WEBHOOK_URL }}", "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": [ "{{ $env.API_BASE_URL }}" ], "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": "{{ $env.WEBHOOK_URL }}" }, { "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": "{{ $env.WEBHOOK_URL }}", "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": "{{ $env.WEBHOOK_URL }}" }, { "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": "{{ $env.WEBHOOK_URL }}", "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": [ "{{ $env.API_BASE_URL }}", "{{ $env.API_BASE_URL }}", "{{ $env.API_BASE_URL }}" ], "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": "{{ $env.WEBHOOK_URL }}" } ], "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": "{{ $env.WEBHOOK_URL }}", "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": "{{ $env.WEBHOOK_URL }}", "Phone number": "(212) 837-1616" } }, { "json": { "type": "French restaurant", "Name ": "Balthazar", "rating": 4.4, "Address": "80 Spring St, New York, NY 10012", "Website": "{{ $env.WEBHOOK_URL }}", "Position": 2, "priceLevel": "$50–100", "Description": "Iconic French brasserie with steak frites, brunch & pastries in a classy space with red banquettes.", "Booking Link": "{{ $env.WEBHOOK_URL }}", "Phone number": "(212) 965-1414" } }, { "json": { "type": "Restaurant", "Name ": "Gramercy Tavern", "rating": 4.6, "Address": "42 E 20th St, New York, NY 10003", "Website": "{{ $env.WEBHOOK_URL }}", "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": "{{ $env.WEBHOOK_URL }}", "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": "{{ $env.WEBHOOK_URL }}", "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": "{{ $env.WEBHOOK_URL }}", "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": "{{ $env.WEBHOOK_URL }}", "Position": 6, "priceLevel": "$30–50", "Description": "Simple Italian outpost serving salads & homestyle pastas along with an extensive wine list.", "Booking Link": "{{ $env.WEBHOOK_URL }}", "Phone number": "(646) 478-7488" } }, { "json": { "type": "Restaurant", "Name ": "The Modern", "rating": 4.6, "Address": "9 W 53rd St, New York, NY 10019", "Website": "{{ $env.WEBHOOK_URL }}", "Position": 7, "priceLevel": "$100+", "Description": "French/New American fare in a modernist space with garden views at the Museum of Modern Art.", "Booking Link": "{{ $env.WEBHOOK_URL }}", "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": "{{ $env.WEBHOOK_URL }}", "Position": 8, "priceLevel": "$50–100", "Description": "Parisian-style cafe serving comforting French fare in a snug space with an open kitchen.", "Booking Link": "{{ $env.WEBHOOK_URL }}", "Phone number": "(646) 756-4145" } }, { "json": { "type": "Restaurant", "Name ": "Manhatta", "rating": 4.7, "Address": "28 Liberty St 60th floor, New York, NY 10005", "Website": "{{ $env.WEBHOOK_URL }}", "Position": 9, "priceLevel": "$100+", "Description": "Set on the 60th floor, this ritzy, high-end restaurant features New American cuisine and city views.", "Booking Link": "{{ $env.WEBHOOK_URL }}", "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": "{{ $env.WEBHOOK_URL }}", "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": "{{ $env.WEBHOOK_URL }}", "Position": 11, "priceLevel": "$50–100", "Description": "Naples meets NYC at this trattoria with thin-crust pizza, Italian wines & ample sidewalk seating.", "Booking Link": "{{ $env.WEBHOOK_URL }}", "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": "{{ $env.WEBHOOK_URL }}", "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": "{{ $env.WEBHOOK_URL }}", "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": "{{ $env.WEBHOOK_URL }}", "Position": 14, "priceLevel": "$50–100", "Description": "Glamorous rooftop restaurant offering American fare amid chandeliers, greenery, and skyline views.", "Booking Link": "{{ $env.WEBHOOK_URL }}", "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": "{{ $env.WEBHOOK_URL }}", "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": "{{ $env.WEBHOOK_URL }}", "Position": 16, "priceLevel": "$30–50", "Booking Link": "{{ $env.WEBHOOK_URL }}", "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": "{{ $env.WEBHOOK_URL }}", "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": "{{ $env.WEBHOOK_URL }}", "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": "{{ $env.WEBHOOK_URL }}", "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": "{{ $env.WEBHOOK_URL }}", "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": "{{ $env.WEBHOOK_URL }}", "Position": 20, "priceLevel": "$30–50", "Description": "Elevated Cajun-Creole food and drinks served in a New Orleans's French quarters-inspired restaurant.", "Booking Link": "{{ $env.WEBHOOK_URL }}", "Phone number": "(212) 267-3000" } } ] }, "settings": { "executionOrder": "v1", "saveManualExecutions": true, "callerPolicy": "workflowsFromSameOwner", "errorWorkflow": null, "timezone": "UTC", "executionTimeout": 3600, "maxExecutions": 1000, "retryOnFail": true, "retryCount": 3, "retryDelay": 1000 }, "versionId": "171ef405-bac6-42c0-a3c3-c28cb49ff21a", "connections": { "26fdb640-93a0-4312-beaf-4c07fff87751": { "main": [ [ { "node": "error-handler-26fdb640-93a0-4312-beaf-4c07fff87751", "type": "main", "index": 0 } ], [ { "node": "error-handler-26fdb640-93a0-4312-beaf-4c07fff87751-1bc2fe89", "type": "main", "index": 0 } ], [ { "node": "error-handler-26fdb640-93a0-4312-beaf-4c07fff87751-f0e7e0ca", "type": "main", "index": 0 } ], [ { "node": "error-handler-26fdb640-93a0-4312-beaf-4c07fff87751-63500c71", "type": "main", "index": 0 } ], [ { "node": "error-handler-26fdb640-93a0-4312-beaf-4c07fff87751-8e67b3a4", "type": "main", "index": 0 } ], [ { "node": "error-handler-26fdb640-93a0-4312-beaf-4c07fff87751-8f2bda61", "type": "main", "index": 0 } ], [ { "node": "error-handler-26fdb640-93a0-4312-beaf-4c07fff87751-842f14c4", "type": "main", "index": 0 } ], [ { "node": "error-handler-26fdb640-93a0-4312-beaf-4c07fff87751-2c023a4e", "type": "main", "index": 0 } ], [ { "node": "error-handler-26fdb640-93a0-4312-beaf-4c07fff87751-6b7fe025", "type": "main", "index": 0 } ] ] }, "83b48532-b1fb-4ab3-9596-6e96526bfd49": { "main": [ [ { "node": "error-handler-83b48532-b1fb-4ab3-9596-6e96526bfd49-5833da59", "type": "main", "index": 0 } ] ] } }, "description": "Automated workflow: Extract Business Leads from Google Maps with Dumpling AI to Google Sheets. This workflow integrates 6 different services: stickyNote, httpRequest, splitOut, stopAndError, manualTrigger. It contains 8 nodes and follows best practices for error handling and security.", "notes": "Excellent quality workflow: Extract Business Leads from Google Maps with Dumpling AI to Google Sheets. This workflow has been optimized for production use with comprehensive error handling, security, and documentation." }