8
n8n 中文网amn8n.com

Google Events API

中级

这是一个Market Research领域的自动化工作流，包含 10 个节点。主要使用 Set, Code, HttpRequest, GoogleSheets, ManualTrigger 等节点。 通过 SerpApi 抓取 Google Events 数据到 Google Sheets

前置要求
  • •可能需要目标 API 的认证凭证
  • •Google Sheets API 凭证

使用的节点 (10)

Set
Code
StickyNote
HttpRequest
GoogleSheets
ManualTrigger

分类

市场调研
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "id": "NypEKbAcGEmuEpCP",
  "meta": {
    "instanceId": "6fbb2e76a4f4743fb890492ba219000e5322811de9fe9ceb63aae628bc0e9ca4",
    "templateCredsSetupCompleted": true
  },
  "name": "Google Events API",
  "tags": [],
  "nodes": [
    {
      "id": "28a26329-303d-4f96-803a-4e9f3204f81a",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -80,
        -260
      ],
      "parameters": {
        "width": 280,
        "height": 320,
        "content": "🔧 搜索配置"
      },
      "typeVersion": 1
    },
    {
      "id": "b30e38fa-b991-42cd-be31-3d2b8d427ede",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        180,
        260
      ],
      "parameters": {
        "color": 5,
        "width": 260,
        "height": 280,
        "content": "🌐 SERPAPI 集成"
      },
      "typeVersion": 1
    },
    {
      "id": "c266ccf6-c412-4d70-97d7-55ce07fda254",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        440,
        -260
      ],
      "parameters": {
        "color": 4,
        "height": 320,
        "content": "⚙️ 数据转换"
      },
      "typeVersion": 1
    },
    {
      "id": "a9423400-c246-49fa-8954-2ab6a23e561a",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        120,
        -540
      ],
      "parameters": {
        "color": 3,
        "width": 380,
        "height": 260,
        "content": "🎯 GOOGLE EVENTS 爬虫"
      },
      "typeVersion": 1
    },
    {
      "id": "09315e90-1e0b-4dc2-8257-c9240591e514",
      "name": "便签4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        640,
        240
      ],
      "parameters": {
        "width": 340,
        "height": 220,
        "content": "📋 GOOGLE SHEETS 输出"
      },
      "typeVersion": 1
    },
    {
      "id": "d6b61e68-aee6-415e-b68b-40bcba2cbc33",
      "name": "手动触发器",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -180,
        80
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "7ff33746-1a70-473a-918c-0973e8df9b56",
      "name": "设置搜索参数",
      "type": "n8n-nodes-base.set",
      "position": [
        40,
        80
      ],
      "parameters": {
        "mode": "raw",
        "options": {},
        "jsonOutput": "{\n  \"query\": \"Events in Texas\",\n  \"total_events\": 10,\n  \"start\": 0\n}\n"
      },
      "typeVersion": 3.4
    },
    {
      "id": "0aafd123-2beb-4dcc-b9a5-3180dda8e0ef",
      "name": "SerpApi 活动请求",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        260,
        80
      ],
      "parameters": {
        "url": "https://serpapi.com/search",
        "options": {
          "pagination": {
            "pagination": {
              "parameters": {
                "parameters": [
                  {
                    "name": "start",
                    "value": "={{ $json.start }}"
                  }
                ]
              },
              "maxRequests": "={{ $json.total_events/10 }}",
              "requestInterval": 2000,
              "limitPagesFetched": true
            }
          }
        },
        "sendQuery": true,
        "authentication": "genericCredentialType",
        "genericAuthType": "httpQueryAuth",
        "queryParameters": {
          "parameters": [
            {
              "name": "engine",
              "value": "google_events"
            },
            {
              "name": "q",
              "value": "={{ $json.query }}"
            },
            {
              "name": "hl",
              "value": "en"
            },
            {
              "name": "gl",
              "value": "us"
            }
          ]
        }
      },
      "credentials": {
        "httpQueryAuth": {
          "id": "lCjZrbVUzLCjWLOK",
          "name": "SerpApi(Naveen): Query Auth account"
        }
      },
      "typeVersion": 4.2,
      "alwaysOutputData": false
    },
    {
      "id": "56757e55-daf1-4791-a7de-43ee59b4fa10",
      "name": "处理并展平活动数据",
      "type": "n8n-nodes-base.code",
      "position": [
        480,
        80
      ],
      "parameters": {
        "jsCode": "const allItems = $input.all();\nlet flattenedEvents = [];\n\nfor (const item of allItems) {\n  const events = item.json.events_results || [];\n  const query = item.json.search_parameters?.q || \"\";\n\n  for (const event of events) {\n    // Add query to each event object\n    flattenedEvents.push({\n      json: {\n        ...event,\n        query: query\n      }\n    });\n  }\n}\n\nreturn flattenedEvents;\n"
      },
      "typeVersion": 2
    },
    {
      "id": "63d157da-a93e-4fc6-88ae-133fb8d52915",
      "name": "保存到 Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        700,
        80
      ],
      "parameters": {
        "columns": {
          "value": {
            "link": "={{ $json.link }}",
            "when": "={{ $json.date.when }}",
            "image": "={{ $json.image }}",
            "query": "={{ $json.query }}",
            "title": "={{ $json.title }}",
            "venue": "={{ $json.venue }}",
            "address": "={{ $json.address }}",
            "start_date": "={{ $json.date.start_date }}",
            "description": "={{ $json.description }}",
            "ticket_info": "={{ $json.ticket_info }}",
            "event_location_map": "={{ $json.event_location_map.link }}"
          },
          "schema": [
            {
              "id": "title",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "title",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "start_date",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "start_date",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "when",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "when",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "address",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "address",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "link",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "link",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "event_location_map",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "event_location_map",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "ticket_info",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "ticket_info",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "venue",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "venue",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "query",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "query",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "description",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "description",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "image",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "image",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1DQo3tI8yKzCbLn-DWN2hureHgwj1XxvM1ogES1_77ts/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1DQo3tI8yKzCbLn-DWN2hureHgwj1XxvM1ogES1_77ts",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1DQo3tI8yKzCbLn-DWN2hureHgwj1XxvM1ogES1_77ts/edit?usp=drivesdk",
          "cachedResultName": "Google Events API"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "4",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.5
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "ff103f52-d64b-4303-b4f0-9334ee7aac05",
  "connections": {
    "Manual Trigger": {
      "main": [
        [
          {
            "node": "Set Search Parameters",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set Search Parameters": {
      "main": [
        [
          {
            "node": "SerpApi Events Request",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "SerpApi Events Request": {
      "main": [
        [
          {
            "node": "Process & Flatten Events",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Process & Flatten Events": {
      "main": [
        [
          {
            "node": "Save to Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。

这个工作流适合什么场景？

中级 - 市场调研

需要付费吗？

本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。

相关工作流推荐

使用自动分页将LinkedIn Sales Navigator联系人提取到Google Sheets
使用自动分页将LinkedIn Sales Navigator联系人提取到Google Sheets
If
Set
Code
+5
15 节点Naveen Choudhary
内容创作
01 使用AI媒体买家分析Facebook广告表现并将洞察发送到Google Sheets
使用Gemini AI分析Facebook广告并将洞察发送到Google Sheets
If
Set
Code
+13
34 节点JJ Tham
市场调研
使用ZoomInfo、Serper和Oxylabs到Google Sheets自动化公司数据丰富
通过ZoomInfo、Serper和Oxylabs到Google Sheets自动化公司数据丰富
If
Code
Html
+6
19 节点Naveen Choudhary
潜在客户开发
模板v08/02 - Facebook广告库到亚马逊爬虫
使用 Apify 爬虫自动在亚马逊上搜索 Facebook 广告产品
If
Set
Code
+8
24 节点Richard Besier
市场调研
YouTube RSS到Slack摘要
使用Google Sheets、RapidAPI和GPT-4o-mini将新YouTube视频摘要发送到Slack
If
Set
Xml
+13
40 节点Naveen Choudhary
人工智能
使用Perplexity AI和Google Sheets通过业务数据丰富公司域名
使用Perplexity AI和Google Sheets通过业务数据丰富公司域名
Code
Http Request
Google Sheets
+3
9 节点Naveen Choudhary
潜在客户开发
工作流信息
难度等级
中级
节点数量10
分类1
节点类型6
难度说明

适合有一定经验的用户，包含 6-15 个节点的中等复杂度工作流

作者
Naveen Choudhary

Naveen Choudhary

@n8nstein

I create AI-driven n8n workflows that turn repetitive tasks into smooth, hands-off automations. Want to explore an idea? Book a quick consult: https://cal.com/nickchoudhary/30min

外部链接
在 n8n.io 查看 →

分享此工作流