Skip to main content
File from Email ingests CSV or XLSX files that arrive at a dedicated mailbox managed by Adriel. It supports two delivery modes, locked at creation: attachment mode processes files attached directly to incoming email, and download-link mode follows URLs embedded in the email body. Typical uses include partner-delivered reports, vendor data feeds, and scheduled exports from systems that already email out tabular data — no API credentials are required, because the inbox and authentication are managed centrally.

​
Before you connect

The following are required:
  • A sending email address that will deliver files to the workspace inbox. Send one handshake email from this address to automation-#####@adriel.ai, where ##### is the workspace ID found in the URL after accountId= or userAccountId= (for example, https://app.adriel.com/#/connection?accountId=#####&userAccountId=#####...).
  • A consistent sender allow-list, subject filter, or file-name fragment to identify the intended emails.
  • Confirmation of the delivery mode (attachment or download link), which is locked at creation.
  • For the upsert update method: the name of the column used as the unique key.
  • For download-link mode: the sending platform must whitelist Adriel’s static proxy IP 3.37.49.210. Without whitelisting, the file cannot be downloaded.
  • Total attached file size per email must not exceed Gmail’s 25 MB limit.

​
Connect File from Email

1

Add the data source and set the sender

On the Data Sources page, search for File from Email and select it. Enter the Sender’s Email Address and click Submit. To allow multiple senders, separate each address with a comma.
2

Choose the file delivery type

Set the File Delivery Type:
  • Attachment: choose this if the file is included directly in the email.
  • Download Link: choose this if the file is provided as a link inside the email body. The sending platform must whitelist Adriel’s static proxy IP 3.37.49.210, or the file cannot be downloaded.
3

Name the data source and set the file type

Enter a Name for the data source — any distinguishable label that appears on the dashboard — and choose the File Type (CSV or XLSX) that will be sent through email.
4

Set the optional fields

Configure the optional fields as needed:
  • Alternative Channel Name: customize the channel display name. See the Alternative Channel Name guide for the format that triggers icons.
  • Alternative Channel Icon: attach a file to customize the icon displayed.
  • File Name to Filter: a word found within the file name, used to select the correct file. Matching is case-sensitive.
  • Header Row: if the data does not start at row 1, enter the row number where the column headers are.
  • Data Update Method: choose how new data is stored — Append (default) adds the new file’s data to the end of the existing table; Replace completely replaces the saved table with the new file’s table; Upsert merges data using the required Unique Identifier Columns field, updating a row when a matching value exists and adding a new row when it does not.
5

Submit

Click Submit to complete the connection. The refresh schedule runs twice daily, so emails sent to the inbox typically become available after the next 1:00 AM or 1:00 PM (KST) refresh.

​
What gets imported

Each new matching email’s payload is parsed into rows and merged into a per-data-source cache table. The first row of every file is treated as the header; numeric columns become metrics and text columns become breakdowns. When a date column is mapped, dashboard date filters apply; without one, all rows are treated as a single snapshot. For XLSX workbooks, only the first non-empty sheet is read. For the complete field list and field-level behavior, see the File from Email data reference.

​
Troubleshooting

Attachment mode requires at least one matching email to already exist in the mailbox before the data source can be saved. Send or trigger a sample email that matches the sender and subject filters, then retry.
A newly arrived file has a different column count or type than the cached schema, so the data source disconnects until the schema is reconciled. Either correct the upstream export to match the original schema, or recreate the data source against the new schema.
Only the first non-empty sheet of a multi-sheet workbook is ingested. Consolidate the relevant data into the first sheet, or split the workbook into separate files.
Upsert mode was selected without specifying a unique-key column. Provide the unique key in Unique Identifier Columns, or switch the update method to append or replace.

File from Email data reference

Fields, update methods, and limits for File from Email.

File from Email FAQs

Common questions and expected behaviors for the File from Email data source.

How to connect File from OneDrive

Ingest CSV or XLSX files stored in OneDrive.

How to connect File from SFTP

Ingest tabular files delivered to an SFTP server.