Email

Email files to your destination with the Email connector.

Features

Setup guide

Follow our step-by-step Email connector setup guide to connect your Email account with your destination using Fivetran connectors.

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 the 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 your Email connection or contacting [email protected] or our customer support team.

Syncing spreadsheets

To sync Excel files, you must select xls/xlsx/xlsm as the file type in the connection setup form and specify the cell reference during connection 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 connection syncs data from the "Data2" worksheet starting at cell C3.

NOTE:

• We sync the data from the sheet and cell reference you selected. If you want to sync data from multiple sheets, you must set up multiple connections.
• 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: