Filter sheet, create subsets and send each of them by email

[joajoajoajoajoajoajo]

Hi, guys! I need some help.

I have an excel spreadsheet that contains some store's data. 

I have another tabel with some emails:

 

I want to filter this original report by store, save new spreadsheets for each store and send them for the managers by the email. Can you help me with this issue? i failed to do it by my own.

ill attach the sheets and the workflow im trying to build

Ty guys

PS: fake sample data cause i cant share anything

EDIT: idk to post where, so i used the first post label that the site enables me to use

 

[Raj]

Added a flow for reference this will work
make some changes such as your username and smpt connection
else this method works.

[joajoajoajoajoajoajo]

shouldnt I use table and render tool?

[joajoajoajoajoajoajo]

it doesnt work yet