Microsoft flow (automation)

We have a project that needs to be automated. The first part is we need to extract some info from the emails as they come in into excel. The second part is sending emails at the end of the month with certain info from the excel spreadsheet and attaching a pdf document. However, some info from the spreadsheet needs to be added to the pdf document first such as the total.