Hello 👋,please I really need an answer to this,i want to create an automation whereby immediately a file drops from ftp it immediately imports into a data extension,then create a filtered data extension from the data extension and lastly send an emai

Hi @Ngala Manasseh

For this automation, you need to use four activities viz.

1. File Transfer

2. Import File

3. Filter or SQL Query

4. Send Email

The entry source will be File Drop. Refer to the link on how to configure File drop Automation:

https://help.salesforce.com/s/articleView?id=sf.mc_as_define_a_triggered_automation.htm&type=5

1. For file transfer and Import Activity, refer to the link: https://help.salesforce.com/s/articleView?language=en_US&id=sf.mc_as_ftp_and_triggered_automation_scenario.htm&type=5

For Import File Activity, create a data extension to import the data from your file.

2. Filter or SQL Query:

Before using the filter Activity, you need to create a filter of the data extension and then use this filter in this activity.

Filter Activity: https://help.salesforce.com/s/articleView?id=sf.mc_as_filter_subscribers_or_contacts.htm&type=5

If using SQL, create a target data extension to store the filtered data from the SQL query.

3. Send Email: Use this activity to send emails to the contacts you have filtered using filter activity or SQL Query activity.

Refer to the link: https://help.salesforce.com/s/articleView?id=sf.mc_as_send_email_activity.htm&type=5

Save this automation. This automation will automatically run as the file is dropped on the FTP.

Refer to the screenshot for the sequence of Activities in Automation:

Hope this helps!

Thanks