Linking Missive as a source
Let AI connect your sources for you
Skip the manual setup — run this in your project and the wizard auto-detects your databases and APIs and connects them to PostHog.
Contents
The Missive connector automatically pulls your Missive shared inbox data – conversations, messages, comments, contacts, tasks, and more – into the PostHog data warehouse.
Prerequisites
Missive API access requires a Missive Productive plan. Organizations on other plans cannot create API tokens.
Adding a data source
- Go to the sources tab of the data pipeline section in PostHog.
- Click + New source and then click Link next to Missive.
- Create a personal API token in Missive. Go to Preferences > API and generate a new token.
- Back in PostHog, paste the token in the API token field and click Next.
- Select the tables you want to sync, set the sync method and frequency, then click Import.
Once the syncs are complete, you can start using Missive data in PostHog.
Available tables
| Table | Description | Sync method |
|---|---|---|
conversations | Conversations in the All mailbox, grouping messages, comments, and posts of one thread | Incremental |
messages | Messages in conversations such as emails, SMS, and chat messages (excludes drafts) | Incremental |
comments | Internal comments that team members add to conversations | Incremental |
posts | Posts added by integrations and automations | Incremental |
tasks | Tasks and tasked conversations | Incremental |
contacts | Contacts across all contact books | Incremental |
contact_books | Contact books (private or shared) | Full refresh |
contact_groups | Contact groups and organizations in every contact book | Full refresh |
organizations | Missive organizations the token owner is a member of | Full refresh |
users | Users in the organizations | Full refresh |
teams | Teams in the organizations | Full refresh |
shared_labels | Shared labels in the organizations | Full refresh |
responses | Canned responses (templates) | Full refresh |
Incremental tables sync only new or updated records on each run. Full refresh tables reload all data on each sync.
Sync behavior
Personal token scope
Missive API tokens are personal. PostHog syncs only the conversations, contacts, and other data that the token owner can see.
Conversation merges
When you merge conversations in Missive, the conversation_id on related entries (messages, comments, posts) can become stale. The Missive API doesn't signal merges – the merged conversation stops appearing. To correct stale conversation_id values after merges, run a full resync of the affected tables.
Fan-out tables
The messages, comments, posts, contacts, and contact_groups tables send one API request for each parent conversation or contact book. These tables can take longer to sync in large workspaces.
Configuration
| Option | Type | Required |
|---|---|---|
API token | password | Yes |
Supported tables
| Table | Description | Sync method | Incremental field | Primary key |
|---|---|---|---|---|
conversations | Conversations in the All mailbox of the token owner. A conversation groups the messages, comments and posts of one thread. | Incremental, Full refresh | last_activity_at | — |
messages | Messages in each conversation, such as emails, SMS and chat messages. Drafts are not included. | Incremental, Full refresh | delivered_at | — |
comments | Internal comments that team members add to conversations. | Incremental, Full refresh | created_at | — |
posts | Posts in conversations. Integrations and automations add posts to show content from other apps. | Incremental, Full refresh | created_at | — |
tasks | Tasks and tasked conversations that the token owner can see. | Incremental, Full refresh | last_activity_at | — |
contact_books | Contact books that the token owner can access. Contact books hold contacts and can be private or shared. | Full refresh | — | — |
contacts | Contacts in every contact book that the token owner can access. | Incremental, Full refresh | modified_at | — |
contact_groups | Contact groups and contact organizations in every contact book that the token owner can access. | Full refresh | — | — |
organizations | Missive organizations that the token owner is a member of. | Full refresh | — | — |
users | Users in the organizations of the token owner. | Full refresh | — | — |
teams | Teams in the organizations of the token owner. | Full refresh | — | — |
shared_labels | Shared labels in the organizations of the token owner. | Full refresh | — | — |
responses | Canned responses (templates) of the token owner and their organizations. | Full refresh | — | — |