Can anyone help me to design workflow.
Read the Excel sheet, check if Amount Spend >= Amount Allotted, if true then customer is not eligible for any further purchases, hence send an email with such type of customer info to ‘XXXXXX@mail.com’ with the exact status. If the above is not true than those customers are eligible for further purchase, hence list down those customers data into different sheet and send that sheet in email to ‘XXXXXX@mail.com’. Also the customers with Customer Class field as empty will not be considered for any further calculation, so you can simply ignore those types of customer.
Thanks in Advance…ExcelAutomation1.xlsx (9.7 KB)