The program to write data to google.spreadsheet based on excel or csv file

Good afternoon. There is a csv file (but you can also have excel with separate columns for each parameter).

You need: Write a script that analyzes the csv file from the end (to overwrite the most recent data if they are duplicated) and finds on the google.table sheets (with the exception of some) rows, one of the cells that contains the phone number (the first digit can be written after 8 or 7) corresponding to the line in the csv file.

If the phone number is found on the google sheets of the table, then the date and time of payment from the csv file is recorded in cell "F" of the row containing this phone number, and the amount is recorded in cell G.

If the phone number is not found on the google spreadsheet sheets, the phone number, the date and time of payment and the amount are displayed by a message or error in the log of your program (file or console) with the comment "The number on the google.spreadsheet sheets was not found".

If the phone number is found on two or more lines of google.spreadsheet, then the phone number, date and time of payment and amount are displayed by a message or error in the log of your program (file or console) with the comment "The number on the google.spreadsheet sheets is duplicated".

If the phone number in the csv file is found again, then the latest information is recorded in the google spreadsheet.

What is the meaning of the program? So that we do not manually fill in cells F and G on 8 sheets of google.tables containing data (date, time and amount) about the last payment of customers.