Email (Incoming IMAP)

Mitto allows you to grab files from UNREAD email attachments and download them to Mitto's file manager.

The files can then be used in subsequent jobs (CSV, Excel, JSON, etc) to create the database tables.

Setup:

The following information is needed to create an IMAP job in Mitto.

Email account
Password
Email provider: Outlook, Gmail, etc.

Create an IMAP Job

Click on + Add in bottom left screen.

Choose "imap"

Fill out the form. Configuration options are described below.

Select "Next", then give the job a name and click "Done" to create the job.

Configuration Options

server

This is the IMAP server.
Gmail = imap.gmail.com
Outlook = outlook.office365.com

credentials

Create the credentials before hand with the username and password for your email account. Use the name for the credential here.
https://www.zuar.com/help/mitto/credentials/

label

This is the folder location of the emails.
This is case insensitive.
Removing this key/value pair or using inbox means you are looking at files in the inbox.
In order to look at lower level folders use quotes and forward slashes to separate the nested folders. Example (see image below)
"Inbox/csv"

filename_format

This is how Mitto will name the output file in the file manager.
{safe_root} represents the original file name.
{ext} represents the original file extension.
You can alter the file name by adding text (Example activity_visits_{safe_root}.{ext}) and/or datetime attributes (Example {safe_root}_{year}{month:02d}{day:02d}.{ext}).
Leave the file names unchanged by removing this key/value pair or using {safe_root}.{ext}

Example Job Config

{
    "credentials": "Credential Name",
    "filename_format": "{safe_root}.{ext}",
    "label": "path/to/folder",
    "server": "outlook.office365.com"
}

Gmail specifics:

Note: As of May 2022, "Less Secure App" access is no longer an option for free Gmail accounts. It is recommended that users leverage a different email server unless a paid Google Workspace Gmail account is available.

There are a few settings that need to be enabled on the Gmail side.

IMAP Access must have "Enable IMAP" selected. Details here.