Actions106
- 日历 Actions
- 多维表格 Actions
- 知识库 Actions
- 通讯录 Actions
- 任务 Actions
- 电子表格 Actions
- 云空间 Actions
- 消息 Actions
- 云文档 Actions
Overview
This node interacts with a spreadsheet service to delete specific sheets within a spreadsheet. It is useful when you need to programmatically remove unwanted or obsolete sheets from a spreadsheet document, for example, cleaning up reports or managing dynamic data sets.
A practical scenario would be automating the removal of temporary or intermediate sheets after processing data, ensuring that only relevant sheets remain in the final spreadsheet.
Properties
| Name | Meaning |
|---|---|
| 电子表格 Token | The token identifying the spreadsheet to operate on. This is required to authenticate and specify which spreadsheet contains the sheet to delete. |
| 工作表的 ID | The unique identifier of the sheet within the spreadsheet that should be deleted. |
Output
The node outputs JSON data representing the result of the delete operation. Typically, this will include confirmation of the deletion or any relevant metadata returned by the spreadsheet service about the deleted sheet.
No binary data output is indicated.
Dependencies
- Requires an API authentication token ("电子表格 Token") to access and modify the spreadsheet.
- The node depends on an external spreadsheet service API that supports sheet deletion via the provided token and sheet ID.
- Proper credentials must be configured in n8n to allow authenticated requests.
Troubleshooting
Common issues:
- Invalid or expired token: The node will fail if the provided token does not grant access to the spreadsheet.
- Incorrect sheet ID: If the sheet ID does not exist or is mistyped, the deletion will fail.
- Network or API errors: Connectivity issues or API rate limits may cause failures.
Error messages:
- Errors related to authorization typically indicate problems with the token; verify and refresh the token as needed.
- Errors indicating "sheet not found" suggest checking the sheet ID value.
- General API errors should be retried or checked against the spreadsheet service status.
Links and References
- Refer to the documentation of the spreadsheet service API for details on authentication tokens and sheet deletion endpoints.
- n8n documentation on how to configure credentials and use custom nodes.