Actions23
- Spreadsheet Actions
- Sheet Filter Actions
- Sheet Filter View Actions
- Filter Condition Filter View Actions
- Sheet Row Column Actions
- Sheet Data Actions
- Sheet Floating Image Actions
Overview
The "Lark Sheets" node provides integration with Lark Sheets, enabling users to manage and interact with spreadsheet data within the Lark Suite environment. It is designed for scenarios where automation workflows require reading, writing, or manipulating spreadsheet content programmatically. Typical use cases include syncing data between Lark Sheets and other applications, automating report generation, or updating sheets based on external triggers.
This node supports two authentication methods: a Tenant Token and OAuth2, allowing flexible access depending on the user's setup.
Properties
Name | Meaning |
---|---|
Authentication | Method of authenticating API requests. Options: "Tenant Token" or "OAuth2". |
Options | Additional settings for the request. |
- Use Custom Body | Boolean flag indicating whether to send a custom request body instead of default format. |
Output
The node outputs JSON data representing the response from the Lark Sheets API. This typically includes information about spreadsheets, rows, cells, or other sheet-related entities depending on the operation performed. The output structure aligns with the standard Lark Sheets API responses.
If binary data were involved (e.g., exporting sheets as files), it would be included in the binary output field, but this node primarily deals with JSON data.
Dependencies
- Requires an active Lark Suite account with API access.
- Needs either a Tenant Token or OAuth2 credentials configured in n8n for authentication.
- Connects to the Lark Suite Open APIs at
https://open.larksuite.com/open-apis
.
Troubleshooting
- Authentication errors: Ensure that the selected authentication method is correctly configured with valid credentials. Expired tokens or incorrect scopes can cause failures.
- API request failures: Check network connectivity and verify that the Lark Suite API service is operational.
- Invalid custom body: If using the "Use Custom Body" option, ensure the JSON body is well-formed and matches the expected API schema.
- Permission issues: Confirm that the authenticated user or token has sufficient permissions to perform the requested operations on Lark Sheets.