Detailed instructions to help you set up the data source for File from Email
Lastly modified on: Wed, 5th June, 2024 at 11:58 AM
What is supported
- CSV file uploading automation is supported with this connector.
- Refresh schedule: Twice a day, 1 am and 1 pm (KST)
Prerequisite
- Any email account to send files to Adriel
- If the email account domain ends with ".ai"
- If integrated with ".com": enter the email with the changed domain of ".com" at Step 2-(3)
- If not integrated with ".com": please use a different email account that does not end with ".ai"
Instructions
- Move to Adriel's Connections page.
-
Type "File from Email" into the search bar.
- Fill in the "Sender's Email Address" and click "Submit".
- Fill in the "Name" for the data source and choose "File Type" that will be sent through email.
- Name: Any distinguishable name that you will see on the dashboard for this data source.
- File Type: Currently only CSV is available.
- Optional configuration if possible. If wanted, fill in the "Alternative Channel Name."
- No icon is provided as a default for this feature. However, there are channels that can use internally saved icons and display next to the channel name you just wrote down.
- Refer to this guide to input the correct name to display the icon.
https://academy.adriel.com/en/how-to-set-alternative-channel-name-for-file-db-data-source
- (Optional) Fill in the "File Name to Filter" and click "Submit".
-
The value can be a word found within the file name(s) that is used for filtering.
-
Ensure accurate capitalization(upper/lower case) for optimal results.
-
-
The data source setting is done. Since the refresh schedule is twice a day, please wait until 1 am/1 pm (KST) to refresh all the files sent to Adriel via email.
Unique rules for sending files and their usage
- Size Limitation
- Google email API has a limitation of 25MB per email. So, please ensure that the total file size of added attachments per email does not exceed 25MB.
- 1 email address per 1 data source
- If you are sending with multiple addresses, make several data sources with the setting
- For a single data source, one email should be used with the same email input in Step 1 and Step 2-(3).
- Data Overwriting
- If the attached file has an identical name with the same columns, the data will be overwritten.
- If the files share the same columns, multiple data sources can be selected together on the table widget.