How to connect File from Email to Adriel

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 

1. Move to Adriel's Connections page.

2. Type "File from Email" into the search bar.

3. Fill in the "Sender's Email Address" and click "Submit". 
4. Fill in the "Name" for the data source and choose "File Type" that will be sent through email. 
   1. Name: Any distinguishable name that you will see on the dashboard for this data source. 
   2. File Type: Currently only CSV is available.
5. 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
6. (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. 

7. 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.