Downloading data via API from Bitrix to generate a report on employee tasks

You need to make a script with the following functionality:

1. The administrator applies the filter through the web version
- which employee we are uploading (output from Bitrix)
- for what period we are unloading (for this week, for the last week, for a month, for an arbitrary period)
- under what transaction we make the unloading
2. After that, we download all the tasks from Bitrix and form an xlsx file from them.
The columns in the file are Deal Name, Task Name, Task Description, Task Result, Status, Creation Date, Deadline.
Sort the tasks by the name of the deal (so that one deal is next to each other)
3. Provide for automatic sending of a report by schedule to email - you do not need to build a convenient web version for this, but provide for the input of a command from the console to create a report and send it by email

If you have experience of such implementation, or maybe a ready-made similar solution - welcome in the comments)