Supabase
The Supabase block connects your workflow to a Supabase project. It covers the whole platform: table rows, user auth, file storage, Postgres RPC functions, Edge Functions, and pgvector similarity search — 14 operations in one block.
One credential, whole project: Connect once with your project URL and API key, then pick the operation you need from a single dropdown.
Looking to start a workflow when a Supabase table changes? Use the separate Supabase Trigger instead. This page covers the action block that reads and writes data mid-flow.
Key Features
- Row Operations: Insert, get, update, delete, and list rows via PostgREST
- Auth Management: Create users, send invites, and generate magic links
- Storage: Upload files, create signed URLs, and list objects in buckets
- Functions: Call Postgres RPC functions and invoke Edge Functions
- Vector Search: Run pgvector similarity search through your match function
Credentials
Click the credentials dropdown and create a Supabase Project connection:
| Field | Description |
|---|---|
| Project URL | Your Supabase project URL, e.g. https://xyzcompany.supabase.co |
| API Key | A service role key or an anon key |
The Auth operations (Create User, Invite User, Generate Magic Link) require the service role key. The anon key is enough for row reads that your Row Level Security policies allow.
Operations
| Operation | What it does | Main fields |
|---|---|---|
| Insert Row | Adds a row to a table | Table, Row Data (JSON) |
| Get Row | Fetches one row by a column match | Table, Match Column, Match Value, Select Columns |
| Update Row | Updates matching rows | Table, Match Column, Match Value, Row Data (JSON) |
| Delete Row | Deletes matching rows | Table, Match Column, Match Value |
| List Rows | Lists rows with filter, order, and limit | Table, Select Columns, Filter Column, Filter Value, Order By, Limit |
| Auth: Create User | Creates a user account | Email, Password, Email Confirmed, User Metadata (JSON) |
| Auth: Invite User | Sends an invite email | Email, Redirect To, User Metadata (JSON) |
| Auth: Generate Magic Link | Creates a passwordless sign-in link (returns action_link) | Email, Redirect To |
| Storage: Upload File | Uploads a file from a URL or from raw text | Bucket, Object Path, File URL or File Content, Content Type, Upsert |
| Storage: Get Signed URL | Creates a temporary download link | Bucket, Object Path, Expires In (seconds, default 3600) |
| Storage: List Objects | Lists files in a bucket | Bucket, Prefix, Limit |
| Call RPC Function | Calls a Postgres function with JSON params | Function Name, Params (JSON) |
| Invoke Edge Function | Calls functions/v1/{name} with a JSON body | Function Name, Body (JSON) |
| Vector Search (pgvector) | Runs a similarity search through your match function | Match Function (default match_documents), Query Embedding, Match Threshold, Match Count, Filter (JSON) |
Vector Search calls a Postgres function in your project with query_embedding, match_threshold, match_count, and filter. You must create this match function first — see the Supabase pgvector docs for the standard match_documents example.
Setting up the block
- Add the Supabase block (Database category) to your workflow.
- Select or create your Supabase Project credentials (Project URL + API Key).
- Pick an Action from the dropdown.
- Fill in the fields shown for that action. Every field accepts
{{variables}}. - Connect the block's output to the next step.
Example: Save a lead to a table
A form webhook triggers the workflow. Add a Supabase block:
- Action: Insert Row
- Table:
leads - Row Data (JSON):
{"name": "{{name}}", "email": "{{email}}", "source": "website"}
Every submission becomes a new row in your leads table. Add a second Supabase block with Auth: Invite User to send the new lead a sign-up invite.
Output
The block returns the Supabase API response. What you get depends on the operation:
| Operation type | Output |
|---|---|
| Row operations | The affected row(s) as JSON |
| Auth operations | The created user object; Generate Magic Link also returns action_link |
| Storage: Get Signed URL | The temporary signed URL |
| Storage: List Objects | The list of objects |
| RPC / Edge Function | Whatever your function returns |
| Vector Search | The matched rows with similarity scores |