Upsert

Use this action to create new rows or update existing rows in a Supabase table.

Add the action

1. Create (or open) a workflow.
2. Click Add an action.
3. Select Interface → Supabase → Upsert.
4. Select the Supabase Connection you want to use.

Configure the action

• Table — The table you want to create or update rows in.
• Data — A list of items (each item is one row).

Conflict resolution

• On conflict columns (optional) — The columns Supabase uses to decide whether a row already exists (defaults to the table’s primary key).
• Ignore duplicates (optional) — If enabled, duplicate rows are ignored instead of updated.

Advanced

• Return columns (optional) — Choose which columns you want back after the upsert (default is all columns).

Common pitfalls

Rows are not updated (or you get duplicates)

Check your On conflict columns. They must match the columns that uniquely identify a row for your use case (often the primary key, or a unique column like email).

CONTINUE LEARNING

Learn how to use Supabase safely from WeWeb (including using WeWeb as an API layer).

Supabase integration →