Google 表格#

¥Google Sheets

使用 Google Sheets 节点可自动执行 Google Sheets 中的工作，并将 Google Sheets 与其他应用集成。n8n 内置支持多种 Google Sheets 功能，包括创建、更新、删除、追加、移除和获取文档。

¥Use the Google Sheets node to automate work in Google Sheets, and integrate Google Sheets with other applications. n8n has built-in support for a wide range of Google Sheets features, including creating, updating, deleting, appending, removing and getting documents.

本页列出了 Google Sheets 节点支持的操作列表以及更多资源的链接。

¥On this page, you'll find a list of operations the Google Sheets node supports and links to more resources.

Credentials

请参阅 Google Sheets 凭据以了解有关设置身份验证的指导。

¥Refer to Google Sheets credentials for guidance on setting up authentication.

操作#

¥Operations

文档

¥Document

创建是一个电子表格。

¥Create a spreadsheet.
删除是一个电子表格。

¥Delete a spreadsheet.
文档中的工作表

¥Sheet Within Document

追加或更新行：追加新行，或在现有行已存在时更新现有行。

¥Append or Update Row: Append a new row, or update the current one if it already exists.
追加行：创建新行。

¥Append Row: Create a new row.
清除来自工作表的所有数据。

¥Clear all data from a sheet.
创建新工作表。

¥Create a new sheet.
删除工作表。

¥Delete a sheet.
删除行或列：从工作表中删除列和行。

¥Delete Rows or Columns: Delete columns and rows from a sheet.
获取行：读取表格中的所有行。

¥Get Row(s): Read all rows in a sheet.
更新行：更新工作表中的行

¥Update Row: Update a row in a sheet.

模板和示例#

¥Templates and examples

常见问题#

¥Common issues

有关常见问题或建议的解决方案，请参阅常见问题。

¥For common questions or issues and suggested solutions, refer to Common issues.

What to do if your operation isn't supported#

If this node doesn't support the operation you want to do, you can use the HTTP Request node to call the service's API.

You can use the credential you created for this service in the HTTP Request node:

In the HTTP Request node, select Authentication > Predefined Credential Type.
Select the service you want to connect to.
Select your credential.

Refer to Custom API operations for more information.

Google 表格#

操作#

模板和示例#

相关资源#

常见问题#

What to do if your operation isn't supported#