How to send an order number to the manager's mail?

Question

Google Sheets

It was necessary to extract data from a Google spreadsheet, which was obtained based on filling out a form, and send it to the manager.

The manager makes an application for production through a google form, the data enters the table and is processed. And already from the received data it is necessary to send the order number and several files to the manager's mail.

Answer 1

See Google App Script,
or rather, here
You need to make a trigger on the Form submit event
You have incomplete initial data (you need an example of a table, form, on the basis of which the manager’s email is selected, what files, etc.)
Everything is implemented quite simply