Process automation in Google Sheets?

Question

Automation

We have two tables: 1 table

( Sales managers enter it, assemblers in the warehouse collect goods (pick) and send orders to NP) See screenshots

(ctr + C / cntr + B) we transfer data from table 1 to create a TTN. The data is partially in the cells (Payment method (on a card / cash on delivery) / phone number / Order amount), and the second part (full name / City / No. branch of the NP) in a note in cell E. I also

attached a screen.
1. One order is NOT one line - one line can be part of an order. It is necessary to make it so that in the order, as an example of three goods, the sum (Price) of three positions was summed up, as an option for two given data, phone number and date. If the date (variable value) and phone number (variable value) then we summarize the column with the price of the goods and combine them into one order.
2. Automatic transfer of data to table No. 2:
1. Note from column E (full name / City / No. of the branch of the NP);
2. Phone number from column F;
3. Amount for the whole order !!!!;

4. Method of payment.

This step needs to be automated! Does anyone have any solutions to the problem?

Answer 1

Google scipts or external language/API

Answer 2

It's easier to do all this in 1C.