How to pull specific data from an excel file and send daily emails

[nkazi01]

Hi I have an excel file with 5 different tabs that is being updated daily. New row of data is being added to each of the tabs daily. 

I need to send out a daily email using the data from two of those tabs. The data will consist of 3 rows (today's data, yesterday's data, and last quarter end data) along with the headers.

I have attached a sample input file i will be pulling data from. 

Below is what my email body should look like. 

Data# 1 --> (this is the 2nd tab of my excel file)

DATE	column 1	column 2	column 3	column 4	total	daily Change	QTD Change
6/30/2022	4,141	747,474	7,788	85,685	89,826	0.21%	0.00%
8/9/2022	87,878	787	555,252	42,542	130,420	-78.26%	45.19%
8/10/2022	45,454	4,545	24,242	4,242	49,696	-61.90%	-44.68%

Data#2 --> (this is the 4th tab of my excel file)

DATE	column 1	column 2	column 3	DoD Change	QTD Change
6/30/2022	45,454	212	1,254	1.83%	0.00%
8/9/2022	232	565	5,745	-92.43%	358.13%
8/10/2022	966	124	15,245	165.36%	1115.71%

Regards,

EMAIL SIGNATURE

[MarqueeCrew]

@nkazi01,

Are you asking if this is possible?  Is there a specific challenge in the exercise that is troubling you?  Are you asking the community to build the workflow for you?

How can we help?

Cheers,

Mark

[nkazi01]

@MarqueeCrew I am asking how this can be done. As in which tools to use to create a table in automated email. I could not find a way to add a table and pull in specific data from an excel file using the email tool. No, i am not asking the workflow to be built for me. Just to point me in the right direction.