Verwendung von Dumpling AI + GPT-4o + Google Sheets für einen KI-gestützten Wettbewerber-Bewertungsanalysator

Fortgeschritten

Dies ist ein Automatisierungsworkflow mit 8 Nodes. Hauptsächlich werden SplitOut, Aggregate, HttpRequest, GoogleSheets, OpenAi und andere Nodes verwendet. Ein KI-gestützter Wettbewerber-Bewertungsanalysator basierend auf Dumpling AI + GPT-4o + Google Sheets

Voraussetzungen
  • Möglicherweise sind Ziel-API-Anmeldedaten erforderlich
  • Google Sheets API-Anmeldedaten
  • OpenAI API Key

Kategorie

-
Workflow-Vorschau
Visualisierung der Node-Verbindungen, mit Zoom und Pan
Workflow exportieren
Kopieren Sie die folgende JSON-Konfiguration und importieren Sie sie in n8n
{
  "id": "HsxXMUjX8ds5GXrV",
  "meta": {
    "instanceId": "a1ae5c8dc6c65e674f9c3947d083abcc749ef2546dff9f4ff01de4d6a36ebfe6",
    "templateCredsSetupCompleted": true
  },
  "name": "AI Competitor Review Analyzer with Dumpling AI + GPT-4o + Google Sheets",
  "tags": [],
  "nodes": [
    {
      "id": "73954fe0-97bd-4556-9ea2-8d42bd5c7b3d",
      "name": "Google Sheets Trigger – Neues Unternehmen hinzugefügt",
      "type": "n8n-nodes-base.googleSheetsTrigger",
      "position": [
        -1320,
        -700
      ],
      "parameters": {
        "event": "rowAdded",
        "options": {},
        "pollTimes": {
          "item": [
            {
              "mode": "everyMinute"
            }
          ]
        },
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1bRDFEMkwJ7BaAC6tO7xGrNFCB2MZKz9pWZAUja-Sels/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1bRDFEMkwJ7BaAC6tO7xGrNFCB2MZKz9pWZAUja-Sels/edit?usp=drivesdk",
          "cachedResultName": "Google review"
        }
      },
      "credentials": {
        "googleSheetsTriggerOAuth2Api": {
          "id": "qDzHSzTkclwDHpSR",
          "name": "Google Sheets Trigger account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "94d2b22c-522e-4a38-afd0-3dcd51f4418c",
      "name": "Google Bewertungen von Dumpling AI abrufen",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -1060,
        -700
      ],
      "parameters": {
        "url": "=https://app.dumplingai.com/api/v1/get-google-reviews",
        "method": "=POST",
        "options": {},
        "jsonBody": "={\n  \"keyword\": \"{{ $json['Business name'] }}\",\n  \"reviews\": \"20\",\n  \"sortBy\": \"newest\",\n  \"language\": \"en\",\n  \"location\": \"United States\"\n}\n ",
        "sendBody": true,
        "specifyBody": "json",
        "authentication": "genericCredentialType",
        "genericAuthType": "httpHeaderAuth"
      },
      "credentials": {
        "httpHeaderAuth": {
          "id": "5CBvzXCLjwWzCJRE",
          "name": "n8n_integration"
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "26f0110a-0c92-48d9-a2a9-4e20f0e5699d",
      "name": "Bewertungsliste aufteilen",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        -840,
        -700
      ],
      "parameters": {
        "options": {},
        "fieldToSplitOut": "items"
      },
      "typeVersion": 1
    },
    {
      "id": "e5c5c53b-42e2-4ad1-aeb4-9dd680747a1f",
      "name": "Bewertungstext zusammenfassen",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        -620,
        -700
      ],
      "parameters": {
        "options": {},
        "fieldsToAggregate": {
          "fieldToAggregate": [
            {
              "fieldToAggregate": "review_text"
            }
          ]
        }
      },
      "typeVersion": 1
    },
    {
      "id": "01bbc579-a368-45cd-b2c5-2204a562a4c7",
      "name": "GPT-4o: Erkenntnisse aus Bewertungen extrahieren",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        -420,
        -700
      ],
      "parameters": {
        "modelId": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4o",
          "cachedResultName": "GPT-4O"
        },
        "options": {},
        "messages": {
          "values": [
            {
              "role": "system",
              "content": "You are a review analysis assistant"
            },
            {
              "content": "=You are a review analysis assistant. Your task is to read a list of customer reviews about a business and extract two main insights:\n\n1. **Challenges or complaints** people are consistently mentioning  \n2. **Things customers love** or speak highly about\n\nPlease analyze the tone, keywords, and patterns in the reviews. Do not just summarize each review. Instead, group similar feedback together and present the top recurring themes.\n\nRespond in this format:\n\n**Top Complaints or Challenges:**\n- [Summarize the most common issues customers have. Include examples if needed.]\n\n**What People Love About This Business:**\n- [Summarize the most common compliments or positive feedback. Include examples if needed.]\n\nHere are the reviews:\n{{ $json.review_text }}"
            }
          ]
        }
      },
      "credentials": {
        "openAiApi": {
          "id": "fdhWALG84tBLgSZT",
          "name": "OpenAi account"
        }
      },
      "typeVersion": 1.8
    },
    {
      "id": "e32aff5b-6ef0-4c2d-9c62-1aa0988a1ecd",
      "name": "Zusammenfassung in Google Sheets speichern",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -60,
        -700
      ],
      "parameters": {
        "columns": {
          "value": {
            "Review  text": "={{ $json.message.content }}",
            "Business name": "={{ $('Fetch Google Reviews from Dumpling AI').item.json.keyword }}"
          },
          "schema": [
            {
              "id": "Business name",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Business name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Review  text",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Review  text",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "Business name"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1bRDFEMkwJ7BaAC6tO7xGrNFCB2MZKz9pWZAUja-Sels/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1bRDFEMkwJ7BaAC6tO7xGrNFCB2MZKz9pWZAUja-Sels",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1bRDFEMkwJ7BaAC6tO7xGrNFCB2MZKz9pWZAUja-Sels/edit?usp=drivesdk",
          "cachedResultName": "Google review"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "GaJqJHuS5mQxap7q",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "b505cba7-6c9f-4b61-814d-3a0bb7d1219e",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -540,
        -1020
      ],
      "parameters": {
        "width": 600,
        "height": 360,
        "content": "### 🔍 AI Analysis & Sheet Output\n\nThis section handles summarizing reviews and saving insights:\n\n4. **Aggregate Review Text**  \n   Joins all individual review texts into a single prompt for AI processing.\n\n5. **GPT-4o – Summarize Sentiment**  \n   Uses GPT-4o to analyze the reviews and extract common complaints and positive feedback. Returns a structured summary.\n\n6. **Append Summary to Google Sheet**  \n   Adds the summarized competitor insight back into the original Google Sheet, aligned with the input row.\n"
      },
      "typeVersion": 1
    },
    {
      "id": "7b35868d-1d2d-4c4b-a987-610d8868bed8",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1340,
        -1020
      ],
      "parameters": {
        "color": 3,
        "width": 580,
        "height": 360,
        "content": "### 📥 Business Input & Review Collection\n\nThis section of the workflow starts the competitor analysis process:\n\n1. **Google Sheets Trigger**  \n   Watches for new rows added to the competitor sheet. Each row contains a business name and location.\n\n2. **Dumpling AI – Get Google Reviews**  \n   Sends a prompt to Dumpling AI with the business details to fetch 20 recent customer reviews. Requires an active agent with review scraping capability.\n\n3. **Split Reviews into Individual Items**  \n   Breaks the returned review list into individual entries so each one can be processed separately later in the flow.\n"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {
    "Aggregate Review Text": [
      {
        "json": {
          "review_text": [
            "Delicious sausage boards and pretzels. Great atmosphere — especially for a game or large group",
            "Quality German food, friendly staff",
            "There for gathering, great ambiance, medieval style vibes, especially the tables",
            "Fried chicken was oozing oil when I tried to cut it",
            "Expensively decent.",
            "First time getting the meat platter.. It's exactly what you want from a German restaurant. Plus a side of spaetzle of course.",
            "Meh. Pretty overpriced and you’re pretty ignored. Beer good but maybe not worth it. Happy hour not too happy.",
            "Excellent food and quality beers, the bartender Carlos very friendly and attentive!",
            "Pork shank no longer on menu. Waiter would ask you to surrender your credit card to prevent you from running away without paying. Weird.",
            "You’re experiencing Europe in a whole new way right here! The food is great, with flavors that transport you across the Atlantic. They have an impressive selection of beers, both draft and bottled, so there’s something for everyone. The staff is fantastic – friendly, attentive, and really make you feel at home. A must-visit spot if you’re looking for that European vibe!",
            "I found this place by accident and I’m so glad I did. The food is AMAZING and the portions are great for the price. They have lunch specials, too, which are also well priced for the amount of food. We got the chicken schnitzel, pretzel, and Spätzle, all to split, plus drinks. The total came out to less than I thought and I’m at the right level of full but not uncomfortable. Adding this to my list of places to come back to.\n\nThe staff was all friendly and willing to make recommendations when asked.",
            "Great to watch sports, and perfect for large groups!\nMultiple screens for different games playing. Staff is accommodating to switching games.\nDrinks are bountiful and good portions. Food is decent.\nPerfect for large groups! And doesn't feel super cramped."
          ]
        }
      }
    ],
    "Fetch Google Reviews from Dumpling AI": [
      {
        "json": {
          "cid": "7562120435193397286",
          "type": "google_reviews",
          "items": [
            {
              "type": "google_reviews_search",
              "xpath": null,
              "images": null,
              "rating": {
                "value": 5,
                "rating_max": 5,
                "rating_type": "Max5",
                "votes_count": null
              },
              "position": "left",
              "time_ago": "3 weeks ago",
              "review_id": "ChZDSUhNMG9nS0VJQ0FnTURJamFhZkV3EAE",
              "timestamp": "2025-04-12 02:23:15 +00:00",
              "rank_group": 1,
              "review_url": "https://www.google.com/maps/reviews/data=!4m8!14m7!1m6!2m5!1sChZDSUhNMG9nS0VJQ0FnTURJamFhZkV3EAE!2m1!1s0x0:0x68f20c78506cc026!3m1!1s2@1:CIHM0ogKEICAgMDIjaafEw%7CCgsIk53nvwYQ6I2XSw%7C?hl=en-US",
              "local_guide": true,
              "profile_url": "https://www.google.com/maps/contrib/109457473948114437861/reviews?hl=en-US",
              "review_text": "Delicious sausage boards and pretzels. Great atmosphere — especially for a game or large group",
              "owner_answer": null,
              "photos_count": 1,
              "profile_name": "Lone Stride",
              "rank_absolute": 1,
              "reviews_count": 142,
              "owner_time_ago": null,
              "owner_timestamp": null,
              "profile_image_url": "https://lh3.googleusercontent.com/a/ACg8ocIoSfHWk16Fs10CUsF3QaYNYU2VpzmaPofR1xjMZ1MO_qfgOg=s64-c-rp-mo-ba4-br100",
              "review_highlights": [
                {
                  "feature": "Price per person",
                  "assessment": "$30–50"
                },
                {
                  "feature": "Food",
                  "assessment": "5"
                },
                {
                  "feature": "Service",
                  "assessment": "5"
                },
                {
                  "feature": "Atmosphere",
                  "assessment": "5"
                }
              ],
              "original_review_text": null,
              "original_owner_answer": null
            },
            {
              "type": "google_reviews_search",
              "xpath": null,
              "images": null,
              "rating": {
                "value": 5,
                "rating_max": 5,
                "rating_type": "Max5",
                "votes_count": null
              },
              "position": "left",
              "time_ago": "4 weeks ago",
              "review_id": "ChdDSUhNMG9nS0VJQ0FnTUNJX2JLRG9nRRAB",
              "timestamp": "2025-04-04 06:35:17 +00:00",
              "rank_group": 2,
              "review_url": "https://www.google.com/maps/reviews/data=!4m8!14m7!1m6!2m5!1sChdDSUhNMG9nS0VJQ0FnTUNJX2JLRG9nRRAB!2m1!1s0x0:0x68f20c78506cc026!3m1!1s2@1:CIHM0ogKEICAgMCI_bKDogE%7CCgsIpfu9vwYQqNrHcQ%7C?hl=en-US",
              "local_guide": true,
              "profile_url": "https://www.google.com/maps/contrib/112065824844515183111/reviews?hl=en-US",
              "review_text": "Quality German food, friendly staff",
              "owner_answer": null,
              "photos_count": null,
              "profile_name": "Ryan Kuo",
              "rank_absolute": 2,
              "reviews_count": 269,
              "owner_time_ago": null,
              "owner_timestamp": null,
              "profile_image_url": "https://lh3.googleusercontent.com/a-/ALV-UjV6JShJquC8OULNcyk16_BjzrfCy6hlkGG3L5vw1DWs1YemdXxS=s64-c-rp-mo-ba4-br100",
              "review_highlights": null,
              "original_review_text": null,
              "original_owner_answer": null
            },
            {
              "type": "google_reviews_search",
              "xpath": null,
              "images": null,
              "rating": {
                "value": 4,
                "rating_max": 5,
                "rating_type": "Max5",
                "votes_count": null
              },
              "position": "left",
              "time_ago": "a month ago",
              "review_id": "ChZDSUhNMG9nS0VJQ0FnSURSNzhTOE1BEAE",
              "timestamp": "2025-03-30 04:15:08 +00:00",
              "rank_group": 3,
              "review_url": "https://www.google.com/maps/reviews/data=!4m8!14m7!1m6!2m5!1sChZDSUhNMG9nS0VJQ0FnSURSNzhTOE1BEAE!2m1!1s0x0:0x68f20c78506cc026!3m1!1s2@1:CIHM0ogKEICAgIDR78S8MA%7CCgsIzIqjvwYQ8LfKEA%7C?hl=en-US",
              "local_guide": true,
              "profile_url": "https://www.google.com/maps/contrib/105961603236208078077/reviews?hl=en-US",
              "review_text": null,
              "owner_answer": null,
              "photos_count": 9,
              "profile_name": "Greg Meagher",
              "rank_absolute": 3,
              "reviews_count": 16,
              "owner_time_ago": null,
              "owner_timestamp": null,
              "profile_image_url": "https://lh3.googleusercontent.com/a/ACg8ocL7PuJwQWJ65Q7bdtoeSfU6cZYv5GeTILHI1mTMXALj3zvuOdo=s64-c-rp-mo-ba2-br100",
              "review_highlights": [
                {
                  "feature": "Service",
                  "assessment": "Dine in\n5"
                },
                {
                  "feature": "Meal type",
                  "assessment": "Other"
                },
                {
                  "feature": "Food",
                  "assessment": "4"
                },
                {
                  "feature": "Atmosphere",
                  "assessment": "5"
                }
              ],
              "original_review_text": null,
              "original_owner_answer": null
            },
            {
              "type": "google_reviews_search",
              "xpath": null,
              "images": null,
              "rating": {
                "value": 5,
                "rating_max": 5,
                "rating_type": "Max5",
                "votes_count": null
              },
              "position": "left",
              "time_ago": "a month ago",
              "review_id": "ChdDSUhNMG9nS0VJQ0FnTUR3aU9qN193RRAB",
              "timestamp": "2025-03-23 00:49:01 +00:00",
              "rank_group": 4,
              "review_url": "https://www.google.com/maps/reviews/data=!4m8!14m7!1m6!2m5!1sChdDSUhNMG9nS0VJQ0FnTUR3aU9qN193RRAB!2m1!1s0x0:0x68f20c78506cc026!3m1!1s2@1:CIHM0ogKEICAgMDwiOj7_wE%7CCgwI_bT9vgYQ0PX9wgI%7C?hl=en-US",
              "local_guide": true,
              "profile_url": "https://www.google.com/maps/contrib/100530869924006791492/reviews?hl=en-US",
              "review_text": null,
              "owner_answer": null,
              "photos_count": null,
              "profile_name": "Ciaron Ireland",
              "rank_absolute": 4,
              "reviews_count": 9,
              "owner_time_ago": null,
              "owner_timestamp": null,
              "profile_image_url": "https://lh3.googleusercontent.com/a-/ALV-UjWhr4b95XNv8YbjM4KX3P-H6RUV-EVFn8Z9Pqsfp5b4Nktw8pl9=s64-c-rp-mo-ba3-br100",
              "review_highlights": [
                {
                  "feature": "Service",
                  "assessment": "Dine in\n5"
                },
                {
                  "feature": "Meal type",
                  "assessment": "Dinner"
                },
                {
                  "feature": "Price per person",
                  "assessment": "$50–100"
                },
                {
                  "feature": "Food",
                  "assessment": "5"
                },
                {
                  "feature": "Atmosphere",
                  "assessment": "4"
                }
              ],
              "original_review_text": null,
              "original_owner_answer": null
            },
            {
              "type": "google_reviews_search",
              "xpath": null,
              "images": null,
              "rating": {
                "value": 5,
                "rating_max": 5,
                "rating_type": "Max5",
                "votes_count": null
              },
              "position": "left",
              "time_ago": "a month ago",
              "review_id": "ChdDSUhNMG9nS0VJQ0FnTUN3cDktSzR3RRAB",
              "timestamp": "2025-03-21 17:35:06 +00:00",
              "rank_group": 5,
              "review_url": "https://www.google.com/maps/reviews/data=!4m8!14m7!1m6!2m5!1sChdDSUhNMG9nS0VJQ0FnTUN3cDktSzR3RRAB!2m1!1s0x0:0x68f20c78506cc026!3m1!1s2@1:CIHM0ogKEICAgMCwp9-K4wE%7CCgwIysb2vgYQ8LD92AM%7C?hl=en-US",
              "local_guide": true,
              "profile_url": "https://www.google.com/maps/contrib/115901291912151198982/reviews?hl=en-US",
              "review_text": "There for gathering, great ambiance, medieval style vibes, especially the tables",
              "owner_answer": null,
              "photos_count": 100,
              "profile_name": "구스만보라",
              "rank_absolute": 5,
              "reviews_count": 71,
              "owner_time_ago": null,
              "owner_timestamp": null,
              "profile_image_url": "https://lh3.googleusercontent.com/a-/ALV-UjUp2le51xagQoPNZGmNfPsW5OGDq7o-eRKyytnPG2QKlPn3gsBMNA=s64-c-rp-mo-ba4-br100",
              "review_highlights": [
                {
                  "feature": "Meal type",
                  "assessment": "Dinner"
                },
                {
                  "feature": "Food",
                  "assessment": "5"
                },
                {
                  "feature": "Service",
                  "assessment": "5"
                },
                {
                  "feature": "Atmosphere",
                  "assessment": "5"
                }
              ],
              "original_review_text": null,
              "original_owner_answer": null
            },
            {
              "type": "google_reviews_search",
              "xpath": null,
              "images": null,
              "rating": {
                "value": 1,
                "rating_max": 5,
                "rating_type": "Max5",
                "votes_count": null
              },
              "position": "left",
              "time_ago": "a month ago",
              "review_id": "ChdDSUhNMG9nS0VJQ0FnTUN3ODh2YXlRRRAB",
              "timestamp": "2025-03-21 04:31:37 +00:00",
              "rank_group": 6,
              "review_url": "https://www.google.com/maps/reviews/data=!4m8!14m7!1m6!2m5!1sChdDSUhNMG9nS0VJQ0FnTUN3ODh2YXlRRRAB!2m1!1s0x0:0x68f20c78506cc026!3m1!1s2@1:CIHM0ogKEICAgMCw88vayQE%7CCgwIqdfzvgYQoICHiQI%7C?hl=en-US",
              "local_guide": true,
              "profile_url": "https://www.google.com/maps/contrib/101321122607001875391/reviews?hl=en-US",
              "review_text": "Fried chicken was oozing oil when I tried to cut it",
              "owner_answer": null,
              "photos_count": 93,
              "profile_name": "Ajay Kumar K",
              "rank_absolute": 6,
              "reviews_count": 135,
              "owner_time_ago": null,
              "owner_timestamp": null,
              "profile_image_url": "https://lh3.googleusercontent.com/a-/ALV-UjWpfKPiUiNOlyZ9WNW_lajQClQydWOG_DMKAVTKtVUMKDCNFaJP=s64-c-rp-mo-ba4-br100",
              "review_highlights": [
                {
                  "feature": "Service",
                  "assessment": "Dine in\n5"
                },
                {
                  "feature": "Meal type",
                  "assessment": "Dinner"
                },
                {
                  "feature": "Price per person",
                  "assessment": "$10–20"
                },
                {
                  "feature": "Food",
                  "assessment": "1"
                },
                {
                  "feature": "Atmosphere",
                  "assessment": "5"
                }
              ],
              "original_review_text": null,
              "original_owner_answer": null
            },
            {
              "type": "google_reviews_search",
              "xpath": null,
              "images": null,
              "rating": {
                "value": 4,
                "rating_max": 5,
                "rating_type": "Max5",
                "votes_count": null
              },
              "position": "left",
              "time_ago": "a month ago",
              "review_id": "ChZDSUhNMG9nS0VJQ0FnTURRaTl2OWRnEAE",
              "timestamp": "2025-03-14 07:00:37 +00:00",
              "rank_group": 7,
              "review_url": "https://www.google.com/maps/reviews/data=!4m8!14m7!1m6!2m5!1sChZDSUhNMG9nS0VJQ0FnTURRaTl2OWRnEAE!2m1!1s0x0:0x68f20c78506cc026!3m1!1s2@1:CIHM0ogKEICAgMDQi9v9dg%7CCgwIlajPvgYQwK3KggE%7C?hl=en-US",
              "local_guide": true,
              "profile_url": "https://www.google.com/maps/contrib/102064914246862075490/reviews?hl=en-US",
              "review_text": "Expensively decent.",
              "owner_answer": null,
              "photos_count": null,
              "profile_name": "Jake",
              "rank_absolute": 7,
              "reviews_count": 19,
              "owner_time_ago": null,
              "owner_timestamp": null,
              "profile_image_url": "https://lh3.googleusercontent.com/a-/ALV-UjXSJp4GfnQhzSQZpMwDQD7A59-6uowUrDP4ymKkM7Csor7sxes=s64-c-rp-mo-ba2-br100",
              "review_highlights": [
                {
                  "feature": "Service",
                  "assessment": "Dine in\n5"
                },
                {
                  "feature": "Meal type",
                  "assessment": "Lunch"
                },
                {
                  "feature": "Price per person",
                  "assessment": "$20–30"
                },
                {
                  "feature": "Food",
                  "assessment": "4"
                },
                {
                  "feature": "Atmosphere",
                  "assessment": "5"
                }
              ],
              "original_review_text": null,
              "original_owner_answer": null
            },
            {
              "type": "google_reviews_search",
              "xpath": null,
              "images": null,
              "rating": {
                "value": 4,
                "rating_max": 5,
                "rating_type": "Max5",
                "votes_count": null
              },
              "position": "left",
              "time_ago": "2 months ago",
              "review_id": "ChdDSUhNMG9nS0VJQ0FnTUNncnVLYzRBRRAB",
              "timestamp": "2025-02-17 11:02:58 +00:00",
              "rank_group": 8,
              "review_url": "https://www.google.com/maps/reviews/data=!4m8!14m7!1m6!2m5!1sChdDSUhNMG9nS0VJQ0FnTUNncnVLYzRBRRAB!2m1!1s0x0:0x68f20c78506cc026!3m1!1s2@1:CIHM0ogKEICAgMCgruKc4AE%7CCgsI4q7MvQYQuNzlKg%7C?hl=en-US",
              "local_guide": true,
              "profile_url": "https://www.google.com/maps/contrib/107122545361381435201/reviews?hl=en-US",
              "review_text": null,
              "owner_answer": null,
              "photos_count": 43,
              "profile_name": "aGMM Stark",
              "rank_absolute": 8,
              "reviews_count": 2,
              "owner_time_ago": null,
              "owner_timestamp": null,
              "profile_image_url": "https://lh3.googleusercontent.com/a/ACg8ocJSKOqaubtDWqFG9QC_KoKBUppaR6JiRbVeLjI3zuLGgWDILw=s64-c-rp-mo-ba2-br100",
              "review_highlights": [
                {
                  "feature": "Service",
                  "assessment": "Delivery\n4"
                },
                {
                  "feature": "Meal type",
                  "assessment": "Lunch"
                },
                {
                  "feature": "Price per person",
                  "assessment": "$20–30"
                },
                {
                  "feature": "Food",
                  "assessment": "4"
                },
                {
                  "feature": "Atmosphere",
                  "assessment": "4"
                }
              ],
              "original_review_text": null,
              "original_owner_answer": null
            },
            {
              "type": "google_reviews_search",
              "xpath": null,
              "images": null,
              "rating": {
                "value": 4,
                "rating_max": 5,
                "rating_type": "Max5",
                "votes_count": null
              },
              "position": "left",
              "time_ago": "2 months ago",
              "review_id": "ChZDSUhNMG9nS0VJQ0FnTUNBOC15Q1ZnEAE",
              "timestamp": "2025-02-04 05:03:53 +00:00",
              "rank_group": 9,
              "review_url": "https://www.google.com/maps/reviews/data=!4m8!14m7!1m6!2m5!1sChZDSUhNMG9nS0VJQ0FnTUNBOC15Q1ZnEAE!2m1!1s0x0:0x68f20c78506cc026!3m1!1s2@1:CIHM0ogKEICAgMCA8-yCVg%7CCgsIub-GvQYQiKe2aw%7C?hl=en-US",
              "local_guide": true,
              "profile_url": "https://www.google.com/maps/contrib/113101736446780000569/reviews?hl=en-US",
              "review_text": null,
              "owner_answer": null,
              "photos_count": 236,
              "profile_name": "Asish M (AM_)",
              "rank_absolute": 9,
              "reviews_count": 477,
              "owner_time_ago": null,
              "owner_timestamp": null,
              "profile_image_url": "https://lh3.googleusercontent.com/a-/ALV-UjXFnJdTYgWT4HM2h4yVd-Dr7FpwuG2w_ywK8SYWOXmtjH975Tf1QQ=s64-c-rp-mo-ba5-br100",
              "review_highlights": [
                {
                  "feature": "Food",
                  "assessment": "4"
                },
                {
                  "feature": "Service",
                  "assessment": "5"
                },
                {
                  "feature": "Atmosphere",
                  "assessment": "5"
                }
              ],
              "original_review_text": null,
              "original_owner_answer": null
            },
            {
              "type": "google_reviews_search",
              "xpath": null,
              "images": [
                {
                  "alt": null,
                  "url": null,
                  "type": "images_element",
                  "image_url": "https://lh3.googleusercontent.com/geougc-cs/AB3l90Dk7YV-H_aRbcAlus4SvSdj43exyx3SEbX6zz1KrdJ9DWsgHVYsGf9bTJ_r3CocKI--q3Df57G2nzDWAARaoDWDNJ3H856fSsaoJbC5_-Osu9wPgfIo5SfeAjH6s7YL1vscBteK"
                }
              ],
              "rating": {
                "value": 5,
                "rating_max": 5,
                "rating_type": "Max5",
                "votes_count": null
              },
              "position": "left",
              "time_ago": "3 months ago",
              "review_id": "ChZDSUhNMG9nS0VJQ0FnSURfdDZyUGRBEAE",
              "timestamp": "2025-01-28 01:22:28 +00:00",
              "rank_group": 10,
              "review_url": "https://www.google.com/maps/reviews/data=!4m8!14m7!1m6!2m5!1sChZDSUhNMG9nS0VJQ0FnSURfdDZyUGRBEAE!2m1!1s0x0:0x68f20c78506cc026!3m1!1s2@1:CIHM0ogKEICAgID_t6rPdA%7CCgwI1OLgvAYQwLixkQM%7C?hl=en-US",
              "local_guide": true,
              "profile_url": "https://www.google.com/maps/contrib/112863706490498402138/reviews?hl=en-US",
              "review_text": null,
              "owner_answer": null,
              "photos_count": 2421,
              "profile_name": "Yuta Higuchi",
              "rank_absolute": 10,
              "reviews_count": 194,
              "owner_time_ago": null,
              "owner_timestamp": null,
              "profile_image_url": "https://lh3.googleusercontent.com/a-/ALV-UjXtF5cHq1IMu4hq9t-iAPPq0gpC_LRZxS3WvJEKwImTE7NGhqIb=s64-c-rp-mo-ba6-br100",
              "review_highlights": [
                {
                  "feature": "Service",
                  "assessment": "Dine in\n5"
                },
                {
                  "feature": "Meal type",
                  "assessment": "Lunch"
                },
                {
                  "feature": "Price per person",
                  "assessment": "$50–100"
                },
                {
                  "feature": "Food",
                  "assessment": "5"
                },
                {
                  "feature": "Atmosphere",
                  "assessment": "5"
                }
              ],
              "original_review_text": null,
              "original_owner_answer": null
            },
            {
              "type": "google_reviews_search",
              "xpath": null,
              "images": null,
              "rating": {
                "value": 4,
                "rating_max": 5,
                "rating_type": "Max5",
                "votes_count": null
              },
              "position": "left",
              "time_ago": "3 months ago",
              "review_id": "ChdDSUhNMG9nS0VJQ0FnSURmNF9uVmx3RRAB",
              "timestamp": "2025-01-10 00:23:21 +00:00",
              "rank_group": 11,
              "review_url": "https://www.google.com/maps/reviews/data=!4m8!14m7!1m6!2m5!1sChdDSUhNMG9nS0VJQ0FnSURmNF9uVmx3RRAB!2m1!1s0x0:0x68f20c78506cc026!3m1!1s2@1:CIHM0ogKEICAgIDf4_nVlwE%7CCgsI-dCBvAYQuJvRKg%7C?hl=en-US",
              "local_guide": true,
              "profile_url": "https://www.google.com/maps/contrib/104029803408113019388/reviews?hl=en-US",
              "review_text": null,
              "owner_answer": null,
              "photos_count": null,
              "profile_name": "Wei Ouyang",
              "rank_absolute": 11,
              "reviews_count": 19,
              "owner_time_ago": null,
              "owner_timestamp": null,
              "profile_image_url": "https://lh3.googleusercontent.com/a/ACg8ocJyafhxIDhPZ36ygNfyVt9V0rn1MgSLvRbxGs89HGjLzHDm7g=s64-c-rp-mo-ba2-br100",
              "review_highlights": [
                {
                  "feature": "Service",
                  "assessment": "Dine in\n5"
                },
                {
                  "feature": "Meal type",
                  "assessment": "Lunch"
                },
                {
                  "feature": "Price per person",
                  "assessment": "$30–50"
                },
                {
                  "feature": "Food",
                  "assessment": "5"
                },
                {
                  "feature": "Atmosphere",
                  "assessment": "4"
                }
              ],
              "original_review_text": null,
              "original_owner_answer": null
            },
            {
              "type": "google_reviews_search",
              "xpath": null,
              "images": null,
              "rating": {
                "value": 5,
                "rating_max": 5,
                "rating_type": "Max5",
                "votes_count": null
              },
              "position": "left",
              "time_ago": "3 months ago",
              "review_id": "ChdDSUhNMG9nS0VJQ0FnSURmbEk3bmlnRRAB",
              "timestamp": "2025-01-04 03:50:41 +00:00",
              "rank_group": 12,
              "review_url": "https://www.google.com/maps/reviews/data=!4m8!14m7!1m6!2m5!1sChdDSUhNMG9nS0VJQ0FnSURmbEk3bmlnRRAB!2m1!1s0x0:0x68f20c78506cc026!3m1!1s2@1:CIHM0ogKEICAgIDflI7nigE%7CCgwIkeDiuwYQgI__yAM%7C?hl=en-US",
              "local_guide": false,
              "profile_url": "https://www.google.com/maps/contrib/108313255064302420127/reviews?hl=en-US",
              "review_text": null,
              "owner_answer": null,
              "photos_count": null,
              "profile_name": "Carey Hubby",
              "rank_absolute": 12,
              "reviews_count": 1,
              "owner_time_ago": null,
              "owner_timestamp": null,
              "profile_image_url": "https://lh3.googleusercontent.com/a/ACg8ocL8k-295w0-z1P01GVWWDxcokDs4_fnx0cqL9eSUtlVihofAg=s64-c-rp-mo-br100",
              "review_highlights": [
                {
                  "feature": "Service",
                  "assessment": "Dine in"
                },
                {
                  "feature": "Meal type",
                  "assessment": "Dinner"
                },
                {
                  "feature": "Price per person",
                  "assessment": "$30–50"
                }
              ],
              "original_review_text": null,
              "original_owner_answer": null
            },
            {
              "type": "google_reviews_search",
              "xpath": null,
              "images": null,
              "rating": {
                "value": 3,
                "rating_max": 5,
                "rating_type": "Max5",
                "votes_count": null
              },
              "position": "left",
              "time_ago": "3 months ago",
              "review_id": "ChdDSUhNMG9nS0VJQ0FnSUNzMnA2T25BRRAB",
              "timestamp": "2025-01-03 21:27:49 +00:00",
              "rank_group": 13,
              "review_url": "https://www.google.com/maps/reviews/data=!4m8!14m7!1m6!2m5!1sChdDSUhNMG9nS0VJQ0FnSUNzMnA2T25BRRAB!2m1!1s0x0:0x68f20c78506cc026!3m1!1s2@1:CIHM0ogKEICAgICs2p6OnAE%7CCgwI1azhuwYQ0IHizQE%7C?hl=en-US",
              "local_guide": true,
              "profile_url": "https://www.google.com/maps/contrib/111184799810075782476/reviews?hl=en-US",
              "review_text": null,
              "owner_answer": null,
              "photos_count": 1511,
              "profile_name": "Eric Perret",
              "rank_absolute": 13,
              "reviews_count": 410,
              "owner_time_ago": null,
              "owner_timestamp": null,
              "profile_image_url": "https://lh3.googleusercontent.com/a-/ALV-UjULRKhYBaDwZNiuYrQcEWrzI3YGqv9fTZdwuYLPbdc-4o4axSHlCQ=s64-c-rp-mo-ba6-br100",
              "review_highlights": [
                {
                  "feature": "Service",
                  "assessment": "Dine in\n4"
                },
                {
                  "feature": "Meal type",
                  "assessment": "Dinner"
                },
                {
                  "feature": "Food",
                  "assessment": "3"
                },
                {
                  "feature": "Atmosphere",
                  "assessment": "3"
                },
                {
                  "feature": "Reservation",
                  "assessment": "Varies by time / day"
                },
                {
                  "feature": "Noise level",
                  "assessment": "Loud, but you can still talk"
                },
                {
                  "feature": "Wait time",
                  "assessment": "No wait"
                }
              ],
              "original_review_text": null,
              "original_owner_answer": null
            },
            {
              "type": "google_reviews_search",
              "xpath": null,
              "images": null,
              "rating": {
                "value": 5,
                "rating_max": 5,
                "rating_type": "Max5",
                "votes_count": null
              },
              "position": "left",
              "time_ago": "4 months ago",
              "review_id": "ChdDSUhNMG9nS0VJQ0FnSUN2MTYyOS13RRAB",
              "timestamp": "2024-12-15 16:08:58 +00:00",
              "rank_group": 14,
              "review_url": "https://www.google.com/maps/reviews/data=!4m8!14m7!1m6!2m5!1sChdDSUhNMG9nS0VJQ0FnSUN2MTYyOS13RRAB!2m1!1s0x0:0x68f20c78506cc026!3m1!1s2@1:CIHM0ogKEICAgICv1629-wE%7CCgwImv77ugYQwIqFjwE%7C?hl=en-US",
              "local_guide": true,
              "profile_url": "https://www.google.com/maps/contrib/113215383231172904965/reviews?hl=en-US",
              "review_text": "First time getting the meat platter.. It's exactly what you want from a German restaurant. Plus a side of spaetzle of course.",
              "owner_answer": null,
              "photos_count": 17,
              "profile_name": "James Downs",
              "rank_absolute": 14,
              "reviews_count": 42,
              "owner_time_ago": null,
              "owner_timestamp": null,
              "profile_image_url": "https://lh3.googleusercontent.com/a/ACg8ocJijk2imaWxjm1fKQ8BvwGKILGzNuHS4KNmJTe_yZIgrelp8Q=s64-c-rp-mo-ba4-br100",
              "review_highlights": [
                {
                  "feature": "Service",
                  "assessment": "Dine in"
                },
                {
                  "feature": "Meal type",
                  "assessment": "Dinner"
                }
              ],
              "original_review_text": null,
              "original_owner_answer": null
            },
            {
              "type": "google_reviews_search",
              "xpath": null,
              "images": null,
              "rating": {
                "value": 2,
                "rating_max": 5,
                "rating_type": "Max5",
                "votes_count": null
              },
              "position": "left",
              "time_ago": "4 months ago",
              "review_id": "ChdDSUhNMG9nS0VJQ0FnSUN2a2NlVnFnRRAB",
              "timestamp": "2024-12-11 23:51:10 +00:00",
              "rank_group": 15,
              "review_url": "https://www.google.com/maps/reviews/data=!4m8!14m7!1m6!2m5!1sChdDSUhNMG9nS0VJQ0FnSUN2a2NlVnFnRRAB!2m1!1s0x0:0x68f20c78506cc026!3m1!1s2@1:CIHM0ogKEICAgICvkceVqgE%7CCgwI7srougYQ4JjqhQM%7C?hl=en-US",
              "local_guide": true,
              "profile_url": "https://www.google.com/maps/contrib/109282543362538960646/reviews?hl=en-US",
              "review_text": "Meh. Pretty overpriced and you’re pretty ignored. Beer good but maybe not worth it. Happy hour not too happy.",
              "owner_answer": null,
              "photos_count": 3,
              "profile_name": "Selma Kettwich",
              "rank_absolute": 15,
              "reviews_count": 13,
              "owner_time_ago": null,
              "owner_timestamp": null,
              "profile_image_url": "https://lh3.googleusercontent.com/a-/ALV-UjVahk2p-im8vWhcuwpBZeLrAqFDMDsegfvOG2ULBm7rPfOASBXS=s64-c-rp-mo-ba2-br100",
              "review_highlights": [
                {
                  "feature": "Food",
                  "assessment": "2"
                },
                {
                  "feature": "Service",
                  "assessment": "2"
                },
                {
                  "feature": "Atmosphere",
                  "assessment": "5"
                }
              ],
              "original_review_text": null,
              "original_owner_answer": null
            },
            {
              "type": "google_reviews_search",
              "xpath": null,
              "images": null,
              "rating": {
                "value": 5,
                "rating_max": 5,
                "rating_type": "Max5",
                "votes_count": null
              },
              "position": "left",
              "time_ago": "5 months ago",
              "review_id": "ChdDSUhNMG9nS0VJQ0FnSUQzcW9mb3dRRRAB",
              "timestamp": "2024-11-14 05:19:23 +00:00",
              "rank_group": 16,
              "review_url": "https://www.google.com/maps/reviews/data=!4m8!14m7!1m6!2m5!1sChdDSUhNMG9nS0VJQ0FnSUQzcW9mb3dRRRAB!2m1!1s0x0:0x68f20c78506cc026!3m1!1s2@1:CIHM0ogKEICAgID3qofowQE%7CCgwI25DWuQYQ0IjstQM%7C?hl=en-US",
              "local_guide": false,
              "profile_url": "https://www.google.com/maps/contrib/111633512147022854649/reviews?hl=en-US",
              "review_text": "Excellent food and quality beers, the bartender Carlos very friendly and attentive!",
              "owner_answer": null,
              "photos_count": 1,
              "profile_name": "Eileen Loza",
              "rank_absolute": 16,
              "reviews_count": 8,
              "owner_time_ago": null,
              "owner_timestamp": null,
              "profile_image_url": "https://lh3.googleusercontent.com/a/ACg8ocIG8gtXXuf8LjG5wyTfmMyS5VoqoSEE0ZZJevFv_M2mnv4dPfs=s64-c-rp-mo-br100",
              "review_highlights": [
                {
                  "feature": "Service",
                  "assessment": "Dine in\n5"
                },
                {
                  "feature": "Food",
                  "assessment": "5"
                },
                {
                  "feature": "Atmosphere",
                  "assessment": "5"
                }
              ],
              "original_review_text": "Excelente comida y cervezas de calidad , el bartender Carlos muy amable y atento !",
              "original_owner_answer": null
            },
            {
              "type": "google_reviews_search",
              "xpath": null,
              "images": null,
              "rating": {
                "value": 1,
                "rating_max": 5,
                "rating_type": "Max5",
                "votes_count": null
              },
              "position": "left",
              "time_ago": "5 months ago",
              "review_id": "ChZDSUhNMG9nS0VJQ0FnSUMzX19fU09nEAE",
              "timestamp": "2024-11-10 22:46:28 +00:00",
              "rank_group": 17,
              "review_url": "https://www.google.com/maps/reviews/data=!4m8!14m7!1m6!2m5!1sChZDSUhNMG9nS0VJQ0FnSUMzX19fU09nEAE!2m1!1s0x0:0x68f20c78506cc026!3m1!1s2@1:CIHM0ogKEICAgIC3___SOg%7CCgwIxO_EuQYQgPuc4AI%7C?hl=en-US",
              "local_guide": false,
              "profile_url": "https://www.google.com/maps/contrib/101961972717614625485/reviews?hl=en-US",
              "review_text": "Pork shank no longer on menu. Waiter would ask you to surrender your credit card to prevent you from running away without paying. Weird.",
              "owner_answer": null,
              "photos_count": 3,
              "profile_name": "Kale H",
              "rank_absolute": 17,
              "reviews_count": 7,
              "owner_time_ago": null,
              "owner_timestamp": null,
              "profile_image_url": "https://lh3.googleusercontent.com/a-/ALV-UjVbJTHa_nr83XdJ7_ArT5MkcKvXRWxpoIcfsf_-qmbRkvc3U2E=s64-c-rp-mo-br100",
              "review_highlights": [
                {
                  "feature": "Service",
                  "assessment": "Dine in\n1"
                },
                {
                  "feature": "Meal type",
                  "assessment": "Dinner"
                },
                {
                  "feature": "Price per person",
                  "assessment": "$30–50"
                },
                {
                  "feature": "Food",
                  "assessment": "3"
                },
                {
                  "feature": "Atmosphere",
                  "assessment": "4"
                }
              ],
              "original_review_text": null,
              "original_owner_answer": null
            },
            {
              "type": "google_reviews_search",
              "xpath": null,
              "images": null,
              "rating": {
                "value": 4,
                "rating_max": 5,
                "rating_type": "Max5",
                "votes_count": null
              },
              "position": "left",
              "time_ago": "6 months ago",
              "review_id": "ChZDSUhNMG9nS0VJQ0FnSURYamZuSmR3EAE",
              "timestamp": "2024-10-30 02:03:27 +00:00",
              "rank_group": 18,
              "review_url": "https://www.google.com/maps/reviews/data=!4m8!14m7!1m6!2m5!1sChZDSUhNMG9nS0VJQ0FnSURYamZuSmR3EAE!2m1!1s0x0:0x68f20c78506cc026!3m1!1s2@1:CIHM0ogKEICAgIDXjfnJdw%7CCgwI76eGuQYQ6JCq6AI%7C?hl=en-US",
              "local_guide": true,
              "profile_url": "https://www.google.com/maps/contrib/106597689200922008958/reviews?hl=en-US",
              "review_text": "You’re experiencing Europe in a whole new way right here! The food is great, with flavors that transport you across the Atlantic. They have an impressive selection of beers, both draft and bottled, so there’s something for everyone. The staff is fantastic – friendly, attentive, and really make you feel at home. A must-visit spot if you’re looking for that European vibe!",
              "owner_answer": null,
              "photos_count": null,
              "profile_name": "Engin Şentürk",
              "rank_absolute": 18,
              "reviews_count": 22,
              "owner_time_ago": null,
              "owner_timestamp": null,
              "profile_image_url": "https://lh3.googleusercontent.com/a-/ALV-UjWv511GpEaEJCVc6-VksP_kFS4hhYUydgcR9rtpSHHd88PssSTS=s64-c-rp-mo-ba3-br100",
              "review_highlights": [
                {
                  "feature": "Service",
                  "assessment": "Dine in\n4"
                },
                {
                  "feature": "Meal type",
                  "assessment": "Dinner"
                },
                {
                  "feature": "Price per person",
                  "assessment": "$30–50"
                },
                {
                  "feature": "Food",
                  "assessment": "4"
                },
                {
                  "feature": "Atmosphere",
                  "assessment": "5"
                }
              ],
              "original_review_text": null,
              "original_owner_answer": null
            },
            {
              "type": "google_reviews_search",
              "xpath": null,
              "images": null,
              "rating": {
                "value": 5,
                "rating_max": 5,
                "rating_type": "Max5",
                "votes_count": null
              },
              "position": "left",
              "time_ago": "6 months ago",
              "review_id": "ChZDSUhNMG9nS0VJQ0FnSUNYNWRTY2VREAE",
              "timestamp": "2024-10-18 19:42:18 +00:00",
              "rank_group": 19,
              "review_url": "https://www.google.com/maps/reviews/data=!4m8!14m7!1m6!2m5!1sChZDSUhNMG9nS0VJQ0FnSUNYNWRTY2VREAE!2m1!1s0x0:0x68f20c78506cc026!3m1!1s2@1:CIHM0ogKEICAgICX5dSceQ%7CCgwImvTKuAYQ6MP-8wE%7C?hl=en-US",
              "local_guide": true,
              "profile_url": "https://www.google.com/maps/contrib/110483459995935701918/reviews?hl=en-US",
              "review_text": "I found this place by accident and I’m so glad I did. The food is AMAZING and the portions are great for the price. They have lunch specials, too, which are also well priced for the amount of food. We got the chicken schnitzel, pretzel, and Spätzle, all to split, plus drinks. The total came out to less than I thought and I’m at the right level of full but not uncomfortable. Adding this to my list of places to come back to.\n\nThe staff was all friendly and willing to make recommendations when asked.",
              "owner_answer": null,
              "photos_count": 32,
              "profile_name": "Morgan Davis",
              "rank_absolute": 19,
              "reviews_count": 74,
              "owner_time_ago": null,
              "owner_timestamp": null,
              "profile_image_url": "https://lh3.googleusercontent.com/a-/ALV-UjXPDPPU55Gz3GrwhZvoh2yK-8HSshT9YGDQnJEaFwJBPn46QUX0=s64-c-rp-mo-ba4-br100",
              "review_highlights": [
                {
                  "feature": "Service",
                  "assessment": "Dine in\n5"
                },
                {
                  "feature": "Meal type",
                  "assessment": "Lunch"
                },
                {
                  "feature": "Food",
                  "assessment": "5"
                },
                {
                  "feature": "Atmosphere",
                  "assessment": "5"
                }
              ],
              "original_review_text": null,
              "original_owner_answer": null
            },
            {
              "type": "google_reviews_search",
              "xpath": null,
              "images": null,
              "rating": {
                "value": 5,
                "rating_max": 5,
                "rating_type": "Max5",
                "votes_count": null
              },
              "position": "left",
              "time_ago": "6 months ago",
              "review_id": "ChZDSUhNMG9nS0VJQ0FnSUNYNmJIeU5REAE",
              "timestamp": "2024-10-18 06:13:55 +00:00",
              "rank_group": 20,
              "review_url": "https://www.google.com/maps/reviews/data=!4m8!14m7!1m6!2m5!1sChZDSUhNMG9nS0VJQ0FnSUNYNmJIeU5REAE!2m1!1s0x0:0x68f20c78506cc026!3m1!1s2@1:CIHM0ogKEICAgICX6bHyNQ%7CCgwIo_nHuAYQ8Pa4iQI%7C?hl=en-US",
              "local_guide": true,
              "profile_url": "https://www.google.com/maps/contrib/117485808379222263389/reviews?hl=en-US",
              "review_text": "Great to watch sports, and perfect for large groups!\nMultiple screens for different games playing. Staff is accommodating to switching games.\nDrinks are bountiful and good portions. Food is decent.\nPerfect for large groups! And doesn't feel super cramped.",
              "owner_answer": null,
              "photos_count": 382,
              "profile_name": "Krystal Aranda",
              "rank_absolute": 20,
              "reviews_count": 114,
              "owner_time_ago": null,
              "owner_timestamp": null,
              "profile_image_url": "https://lh3.googleusercontent.com/a-/ALV-UjXrGQhVdz6Bn2SCSowBy4DIz9y5_ig5JagM2DDr7RDsrYsRbxTOGw=s64-c-rp-mo-ba5-br100",
              "review_highlights": [
                {
                  "feature": "Service",
                  "assessment": "Dine in\n5"
                },
                {
                  "feature": "Meal type",
                  "assessment": "Other"
                },
                {
                  "feature": "Price per person",
                  "assessment": "$10–20"
                },
                {
                  "feature": "Food",
                  "assessment": "4"
                },
                {
                  "feature": "Atmosphere",
                  "assessment": "5"
                }
              ],
              "original_review_text": null,
              "original_owner_answer": null
            }
          ],
          "title": "Schroeder's",
          "rating": {
            "value": 4.2,
            "rating_max": 5,
            "rating_type": "Max5",
            "votes_count": 1218
          },
          "keyword": "schroederssf",
          "datetime": "2025-05-03 13:12:25 +00:00",
          "place_id": "ChIJe0MyoGGAhYARJsBsUHgM8mg",
          "check_url": "https://www.google.com/search?q=schroederssf&num=100&sort=newestFirst&hl=en&gl=US&gws_rd=cr&ie=UTF-8&oe=UTF-8&uule=w+CAIQIFISCQs2MuSEtepUEUK33kOSuTsc",
          "se_domain": "google.com",
          "sub_title": "240 Front St, San Francisco, CA 94111, United States",
          "feature_id": "0x80858061a032437b:0x68f20c78506cc026",
          "items_count": 20,
          "language_code": "en",
          "location_code": 2840,
          "reviews_count": 1218
        }
      }
    ],
    "Google Sheets Trigger – New Business Added": [
      {
        "json": {
          "Review  text": "",
          "Business name": "schroederssf"
        }
      }
    ]
  },
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "6b5a71b6-4eda-4848-9bcb-2f8f8d857cbf",
  "connections": {
    "e5c5c53b-42e2-4ad1-aeb4-9dd680747a1f": {
      "main": [
        [
          {
            "node": "01bbc579-a368-45cd-b2c5-2204a562a4c7",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "26f0110a-0c92-48d9-a2a9-4e20f0e5699d": {
      "main": [
        [
          {
            "node": "e5c5c53b-42e2-4ad1-aeb4-9dd680747a1f",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "94d2b22c-522e-4a38-afd0-3dcd51f4418c": {
      "main": [
        [
          {
            "node": "26f0110a-0c92-48d9-a2a9-4e20f0e5699d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "01bbc579-a368-45cd-b2c5-2204a562a4c7": {
      "main": [
        [
          {
            "node": "e32aff5b-6ef0-4c2d-9c62-1aa0988a1ecd",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "73954fe0-97bd-4556-9ea2-8d42bd5c7b3d": {
      "main": [
        [
          {
            "node": "94d2b22c-522e-4a38-afd0-3dcd51f4418c",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
Häufig gestellte Fragen

Wie verwende ich diesen Workflow?

Kopieren Sie den obigen JSON-Code, erstellen Sie einen neuen Workflow in Ihrer n8n-Instanz und wählen Sie "Aus JSON importieren". Fügen Sie die Konfiguration ein und passen Sie die Anmeldedaten nach Bedarf an.

Für welche Szenarien ist dieser Workflow geeignet?

Fortgeschritten

Ist es kostenpflichtig?

Dieser Workflow ist völlig kostenlos. Beachten Sie jedoch, dass Drittanbieterdienste (wie OpenAI API), die im Workflow verwendet werden, möglicherweise kostenpflichtig sind.

Workflow-Informationen
Schwierigkeitsgrad
Fortgeschritten
Anzahl der Nodes8
Kategorie-
Node-Typen7
Schwierigkeitsbeschreibung

Für erfahrene Benutzer, mittelkomplexe Workflows mit 6-15 Nodes

Externe Links
Auf n8n.io ansehen

Diesen Workflow teilen

Kategorien

Kategorien: 34