---
title: Help Scout
description: Connect Help Scout, understand its sync behavior, and query every table and column it writes.
species: reference
---
# Help Scout

Connect Help Scout with OAuth using your Help Scout app credentials. The source writes 6 fixed tables under `titan.helpscout`.
```sql
select
  id,
  first_name,
  last_name
from titan.helpscout.customers
limit 10
```

## Connect Help Scout

1. Open **Apps**, choose **Connect app**, and select **Help Scout**.
2. Enter OAuth using your Help Scout app credentials.
3. Review the tables, then save the source.
4. Watch **Sync history** until the first run completes.

Credentials are stored as secrets. They never become lake columns or appear in query results.

## Sync behavior

Customers, conversations, mailboxes, users, tags, and workflows share one source schedule.

A new source syncs when you connect it and then follows its schedule. The default recurring interval is 4 hours. An interrupted run keeps its completed progress and retries safely.

Every lake table also has the [system columns](/v2/docs/concepts/your-lake#the-system-columns) `_synced_at` and `_deleted`; the column reference below lists source columns only.

## Table reference

### `customers`

`titan.helpscout.customers` has 7 source columns.

```columns table=helpscout.customers
id                                      integer pk          Source field `id`.
first_name                              string              Source field `firstName`.
last_name                               string              Source field `lastName`.
email                                   string              Source field `email`.
company                                 string              Source field `company`.
created_at                              datetime            Source field `createdAt`.
updated_at                              datetime            Source field `updatedAt`.
```

### `conversations`

`titan.helpscout.conversations` has 10 source columns.

```columns table=helpscout.conversations
id                                      integer pk          Source field `id`.
number                                  integer             Source field `number`.
subject                                 string              Source field `subject`.
status                                  string              Source field `status`.
type                                    string              Source field `type`.
mailbox_id                              integer             Source field `mailboxId`.
created_at                              datetime            Source field `createdAt`.
updated_at                              datetime            Source field `updatedAt`.
closed_at                               datetime            Source field `closedAt`.
assignee                                json                Source field `assignee`.
```

### `mailboxes`

`titan.helpscout.mailboxes` has 5 source columns.

```columns table=helpscout.mailboxes
id                                      integer pk          Source field `id`.
name                                    string              Source field `name`.
email                                   string              Source field `email`.
created_at                              datetime            Source field `createdAt`.
updated_at                              datetime            Source field `updatedAt`.
```

### `users`

`titan.helpscout.users` has 7 source columns.

```columns table=helpscout.users
id                                      integer pk          Source field `id`.
first_name                              string              Source field `firstName`.
last_name                               string              Source field `lastName`.
email                                   string              Source field `email`.
role                                    string              Source field `role`.
created_at                              datetime            Source field `createdAt`.
updated_at                              datetime            Source field `updatedAt`.
```

### `tags`

`titan.helpscout.tags` has 3 source columns.

```columns table=helpscout.tags
id                                      integer pk          Source field `id`.
name                                    string              Source field `name`.
color                                   string              Source field `color`.
```

### `workflows`

`titan.helpscout.workflows` has 6 source columns.

```columns table=helpscout.workflows
id                                      integer pk          Source field `id`.
name                                    string              Source field `name`.
type                                    string              Source field `type`.
status                                  string              Source field `status`.
created_at                              datetime            Source field `createdAt`.
modified_at                             datetime            Source field `modifiedAt`.
```

## Deletes and history

Rows are merged by their source key. When the source can prove that a row was deleted, Supernova keeps the row and sets `_deleted` so queries can choose whether to include history. Filter current-state queries with `where not _deleted`.