Converting VBA scripts to Office scripts for easier automation

hey everyone, currently i have a VBA script that i manually run everytime a certain file is sent from a particular email address.

for context the flow of the automation is done this way:

file received through email -> automatic download -> manually trigger the VBA automation -> data from the sent file is transformed and kept in multiple different excel files.

the automation itself is slightly lengthy and complicated. It basically converts bunch of data from the file sent, breaks it into different files with the required pieces of data for upload.

what im trying to look at is, is there any way to basically eliminate this need to manually tiggering this vba automation myself? i get this report sent multiple times a month and as convenient, my vba automation has made this process its still a hassle 😂.

I've heard of Office scripts being an option but can anyone please let me know if its possible? any resources would also be beneficial.

thank you.