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)

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

The Email connector creates a single stream that processes all email attachments:

Description: Extracts and syncs data from email attachments
Supported Formats: CSV, JSON, JSONL, NDJSON
Sync Mode: Incremental (based on email received timestamp)
Primary Key: Combination of file path, line number, and modified timestamp
Output Schema: - _file (string): The S3 file path of the email - _line (integer): Line number within the attachment - _modified (timestamp): When the email was received - *data*: Matia flat the data objects into different columns