YOOV Lancode icon

YOOV Lancode

Interact with Lancode API
Join our community

Actions9

Overview

The YOOV Lancode n8n node allows you to interact with the YOOV Lancode API, specifically for managing worksheet items.
For the Item resource and Create operation, this node enables you to create a new item (row) in a specified worksheet, setting various field values such as text, numbers, dates, selections, members, and custom JSON fields.

Common scenarios:

  • Automating data entry into YOOV Lancode worksheets from other systems.
  • Integrating form submissions or CRM records into a structured worksheet.
  • Creating new records as part of a workflow triggered by external events.

Practical example:
When a new lead is captured via a web form, use this node to create a corresponding item in a YOOV Lancode worksheet, mapping form fields to worksheet columns.

Properties

Name Meaning
Worksheet ID The unique identifier of the worksheet where the new item will be created.
Text Fields Add one or more text-based fields. For each, specify:
- Field Name or ID: Select or enter the target field.
- Value: The text value to set.
Number Fields Add one or more number-based fields. For each, specify:
- Field Name or ID: Select or enter the target field.
- Value: The numeric value to set.
Date/Time Fields Add one or more date/time fields. For each, specify:
- Field Name or ID: Select or enter the target field.
- Value: The date/time value to set.
List Fields Add one or more list (selection) fields. For each, specify:
- Field Name or ID: Select or enter the target field.
- Value Name or ID: The option to select.
Member Fields Add one or more member fields. For each, specify:
- Field Name or ID: Select or enter the target field.
- Value: Either a single member ID or an array of IDs (e.g., ["id1","id2"]).
JSON Fields Add one or more custom JSON fields. For each, specify:
- Field Name or ID: Enter the target field.
- Value Name or ID: The JSON value to set.
Use Raw Output If enabled, returns the raw API response instead of a simplified object.

Output

  • The output is an array of objects representing the newly created worksheet item(s).
  • Each object contains the fields and values as returned by the YOOV Lancode API after creation.
  • If "Use Raw Output" is enabled, the structure matches the raw API response.
  • On error (if "Continue On Fail" is enabled), the output will include an object like:
    { "error": "Error message here" }

Dependencies

  • External Service: Requires access to the YOOV Lancode API.
  • API Credentials: You must configure lancodeApi credentials in n8n, including at least the API hostname and authentication details.
  • n8n Configuration: No special environment variables are required beyond standard credential setup.

Troubleshooting

Common Issues:

  • Missing or invalid Worksheet ID: Ensure the correct worksheet ID is provided; otherwise, the node will not create an item.
  • Field Mismatches: If a field name or ID does not exist in the worksheet, the API may reject the request.
  • Invalid Data Types: Supplying incorrect types (e.g., string instead of number) can cause errors.
  • Authentication Errors: Invalid or missing API credentials will prevent successful requests.

Error Messages:

  • "Worksheet ID is required": Make sure you have selected or entered a valid worksheet ID.
  • "Field not found" or similar: Double-check that all field names/IDs match those defined in your worksheet.
  • "The IDs must in array form": For member fields in array mode, ensure the value is a properly formatted JSON array of strings.

Links and References

Discussion