Skip to content

Google 表格节点常见问题#

¥Google Sheets node common issues

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

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

追加数组#

¥Append an array

要将数据数组插入 Google Sheets，你必须将数组转换为有效的 JSON（键，值）格式。

¥To insert an array of data into Google Sheets, you must convert the array into a valid JSON (key, value) format.

为此，请考虑使用：

¥To do so, consider using:

  1. 拆分 节点。

¥The Split Out node. 2. AI 转换 节点。例如，尝试输入类似以下内容：

¥The AI Transform node. For example, try entering something like: 

1
Convert 'languages' array to JSON (key, value) pairs.
3. 代码节点。

¥The Code node.

节点设置后，列名已更新#

¥Column names were updated after the node's setup

如果你在设置节点后 Google 表格的列名发生了更改，则会收到此错误。

¥You'll receive this error if the Google Sheet's column names have changed since you set up the node.

要刷新列名，请重新选择“映射列模式”。这应该提示节点再次获取列名。

¥To refresh the column names, re-select Mapping Column Mode. This should prompt the node to fetch the column names again.

列名刷新后，更新节点参数。

¥Once the column names refresh, update the node parameters.