Automating Marketing Reports

[Anonymous]

TLDR: I want to extract an attachment from an excel attachment and automate an excel script on the unprocessed reports and then send the output

1. So I have reports from Amazon that I have sent to a specific email on my Outlook folder each month.

2. I set up my Power Automate to trigger whenever an email with an attachment is received in this folder.

3. I want to take the attachment in this outlook email and run an excel script that I build on Excel Desktop (not an excel app Macro) to format the data.

4. And then I want to send the output/result (scripted email attachment) as the body of an email out to clients.

I've gotten the first and last parts to run but I can't get the script to process the file, that's the phase that always breaks that automation.

Things that I think might be causing the issue:

Do I need to extract the attachment from the email and save it as a file before I can run the excel script on it?

Does the attachment need to be saved through Share Point to be later referenced by the excel script?

Does the script need to be on the same or different cards as previous steps?

I've seen people run the excel script through a Scope

I've looked at every available youtube video to troubleshoot this, some go over certain steps in the process but I'm having a hard time threading everything together.

Other Things I've Tried

I also tried to build a macro that does the same thing as my excel desktop automation and then wrote VBA code so each time a new sheet is opened the same macro is ran, processing the data,

but I couldn't get it to run on any new future sheet that I open, even when writing the VBA auto-open code in Module as well as This Worksheet.

I'm open to any method that will make this work, I appreciate your time and expertise.