External Sync (BYOD)

External Sync (BYOD - Bring Your Own Database) lets you keep a copy of your bot results in external providers, so you maintain full control over your data.

What Is External Sync?

By default, Sendbot stores all conversation results in its internal database. With External Sync, you can automatically replicate that data to:

Supabase - A serverless PostgreSQL database
Google Sheets - Google spreadsheets
NocoDB - An open-source Airtable-style database
Webhooks - Any HTTP endpoint for custom integrations

Why Use It?

Data Ownership

Your data stays in your own database, not only in Sendbot’s cloud.

Integrations

Connect directly to your CRM, ERP, or BI stack without extra middleware.

Automatic Backup

Real-time redundancy for every result.

Custom Analytics

Use SQL or BI tools to run advanced analytics on your data.

Setting Up Sync

1. Open Bot Settings

In the editor, click “Results” -> “Storage” to open the storage settings.

2. Choose a Provider

Select one of the available providers:

Supabase
Google Sheets
NocoDB
Webhook

Requirements:

A Supabase project
An API key (anon or service_role)
Your project URL
A destination table name

Table setup:Your table should include a result_id column (text, unique) to prevent duplicates:

CREATE TABLE sendbot_results (
  id SERIAL PRIMARY KEY,
  result_id TEXT UNIQUE NOT NULL,
  answers JSONB,
  metadata JSONB,
  created_at TIMESTAMPTZ DEFAULT NOW()
);

Requirements:

A NocoDB instance (self-hosted or cloud)
An API token
A database and table already created

Table structure:Similar to Supabase, create a result_id column to avoid duplicates.

Requirements:

An HTTP endpoint URL (POST)
Authentication headers (optional)

Payload sent:

{
  "resultId": "abc123",
  "botId": "bot-xyz",
  "answers": [
    { "variableId": "var1", "content": "John" },
    { "variableId": "var2", "content": "[email protected]" }
  ],
  "metadata": {
    "startedAt": "2026-01-23T10:00:00Z",
    "completedAt": "2026-01-23T10:05:00Z"
  }
}

3. Configure Column Mapping

Define how your bot variables map to destination columns:

Bot Variable	Destination Column
`name`	`customer_name`
`email`	`customer_email`
`phone`	`phone`

4. Advanced Options

boolean

default:"true"

Also syncs data such as start time, completion time, and session origin.

array

Restricts sync to sessions that originated from specific domains only.

Technical Architecture

The system uses an Outbox Pattern architecture to guarantee reliability:

Reliability Guarantees

Encryption at rest: Payloads are encrypted before entering the queue
Automatic retries: Exponential backoff on failures
Configurable TTL: Records expire after 72h by default (RESULTS_SYNC_OUTBOX_TTL_HOURS)
Idempotency: Incremental versioning prevents duplicates

Monitoring

In the “Storage” tab under Results, you can see:

Sync status per result
Recent errors and retry count
Last successful sync

If you see 401 or 403 errors, make sure your provider credentials are correct and still valid.

Environment Variables

For self-hosted deployments, you can configure:

Variable	Description	Default
`RESULTS_SYNC_OUTBOX_TTL_HOURS`	Maximum time a record stays in the queue	`72`

Next Steps

Credentials

Learn how to configure credentials for each provider.

Get Started

Flow

Theme

Settings

Deploy

Results

User

Workspace

Guides

Misc

API Platform

Access & Identity

Workspace Management

Bot Engineering

Chat API

Analytics & Data

Billing & Usage

AI & Automation

Integrations & Channels

Infrastructure & Assets

What Is External Sync?

Why Use It?

Data Ownership

Integrations

Automatic Backup

Custom Analytics

Setting Up Sync

1. Open Bot Settings

2. Choose a Provider

3. Configure Column Mapping

4. Advanced Options

Technical Architecture

Reliability Guarantees

Monitoring

Environment Variables

Next Steps

Credentials

​What Is External Sync?

​Why Use It?

Data Ownership

Integrations

Automatic Backup

Custom Analytics

​Setting Up Sync

​1. Open Bot Settings

​2. Choose a Provider

​3. Configure Column Mapping

​4. Advanced Options

​Technical Architecture

​Reliability Guarantees

​Monitoring

​Environment Variables

​Next Steps

Credentials

What Is External Sync?

Why Use It?

Setting Up Sync

1. Open Bot Settings

2. Choose a Provider

3. Configure Column Mapping

4. Advanced Options

Technical Architecture

Reliability Guarantees

Monitoring

Environment Variables

Next Steps