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. Split Out 节点。

  2. AI Transform 节点。例如，可以尝试输入如下内容：

    1
    Convert 'languages' array to JSON (key, value) pairs.

  3. 代码节点。

节点设置后，列名已更新(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.