Email Setup Guide

Prerequisites

To set up the Matia Email connection, you need a source that sends files as attachments through email.

Setup Guide

Step 1: Get Your Email Address

Once you create the integration, Matia will automatically generate a unique email address for this integration. This email address will be displayed in the integration settings.

The format will be: {email-id}@{matia-email-domain}

Step 2: Send Emails with Attachments

To sync data into Matia:

Send emails with data file attachments to the generated email address
Matia will automatically filter out the attachments and in the next sync will move the attachments data into the selected Warehouse

Supported Attachment Types

The Email connector supports the following file formats for data extraction:

CSV - Comma-separated values files
JSON - Single JSON object or array
JSONL - JSON Lines format (one JSON object per line)
NDJSON - Newline-delimited JSON (same as JSONL)

Attachments in any other format, including Excel workbooks, are skipped.

Troubleshooting

Email not being processed:

Verify the email address is correct
Ensure the attachment is in a supported format (CSV, JSON, JSONL, NDJSON)

Supported Streams

By default the Email connector creates a single stream covering every attachment. Defining table mappings instead creates one stream per mapping, each routed by the email subject and/or a file-name pattern.

Description: Extracts and syncs data from email attachments
Supported Formats: CSV, JSON, JSONL, NDJSON
Sync Mode: Incremental
Primary Key: Combination of file path, line number, and modified timestamp
Output Schema:
- _file (string): Path of the individual attachment. Each attachment of an email gets its own value, so two attachments in one message never collide.
- _line (integer): Zero-based line number within that attachment
- _modified (timestamp): When the email was received
- *data*: Matia flattens the data objects into separate columns