Secure Webhook API with Authentication and Supabase Integration

This n8n workflow demonstrates how to build a secure webhook API endpoint with authentication and integrate it with a Supabase database. It provides a foundational example for handling incoming webhook data, processing it, and storing it securely.

What it does

This workflow simplifies the process of receiving data via a webhook and persisting it in a Supabase table. Specifically, it:

1. Listens for incoming webhook requests: It acts as an API endpoint, waiting for external systems to send data.
2. Processes incoming data: The Edit Fields (Set) node is a placeholder for any data transformation or validation logic you might want to apply to the incoming webhook payload.
3. Integrates with Supabase: It's set up to interact with a Supabase database, allowing you to insert, update, or query data based on the webhook payload.
4. Responds to the webhook: After processing, it sends a response back to the system that initiated the webhook, confirming receipt or providing feedback.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running n8n instance (self-hosted or cloud).
• Supabase Account: An active Supabase project with a database table configured to receive your webhook data.
• Supabase Credentials: Your Supabase Project URL and Anon Public Key (or Service Role Key for more secure operations) to configure the Supabase node.

Setup/Usage

1. Import the workflow: Download the provided JSON and import it into your n8n instance.
2. Configure the Webhook Trigger:
   • Activate the Webhook node.
   • Copy the generated webhook URL. This is the endpoint you will send your data to.
   • (Optional but recommended for security): Configure webhook authentication within the Webhook node if your external system supports it (e.g., header-based authentication, query parameters).
3. Configure Supabase Credentials:
   • Click on the Supabase node.
   • Click "Create New Credential" if you haven't already.
   • Enter your Supabase Project URL and API Key (Anon Public or Service Role).
   • Select the desired operation (e.g., Insert, Update) and specify the table name and data to be sent from the webhook payload.
4. Configure Data Transformation (Optional):
   • Modify the Edit Fields (Set) node to transform or validate the incoming webhook data before it's sent to Supabase. You can add, remove, or modify fields here.
5. Configure Webhook Response:
   • The Respond to Webhook node is configured to send a simple 200 OK response by default. You can customize the response body and status code based on your needs.
6. Activate the workflow: Once configured, activate the workflow to make your webhook endpoint live.

Now, any data sent to your n8n webhook URL will trigger this workflow, process the data, and interact with your Supabase database.