Split a file accordgin to Multiple Rows (Name) , send different files to respective emails

[JHAROHIT]

Hello All,

I have a requirement wherein i have like 100 records, sample as below. These are stored in an excel spreadsheet.

Sr.No	Name	Email_ID	TestA	TestB	TestC
1	A	abc@test.com
2	X	xyz@test.com
3	R	row@test.com

The target requirement is to send out separate excel spreadsheets to the individual names  and ask them to enter the details in columns like Test1, TestB, TestC and so on and send back the emails.

The separate excel spreadsheets that would to the individual users would be like as below:

Sr.No	Name	Email_ID	TestA	TestB	TestC
1	A	abc@test.com

In addition to that, each excel sheet will have a guideline document (text) in the next tab.

Guidelines to enter the required missing data

What should be the best way to achieve this ?

[Raj · Accepted solution]

@JHAROHIT 
find the workflow attached for reference
also configure the email tool with smtp.

hope this helps you.
mark done if solved.

[JHAROHIT]

Thank you @Raj , let me try this out.