Sheet - Team L.C.L Excavation icon

Sheet - Team L.C.L Excavation

Read, update, write and delete data from Smartsheet API
Join our community

Actions13

Overview

This node interacts with the Smartsheet API to manage sheets and folders. Specifically, the Find Column (Using Title) operation under the Manage Smartsheet resource allows users to locate a column within a specified sheet by providing the column's title. This is useful when you need to dynamically identify a column ID based on its human-readable title for further operations like updating rows or reading data.

Common scenarios:

  • Automating workflows where column IDs are unknown but column titles are consistent.
  • Preparing data updates or queries that require column IDs.
  • Integrating Smartsheet data with other systems by referencing columns by name.

Example:
You have a sheet named "Project Tasks" and want to find the column ID of the column titled "Status" to update task statuses programmatically.

Properties

Name Meaning
Sheet Name or ID Select the target sheet by name or specify its ID. The list is dynamically loaded from your Smartsheet account.
Column Title Enter the exact title of the column you want to find within the selected sheet.

Output

The output JSON contains an object with a single property:

{
  "columnID": "<numeric_column_id>"
}
  • columnID: The unique identifier of the column matching the provided title in the specified sheet.

This ID can be used in subsequent Smartsheet API calls that require a column reference.

Dependencies

  • Requires a valid Smartsheet API authentication token configured in n8n credentials.
  • Access to the Smartsheet API endpoint https://api.smartsheet.com/2.0.
  • The node uses internal helper functions to make authenticated requests to Smartsheet.

Troubleshooting

  • Error: Column titled "<title>" not found.
    This means the specified column title does not exist in the chosen sheet. Verify the exact spelling and casing of the column title.

  • Sheet not found or invalid sheet ID
    Ensure the sheet exists and the correct sheet ID or name is selected.

  • API authentication errors
    Confirm that the API key credential is correctly set up and has sufficient permissions.

  • Empty or no options in "Sheet Name or ID" dropdown
    This may indicate connectivity issues or lack of sheets in the connected Smartsheet account.

Links and References

Discussion