How to read csv file, filter by category code and send mail to representatives

Can you please help…
i need to do a flow in rpa that will

  • take a csv file (columns "customer_No, status,product,date_ordered, category,Main_representative, Assistant_representative)
    ) from a folder D:\rpa\sales\customer_detail.csv
  • load full file in one main data table
  • filter by the column category code (8001, 8002) to move data in 1 data table dt_category_high and get the representative code from the customer.csv and lookup in the email csv to send mail to the corresponding representatives
  • filter by the category (8010) to a data table dt_category_low and send mail to a specific mailgroup cc the main rep. & assistant rep