You can't use this until you register with us!

Description

Load emails from an IMAP or POP3 mailbox into MySQL, with threading information.

Purchasing Options

everything plan

Available Actions

Load Emails

Load new emails from the mailbox into the Target Table.

Variables

Source Parameters
mail_server_connection_type required

Protocol used to read the mailbox.

imap_server

Credentials of the mailbox to load. Required when Mail Server Type is IMAP.

pop3_server

Credentials of the mailbox to load. Required when Mail Server Type is POP3.

sender_mask

Regular expression the From header must match for the email to be stored.

subject_mask

Regular expression the Subject must match for the email to be stored, e.g. (?i).*(order|invoice).*

start_point

Only emails received after this UTC datetime (YYYY-MM-DD HH:MM:SS) are loaded. Leave blank to start from now. Updated automatically to the newest email date after each successful run.

lookback_minutes

Also re-read emails dated up to this many minutes before the Next Run Start Point, to catch emails delivered late or sent with a slow clock. Already stored emails are not stored again.


Destination Parameters
db_connection required

Database where emails are stored.

target_table required

Table in schema.table format. One row per email (deduplicated), with threading columns (message_id, thread_id, in_reply_to, email_references) and processed_at / process_status / process_note / reply_message_id / reply_body left empty for downstream apps such as the AI Email Responder.

create_table_if_dne

Create the Target Table when it is missing.