Email

Email files to your destination with the Email Connector.

Features

Setup guide

Follow our step-by-step Email connector setup guide set up a Fivetran Email connector to send files to your destination.

Sync overview

The Email Connector is designed for scheduled email reports. It extracts one or more attachments from the email, parses the attachment data, and uploads it into your destination. Emails are deleted once attachments are extracted from them. Attachments are permanently backed up in an internal S3 bucket in case of a re-sync. You may delete these attachments by deleting the email connector, contacting privacy@fivetran.com, or by reaching out to our customer support team.

Syncing spreadsheets

To sync Excel files only, you must select xls/xlsx/xlsm as the file type in the connector setup form and specify the cell reference during connector configuration. We use the cell reference to sync contiguous data to the right of the cell and below it in the Excel worksheet.

Example:

Let's assume there are 4 excel worksheets in a workbook:

• Data1
• Data2
• Data3
• Data4

You want to sync your data from cell C3 of the "Data2" worksheet, then your cell reference will be "Data2”!C3. So, the connector syncs data from the "Data2" worksheet starting at cell C3.

NOTE: We do not support finding data ranges if the rows contain merged cells. We do not consider the rows with merged cells and skip them while finding data ranges.

(Applicable for append_file option) Primary keys

Fivetran adds the following columns as composite primary keys for a table: