This extractor allows you to import data from email attachments to Keboola Connection. It extracts data from systems generating exports only as CSV files attached to an email. It can also be used instead of repeated manual imports of CSV files.
Tables only get imported with the extractor running. The import is not triggered by an email being sent or received. When running, the extractor imports all emails received since its previous run. Therefore, it is a good idea to set up the extractor in a scheduled orchestration.
Create a new configuration of the Email Attachments extractor.
Each configuration corresponds to a single target email address. If you need
to import emails into different tables, it is advisable to create more configurations.
An email address for sending attachments will be generated when the configuration is created. Use it to send
files with the extension .csv
.
If needed, specify the primary key and CSV options under Import Settings.
Send an email with a data attachment to the generated email address. Use the following sample table:
date | new | lost | total |
---|---|---|---|
2016-03-29 | 8 | 5 | 256 |
2016-03-30 | 9 | 1 | 264 |
2016-03-31 | 15 | 3 | 276 |
With the email message content being completely arbitrary, all that matters are the attached files. The following conditions must be met:
Click Run and confirm.
If the extraction is successful, you will be able to check the processed data in the imported table by clicking on the link. There may be a delay between the time the email is sent, received, and picked up by the extractor.
Note: When multiple valid emails are received between the extractor runs, they are imported into separate tables
(data1
– dataN
). If this is not desired, time the sending of the emails and configure the extractor orchestration
to make sure only one email is processed at a time.