Skip to content

Google 表格文档操作#

¥Google Sheets Document operations

使用此操作在 Google 表格中创建或删除电子表格。有关 Google Sheets 节点本身的更多信息，请参阅 Google 表格。

¥Use this operation to create or delete a Google spreadsheet from Google Sheets. Refer to Google Sheets for more information on the Google Sheets node itself.

This node can be used as an AI tool

This node can be used to enhance the capabilities of an AI agent. When used in this way, many parameters can be set automatically, or with information directed by AI - find out more in the AI tool parameters documentation.

创建电子表格#

¥Create a spreadsheet

使用此操作创建新的电子表格。

¥Use this operation to create a new spreadsheet.

请输入以下参数：

¥Enter these parameters:

¥Credential to connect with: Create or select an existing Google Sheets credentials.

  • 资源：选择“文档”。

¥Resource: Select Document.

  • 操作：选择“创建”。

¥Operation: Select Create.

  • 标题：输入要创建的新电子表格标题。

¥Title: Enter the title of the new spreadsheet you want to create.

  • 工作表：添加要在电子表格中创建的工作表的标题。

¥Sheets: Add the Title(s) of the sheet(s) you want to create within the spreadsheet.

选项#

¥Options

  • 区域设置：输入电子表格的语言环境。此操作会影响格式细节，例如函数、日期和货币。使用以下格式之一：

¥Locale: Enter the locale of the spreadsheet. This affects formatting details such as functions, dates, and currency. Use one of the following formats:

  • en(639-1)

  • fil(如果不存在 639-1 格式，则为 639-2)

    ¥fil (639-2 if no 639-1 format exists)

  • en_US（ISO 语言和国家/地区的组合）。

    ¥en_US (combination of ISO language and country).

  • 请参阅 ISO 639 语言代码列表 和 ISO 3166 国家/地区代码列表 获取语言和国家/地区代码。请注意，Google 并非支持所有语言/区域设置。

    ¥Refer to List of ISO 639 language codes and List of ISO 3166 country codes for language and country codes. Note that Google doesn't support all locales/languages.

  • 重新计算间隔：输入电子表格函数所需的重新计算间隔。这会影响 NOW、TODAY、RAND 和 RANDBETWEEN 的更新频率。选择“更改时”以在电子表格发生更改时重新计算，“分钟”以每分钟重新计算，“小时”以每小时重新计算。有关这些选项的更多信息，请参阅 设置电子表格的位置和计算设置。

¥Recalculation Interval: Enter the desired recalculation interval for the spreadsheet functions. This affects how often NOW, TODAY, RAND, and RANDBETWEEN are updated. Select On Change for recalculating whenever there is a change in the spreadsheet, Minute for recalculating every minute, or Hour for recalculating every hour. Refer to Set a spreadsheet’s location & calculation settings for more information about these options.

请参阅 方法：spreadsheets.create | Google Sheets API 文档了解更多信息。

¥Refer to the Method: spreadsheets.create | Google Sheets API documentation for more information.

删除电子表格#

¥Delete a spreadsheet

使用此操作删除现有电子表格。

¥Use this operation to delete an existing spreadsheet.

请输入以下参数：

¥Enter these parameters:

¥Credential to connect with: Create or select an existing Google Sheets credentials.

  • 资源：选择“文档”。

¥Resource: Select Document.

  • 操作：选择“删除”。

¥Operation: Select Delete.

  • 文档：选择要删除的电子表格。

¥Document: Choose a spreadsheet you want to delete.

  • 选择“从列表中选择标题”以从下拉列表中选择标题，选择“通过 URL”以输入电子表格 URL，或选择“通过 ID”以输入 spreadsheetId。

    ¥Select From list to choose the title from the dropdown list, By URL to enter the url of the spreadsheet, or By ID to enter the spreadsheetId.

  • 你可以在 Google 表格 URL 中找到 spreadsheetId：https://docs.google.com/spreadsheets/d/spreadsheetId/edit#gid=0。

    ¥You can find the spreadsheetId in a Google Sheets URL: https://docs.google.com/spreadsheets/d/spreadsheetId/edit#gid=0.

请参阅 方法：files.delete | Google 云端硬盘 API 文档了解更多信息。

¥Refer to the Method: files.delete | Google Drive API documentation for more information.