Lark Sheets icon

Lark Sheets

Lark Sheets Management

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.

Links and References

Discussion