Skip to content

Google 表格触发器节点常见问题#

¥Google Sheets Trigger node common issues

以下是 Google 表格触发器节点 的一些常见错误和问题，以及解决或故障排除步骤。

¥Here are some common errors and issues with the Google Sheets Trigger node and steps to resolve or troubleshoot them.

等待触发事件卡住#

¥Stuck waiting for trigger event

使用“执行步骤”或“执行工作流”按钮测试 Google Sheets 触发节点时，执行过程可能会卡住，无法停止监听事件。如果出现这种情况，你可能需要退出工作流并重新打开以重置画布。

¥When testing the Google Sheets Trigger node with the Execute step or Execute workflow buttons, the execution may appear stuck and unable to stop listening for events. If this occurs, you may need to exit the workflow and open it again to reset the canvas.

监听事件卡住通常是由于 n8n 之外的网络配置问题导致的。具体来说，当你在反向代理后运行 n8n 而未配置 WebSocket 代理时，通常会出现此行为。

¥Stuck listening events often occur due to issues with your network configuration outside of n8n. Specifically, this behavior often occurs when you run n8n behind a reverse proxy without configuring websocket proxying.

要解决此问题，请检查你的反向代理配置（Nginx、Caddy、Apache HTTP 服务器、Traefik 等），启用 WebSocket 支持。

¥To resolve this issue, check your reverse proxy configuration (Nginx, Caddy, Apache HTTP Server, Traefik, etc.) to enable websocket support.

日期和时间列显示为数字#

¥Date and time columns are rendering as numbers

Google 表格可以以几种不同的方式呈现日期和时间。

¥Google Sheets can render dates and times a few different ways.

序列号格式 由 Lotus 1-2-3 推广，并被许多电子表格软件使用，它将日期表示为十进制数。整数部分（小数点左侧的部分）表示自 1899 年 12 月 30 日以来的天数。小数部分（小数点右侧的部分）表示 24 小时周期内的时间（例如，.5 表示中午 12 点）。

¥The serial number format, popularized by Lotus 1-2-3 and used my types of spreadsheet software, represents dates as a decimal number. The whole number component (the part left of the decimal) represents the number of days since December 30, 1899. The decimal portion (the part right of the decimal) represents time as a portion of a 24-hour period (for example, .5 represents noon).

要使用不同的日期和时间值格式，请在 Google 表格触发器节点中调整格式。当“触发条件”设置为“行已添加”时，此功能可用：

¥To use a different format for date and time values, adjust the format in your Google Sheet Trigger node. This is available when Trigger On is set to Row Added:

  1. 在画布上打开 Google 表格触发器节点。

¥Open the Google Sheet Trigger node on your canvas. 2. 选择添加新选项。

¥Select Add option. 3. 选择日期时间渲染。

¥Select DateTime Render. 4. 将“日期时间渲染”更改为“格式化字符串”。

¥Change DateTime Render to Formatted String.

Google 表格触发器节点现在会将日期、时间、日期时间和持续时间字段按照其数字格式格式化为字符串。

¥The Google Sheets Trigger node will now format date, time, datetime, and duration fields as strings according to their number format.

数字格式取决于电子表格的区域设置。你可以通过打开电子表格并选择“文件”>“设置”来更改本地设置。在“常规”选项卡中，将“区域设置”设置为你首选的区域设置。选择“保存设置”以调整值。

¥The number format depends on the spreadsheet's locale settings. You can change the local by opening the spreadsheet and selecting File > Settings. In the General tab, set Locale to your preferred locale. Select Save settings to adjust the value.