Overview
Etlworks supports robust email integration capabilities. You can read emails and attachments using POP3 or IMAP, and send emails using SMTP, Gmail API and Microsoft Graph API. Emails and attachments can be sent as part of an ETL transformation or independently using a dedicated Send Email Flow.
This article provides a starting point for using email in Etlworks, including key use cases, setup guides, and troubleshooting steps.
Create Email Connections
-
Inbound Email Connection: Used to read emails and attachments.
-
Outbound Email Connection: Used to send emails and attachments.
What You Can Do with Emails in Etlworks
Send emails and attachments
Send emails as part of a source-to-destination Flow or by using a dedicated Send Email Flow.
Send emails in HTML format
To send emails with HTML content, set the Content Type field in the Outbound Email Connection to text/html.
Read, filter, and delete emails and attachments
Use ETL Flows to extract, transform, and filter emails or attachments, with options to delete messages after processing.
Save emails and attachments to a folder
Use a high-performance Flow type designed to save email messages and attachments as files on the server.
Work with Gmail
Connect to Gmail to read or create messages and attachments.
Work with Office 365 and Microsoft Exchange
Use Etlworks to send and receive emails via Exchange Online or Microsoft 365.
Troubleshoot Sending and Reading Emails
If you encounter issues with sending or reading emails, you can enable debug logging for deeper insight.
How to enable debug logging
Add the following line to the Properties field of the Inbound or Outbound Email Connection:
mail.debug=true
With this setting enabled, additional debug information will appear in the Flow log. For example:
DEBUG SMTP: message successfully delivered to mail server
Related Resources
Send notifications from the scheduler
Automatically send emails when a Flow is executed by a schedule.
Configure email sender
Set up Global Email Sender parameters in the Mail configuration.
Send notifications on Webhook events
Trigger email alerts based on Webhook-driven events.
Videos
ETL with Email
Watch how to create Flows for sending and receiving emails and attachments.
Related Case Study
RecBi, a business intelligence provider, uses Etlworks to manage complex workflows across APIs, Salesforce, MySQL, email systems, Google Cloud, and more. With multistep, multi-tenant pipelines, Etlworks enables RecBi to efficiently serve diverse client needs.
Comments
0 comments
Please sign in to leave a comment.