# Freshchat + Supabase

> Connect Freshchat conversations, tickets, and support metrics to Supabase with Erathos. Incremental, no-code pipeline with full observability. Get started for free.

Source: https://www.erathos.com/en/pipelines/freshchat-supabase
Em português: https://www.erathos.com/pipelines/freshchat-supabase

Freshchat is a messaging and live chat platform designed to make communication between businesses and customers easier.

With Erathos, you can integrate Freshchat data into Supabase in just a few minutes. Our platform handles the entire data movement process to your open-source backend platform with PostgreSQL and allows that data to be combined with other sources. That way, your time is focused on what really creates value — extracting insights and making data-driven decisions.

### What Freshchat data does Erathos sync with Supabase?

The integration automatically syncs the main Freshchat objects:

- **Tickets and support requests** — status, priority, channel, and response time
- **Contacts and customers** — interaction history and profile data
- **Agents** — workload, SLA, and performance metrics
- **Categories and tags** — classifications and opening reasons
- **Satisfaction (CSAT)** — ratings, comments, and timestamps
- **SLA and metrics** — resolution time, first response time, and escalations

### Why sync Freshchat with Supabase?

In Supabase, your data is available through auto-generated REST and GraphQL APIs based on the schema — accessible directly from your application without extra layers. Row Level Security ensures that each user only sees the data they’re supposed to see. Ideal for product teams that want analytical data available in the application database in real time.

### How it works

Erathos connects to Freshchat via the official API and syncs your data incrementally — only new or updated records are processed in each run. You choose the sync frequency (from every 5 minutes to daily), the objects to sync, and the destination schema in Supabase. The sync uses intelligent UPSERTs in Supabase (PostgreSQL) to ensure data consistency. You choose the sync frequency, the objects to sync, and the destination schema. Each run is logged with full observability: execution time, rows processed, and alerts via Slack or email.

## Freshchat data in Supabase in minutes

### Ready-to-use Freshchat connector

Connect Freshchat to Supabase and automatically export data. Centralize customer support information for analysis — no spreadsheets and no scripts.

### Full control over your Freshchat pipelines

Configure scheduling, frequency, and sync type at the table level. Configure sync frequency and type on a per-table basis. Erathos uses smart UPSERT in Supabase — data is available via REST, GraphQL, and Realtime Subscriptions as soon as it lands in the database.

### End-to-end observability

Stop finding out about Freshchat failures only when the business team complains. Every run is logged with runtime, processed rows, and error context. Automatic alerts via Slack, Discord, or email as soon as anything goes off track — so your data stays fresh for analysis.

## Centralizing Freshchat data in Supabase has never been easier

Erathos is a data ingestion platform built for support and data teams. With the Freshchat connector, you automatically centralize conversations, tickets, and support metrics in Supabase — always up-to-date data, full visibility into every run, and zero maintenance.

## FAQ

### What is Erathos, and how can it help my business?

Erathos is a data ingestion platform built for reliability, transparency, and control. We help data teams connect tools like Freshchat to their data warehouse—with full observability into every run, zero maintenance, and none of the black-box opacity of traditional market tools.

### What data from Freshchat does Erathos sync to Supabase?

Erathos syncs Freshchat tickets, conversations, agents, response times, SLAs, and customer satisfaction with your data warehouse, enabling end-to-end support analytics.

### How often does Erathos sync data from Freshchat to Supabase?

You can set the sync frequency from every 5 minutes up to daily, on a per-table basis. Erathos uses incremental sync — only new or updated records are processed in each run, keeping the Freshchat pipeline efficient and Supabase costs predictable.

### What happens if a Freshchat sync fails?

Erathos automatically detects failures and sends alerts to your email, Slack, or Discord with full context — not just “job failed.” Smart retries handle transient errors, and every run is logged with runtime, rows processed, and error context so your team can debug in minutes, not hours.

### Is there a free trial period for the Freshchat connector?

Yes. Every Erathos connector includes a 14-day free trial. Connect Freshchat to Supabase and start syncing right away — no credit card required.
