Google Maps SERP Data Scraper to Sheets

8c05162d-08a1-4448-8f2a-56bdda57ee1c

Latency
1904ms
Cost
$0.0000
Tokens
0
Status
partial
gemini-2.5-flash-lite

Workflow Graph

Trace

[
  {
    "data": {
      "nodeType": "manualTrigger"
    },
    "event": "node_start",
    "nodeId": "edef59f6-0197-408e-a819-141c1ca8dedd",
    "timestamp": 1780878242886
  },
  {
    "data": {
      "initialData": {
        "URL": {
          "match": "https://www.google.com/maps/search/best+pizza+in+new+york+city"
        },
        "geo": "new york city",
        "start": 0,
        "keyword": "best pizza",
        "local_results": [
          {
            "phone": "(212) 388-1313",
            "title": "Joe's Pizza",
            "rating": 4.5,
            "address": "7 Carmine St, New York, NY 10014",
            "reviews": 5000,
            "website": "https://www.joespizzanyc.com/",
            "latitude": 40.73061,
            "google_id": "0x89c259a31b1b1b1b:0x1b1b1b1b1b1b1b1b",
            "longitude": -74.00379
          },
          {
            "phone": "(718) 858-4300",
            "title": "Grimaldi's Pizzeria",
            "rating": 4.3,
            "address": "1 Front St, Brooklyn, NY 11201",
            "reviews": 4000,
            "website": "https://www.grimaldispizzeria.com/",
            "latitude": 40.70278,
            "google_id": "0x89c25a6d1b1b1b1b:0x1b1b1b1b1b1b1b1b",
            "longitude": -73.99248
          }
        ],
        "search_parameters": {
          "start": 0
        },
        "serpapi_pagination": {
          "next": "https://serpapi.com/search.json?engine=google_maps&q=best+pizza+in+new+york+city&start=10&api_key=YOUR_SERPAPI_KEY"
        }
      }
    },
    "event": "triggered",
    "nodeId": "manualTrigger",
    "timestamp": 1780878242886
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "manualTrigger"
    },
    "event": "node_end",
    "nodeId": "edef59f6-0197-408e-a819-141c1ca8dedd",
    "timestamp": 1780878242886
  },
  {
    "data": {
      "nodeType": "code"
    },
    "event": "node_start",
    "nodeId": "d56deaf5-1ad8-45a2-bbf0-3b71560f8036",
    "timestamp": 1780878242886
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "code"
    },
    "event": "node_end",
    "nodeId": "d56deaf5-1ad8-45a2-bbf0-3b71560f8036",
    "timestamp": 1780878242890
  },
  {
    "data": {
      "nodeType": "code"
    },
    "event": "node_start",
    "nodeId": "6562c236-c957-437b-91a9-15e98af09858",
    "timestamp": 1780878242890
  },
  {
    "event": "execution error (simulated): Isolate was disposed during execution due to memory limit",
    "nodeId": "code",
    "timestamp": 1780878243507
  },
  {
    "data": {
      "mode": "read",
      "status": "ok",
      "service": "code",
      "latencyMs": 0,
      "operation": "exec-failed",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1780878243507
  },
  {
    "data": {
      "error": "Isolate is already disposed",
      "status": "error",
      "degraded": true,
      "nodeType": "code"
    },
    "event": "node_end",
    "nodeId": "6562c236-c957-437b-91a9-15e98af09858",
    "timestamp": 1780878243508
  },
  {
    "data": {
      "nodeType": "code"
    },
    "event": "node_start",
    "nodeId": "357e8a57-dbb5-4241-b9c2-863b3ae3fd96",
    "timestamp": 1780878243508
  },
  {
    "event": "console.log: [object Object]",
    "nodeId": "code",
    "timestamp": 1780878243511
  },
  {
    "event": "console.log: error [object Object]",
    "nodeId": "code",
    "timestamp": 1780878243511
  },
  {
    "event": "console.log: ",
    "nodeId": "code",
    "timestamp": 1780878243511
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "code"
    },
    "event": "node_end",
    "nodeId": "357e8a57-dbb5-4241-b9c2-863b3ae3fd96",
    "timestamp": 1780878243511
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "4e8e9ae9-f5e3-4bfd-b0d4-9403a1c38d39",
    "timestamp": 1780878243513
  },
  {
    "data": {
      "service": "googleSheets",
      "resolved": true
    },
    "event": "credential_access",
    "nodeId": "_context",
    "timestamp": 1780878243513
  },
  {
    "data": {
      "url": "https://sheets.googleapis.com/v4/spreadsheets/1e8XpVw-np2ABv8gBd_VYhphaHZUYnJ5zoOa--qocbPE/values/Sink:append?valueInputOption=RAW",
      "method": "POST"
    },
    "event": "http_fetch",
    "nodeId": "_context",
    "timestamp": 1780878243513
  },
  {
    "data": {
      "tab": "Sink",
      "status": 200
    },
    "event": "sheets.write",
    "nodeId": "integration",
    "timestamp": 1780878243968
  },
  {
    "data": {
      "mode": "write",
      "status": "ok",
      "service": "googleSheets",
      "latencyMs": 455,
      "operation": "appendOrUpdate"
    },
    "event": "integration_call",
    "nodeId": "integration",
    "timestamp": 1780878243968
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "4e8e9ae9-f5e3-4bfd-b0d4-9403a1c38d39",
    "timestamp": 1780878243968
  },
  {
    "data": {
      "nodeType": "http"
    },
    "event": "node_start",
    "nodeId": "90194aa3-5960-47bd-9e0e-efee827004c4",
    "timestamp": 1780878243973
  },
  {
    "data": {
      "mode": "read",
      "status": "ok",
      "service": "http",
      "latencyMs": 250,
      "operation": "unresolvable-url",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1780878243973
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "http"
    },
    "event": "node_end",
    "nodeId": "90194aa3-5960-47bd-9e0e-efee827004c4",
    "timestamp": 1780878243973
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "9cfd1e76-2d7c-4618-86d6-e1f3c7729044",
    "timestamp": 1780878243976
  },
  {
    "data": {
      "count": 1
    },
    "event": "splitOut",
    "nodeId": "passthrough",
    "timestamp": 1780878243976
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "9cfd1e76-2d7c-4618-86d6-e1f3c7729044",
    "timestamp": 1780878243976
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "e47dfa17-fc84-4694-950d-165302a9075f",
    "timestamp": 1780878243979
  },
  {
    "data": {
      "count": 1
    },
    "event": "splitOut",
    "nodeId": "passthrough",
    "timestamp": 1780878243979
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "e47dfa17-fc84-4694-950d-165302a9075f",
    "timestamp": 1780878243979
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "decc89ee-f836-4ec2-9a1a-0371a8889ef5",
    "timestamp": 1780878243982
  },
  {
    "data": {
      "of": 1,
      "kept": 1
    },
    "event": "filter",
    "nodeId": "passthrough",
    "timestamp": 1780878243982
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "decc89ee-f836-4ec2-9a1a-0371a8889ef5",
    "timestamp": 1780878243982
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "bd7ca3a5-2697-4653-abf6-372088d925e6",
    "timestamp": 1780878243985
  },
  {
    "data": {
      "service": "googleSheets",
      "resolved": true
    },
    "event": "credential_access",
    "nodeId": "_context",
    "timestamp": 1780878243985
  },
  {
    "data": {
      "url": "https://sheets.googleapis.com/v4/spreadsheets/1e8XpVw-np2ABv8gBd_VYhphaHZUYnJ5zoOa--qocbPE/values/A1%3AZ100",
      "method": "GET"
    },
    "event": "http_fetch",
    "nodeId": "_context",
    "timestamp": 1780878243985
  },
  {
    "data": {
      "status": 200
    },
    "event": "sheets.read",
    "nodeId": "integration",
    "timestamp": 1780878244442
  },
  {
    "data": {
      "mode": "read",
      "status": "ok",
      "service": "googleSheets",
      "latencyMs": 457,
      "operation": "read"
    },
    "event": "integration_call",
    "nodeId": "integration",
    "timestamp": 1780878244442
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "bd7ca3a5-2697-4653-abf6-372088d925e6",
    "timestamp": 1780878244442
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "6d0be482-b1ad-4fa0-8d2e-bef9a4414924",
    "timestamp": 1780878244447
  },
  {
    "data": {
      "inputKeys": [],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1780878244447
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "6d0be482-b1ad-4fa0-8d2e-bef9a4414924",
    "timestamp": 1780878244447
  },
  {
    "data": {
      "nodeType": "trigger"
    },
    "event": "node_start",
    "nodeId": "234b5d18-75d7-495b-960f-06192d9e7c61",
    "timestamp": 1780878244450
  },
  {
    "data": {
      "kind": "n8n-nodes-base.scheduleTrigger"
    },
    "event": "seeded",
    "nodeId": "trigger",
    "timestamp": 1780878244450
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "trigger"
    },
    "event": "node_end",
    "nodeId": "234b5d18-75d7-495b-960f-06192d9e7c61",
    "timestamp": 1780878244450
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "a5a63861-7ff3-4072-a669-acce938939d8",
    "timestamp": 1780878244455
  },
  {
    "data": {
      "service": "googleSheets",
      "resolved": true
    },
    "event": "credential_access",
    "nodeId": "_context",
    "timestamp": 1780878244455
  },
  {
    "data": {
      "url": "https://sheets.googleapis.com/v4/spreadsheets/1e8XpVw-np2ABv8gBd_VYhphaHZUYnJ5zoOa--qocbPE/values/Sink:append?valueInputOption=RAW",
      "method": "POST"
    },
    "event": "http_fetch",
    "nodeId": "_context",
    "timestamp": 1780878244455
  },
  {
    "data": {
      "tab": "Sink",
      "status": 200
    },
    "event": "sheets.write",
    "nodeId": "integration",
    "timestamp": 1780878244612
  },
  {
    "data": {
      "mode": "write",
      "status": "ok",
      "service": "googleSheets",
      "latencyMs": 157,
      "operation": "update"
    },
    "event": "integration_call",
    "nodeId": "integration",
    "timestamp": 1780878244612
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "a5a63861-7ff3-4072-a669-acce938939d8",
    "timestamp": 1780878244612
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "2bdc5b63-e3bb-453e-a236-9c83cd12cc03",
    "timestamp": 1780878244616
  },
  {
    "data": {
      "service": "googleSheets",
      "resolved": true
    },
    "event": "credential_access",
    "nodeId": "_context",
    "timestamp": 1780878244616
  },
  {
    "data": {
      "url": "https://sheets.googleapis.com/v4/spreadsheets/1e8XpVw-np2ABv8gBd_VYhphaHZUYnJ5zoOa--qocbPE/values/Sink:append?valueInputOption=RAW",
      "method": "POST"
    },
    "event": "http_fetch",
    "nodeId": "_context",
    "timestamp": 1780878244616
  },
  {
    "data": {
      "tab": "Sink",
      "status": 200
    },
    "event": "sheets.write",
    "nodeId": "integration",
    "timestamp": 1780878244787
  },
  {
    "data": {
      "mode": "write",
      "status": "ok",
      "service": "googleSheets",
      "latencyMs": 171,
      "operation": "update"
    },
    "event": "integration_call",
    "nodeId": "integration",
    "timestamp": 1780878244787
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "2bdc5b63-e3bb-453e-a236-9c83cd12cc03",
    "timestamp": 1780878244787
  },
  {
    "data": {
      "nodeType": "if"
    },
    "event": "node_start",
    "nodeId": "cbc53e43-f141-434c-a655-feb1f7d3c65b",
    "timestamp": 1780878244790
  },
  {
    "event": "true branch",
    "nodeId": "if",
    "timestamp": 1780878244790
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "if"
    },
    "event": "node_end",
    "nodeId": "cbc53e43-f141-434c-a655-feb1f7d3c65b",
    "timestamp": 1780878244790
  }
]