utilisation Dumpling AI + GPT-4o + Google Sheets de AI 竞争对手评论analyse器

Intermédiaire

Ceci est uncontenant 8 nœuds.Utilise principalement des nœuds comme SplitOut, Aggregate, HttpRequest, GoogleSheets, OpenAi. 基于Dumpling AI + GPT-4o + Google SheetsdeAI竞争对手评论analyse器

Prérequis
  • Peut nécessiter les informations d'identification d'authentification de l'API cible
  • Informations d'identification Google Sheets API
  • Clé API OpenAI

Catégorie

-
Aperçu du workflow
Visualisation des connexions entre les nœuds, avec support du zoom et du déplacement
Exporter le workflow
Copiez la configuration JSON suivante dans n8n pour importer et utiliser ce workflow
{
  "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 – Nouvelle entreprise ajoutée",
      "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": "Récupérer les avis Google depuis Dumpling AI",
      "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": "Diviser la liste des avis",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        -840,
        -700
      ],
      "parameters": {
        "options": {},
        "fieldToSplitOut": "items"
      },
      "typeVersion": 1
    },
    {
      "id": "e5c5c53b-42e2-4ad1-aeb4-9dd680747a1f",
      "name": "Agréger le texte des avis",
      "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 : Extraire les informations des avis",
      "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": "Enregistrer le résumé dans Google Sheets",
      "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": "Note adhésive",
      "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": "Note adhésive1",
      "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
          }
        ]
      ]
    }
  }
}
Foire aux questions

Comment utiliser ce workflow ?

Copiez le code de configuration JSON ci-dessus, créez un nouveau workflow dans votre instance n8n et sélectionnez "Importer depuis le JSON", collez la configuration et modifiez les paramètres d'authentification selon vos besoins.

Dans quelles scénarios ce workflow est-il adapté ?

Intermédiaire

Est-ce payant ?

Ce workflow est entièrement gratuit et peut être utilisé directement. Veuillez noter que les services tiers utilisés dans le workflow (comme l'API OpenAI) peuvent nécessiter un paiement de votre part.

Workflows recommandés

Utiliser Dumpling AI et GPT-4o pour générer des idées de vidéos YouTube
Générer des idées de contenu YouTube avec Dumpling AI et GPT-4o par analyse vidéo
Code
Wait
Gmail
+
Code
Wait
Gmail
13 NœudsYang
Création de contenu
Génération automatique de commentaires de presse IA avec Dumpling AI et GPT-4o
Utiliser Dumpling AI et GPT-4o pour générer automatiquement des commentaires d'actualités IA
Code
Wait
Split Out
+
Code
Wait
Split Out
14 NœudsYang
Intelligence Artificielle
Extraction d'informations de produits à partir de captures d'écran de pages web avec Dumpling AI et GPT-4o
Extraire des informations de produits à partir de captures d'écran de pages web avec Dumpling AI et GPT-4o
Split Out
Google Drive
Http Request
+
Split Out
Google Drive
Http Request
11 NœudsYang
Intelligence Artificielle
Constructeur de bulletin d'actualités IA : Grâce à Dumpling AI pour scraper les sites, GPT-4o pour résumer
Constructeur de briefings d'actualités IA : Dumpling AI pour le scraping de sites, résumé par GPT-4o
Set
Code
Gmail
+
Set
Code
Gmail
10 NœudsYang
Intelligence Artificielle
Utiliser Dumpling AI pour générer automatiquement des publications spécifiques à la plateforme à partir de vidéos YouTube
Génération automatique de publications Instagram, Facebook et LinkedIn à partir de vidéos YouTube avec GPT-4o et Dumpling AI
Set
Code
Merge
+
Set
Code
Merge
20 NœudsYang
Création de contenu
Automatisation de formulaire en article de blog avec Dumpling AI et Google Docs
Utiliser Dumpling AI, OpenAI et Google Docs pour automatiser la création de blog à partir de mots-clés
Code
Wait
Limit
+
Code
Wait
Limit
17 NœudsYang
Création de contenu
Informations sur le workflow
Niveau de difficulté
Intermédiaire
Nombre de nœuds8
Catégorie-
Types de nœuds7
Description de la difficulté

Adapté aux utilisateurs expérimentés, avec des workflows de complexité moyenne contenant 6-15 nœuds

Liens externes
Voir sur n8n.io

Partager ce workflow

Catégories

Catégories: 34