Supabase ExtendedInstall

Summary

Update database table rows that match specified filter conditions with new column values.

Inputs

• uiMode — Determines whether to use simple form fields ('simple') or JSON structures ('advanced') for column values and filter definitions.
• table (required) — Name of the Supabase database table to update.
• columns — Column names and their new values to set when in Simple UI mode. At least one column value must be defined.
• jsonData — JSON object string containing column key-value pairs to set when in Advanced UI mode.
• filters — Filtering criteria (column, operator, value) when in Simple UI mode. At least one filter condition is required to execute the operation.
• advancedFilters — JSON object describing filter criteria when in Advanced UI mode. At least one filter condition is required to execute the operation.
• returnFields — Comma-separated list of columns to return from the updated rows (* returns all fields).

Output shape

a list of items

Returns one n8n item per updated row containing the fields specified in returnFields. If no rows match the filter conditions, returns a single item with empty data array, zero count, and a message indicator.

Examples

Example 1: Mark pending orders as processing

Table: orders, UI Mode: Simple, Columns: status = 'processing', Filters: status equals 'pending', Return Fields: id, status, updated_at

Example 2: Update user profiles using JSON in Advanced Mode

Table: profiles, UI Mode: Advanced, JSON Data: {"is_active": true}, Advanced Filters: {"role": {"eq": "member"}}, Return Fields: *

Links

• n8n community nodes installation guide