Skip to main content

Set Row

Sets a row in Microsoft Excel 365.

This node is also exposed as an AI Agent tool.

This node has 1 input port and 1 output port.

Common Properties​

Every node shares these.

  • Name — the node's display name on the canvas.
  • Color — the node's colour on the canvas.
  • Delay Before (sec) — wait this long before the node runs.
  • Delay After (sec) — wait this long after the node runs.
  • Continue On Error — carry on instead of failing the flow. Defaults to false.
info

When Continue On Error is true the error is not raised at all, so a Catch node will not see it either.

Inputs​

PropertyFieldDescription
RowinRowJSON object with column names as keys (e.g. {"name":"John"٫"age":30})
Row NumberinRowNumberRow number (1-based٫ e.g. 2 for first data row if row 1 has headers)
Workbook IDinWorkbookIDWorkbook ID from Open Workbook node
Worksheet NameinWorksheetIDWorksheet name (e.g. Sheet1٫ Sales)

Options​

PropertyFieldDescription
HeadersoptHeadersFirst row contains column headers (match input keys to header values)
JsonifyoptJsonifyInput keys use lowercase with underscores format (e.g. price_range matches Price Range)

Requirements​

  • Azure AD App (Client Credentials) — Use Azure AD app registration with client credentials for server-to-server authentication.
    • tenant_id — Tenant ID (text, required). Azure AD tenant ID (Directory ID)
    • client_id — Application (Client) ID (text, required). Azure AD application (client) ID
    • client_secret — Client Secret (password, required). Azure AD application client secret
    • user_email — User Email (Optional) (text, optional). Email of user whose OneDrive to access. Required for accessing user's OneDrive files.
  • OAuth2 (Delegated) — Authorize via browser to access Excel files on behalf of a user.
    • _redirect_url — Redirect URL (readonly, optional). Add this to your Azure app's Redirect URIs
    • tenant_id — Tenant ID (text, required). Azure AD tenant ID، or 'common' for multi-tenant
    • client_id — Application (Client) ID (text, required). Azure AD application (client) ID
    • client_secret — Client Secret (password, required). Azure AD application client secret

Store these in a Vault and reference the vault item from the node, rather than typing the secret into the property.

Get Row · Append Row · Delete Row

Elsewhere in the package: Open Workbook · Close Workbook · Create Workbook · List Workbooks · Get Workbook · List Worksheets · Create Worksheet · Delete Worksheet · List Tables · Create Table and 17 more

See also​