Process and update data from Google Sheets, run Javascript, find or create row, and update spreadsheet

Process and update data from Google Sheets by extracting and transforming information, then finding or creating corresponding entries in another spreadsheet for clearer reporting and improved data accuracy.