Remove duplicate rows in Google Sheets

Two Google Apps Script solutions enhance Google Sheets functionality. The first script, removeDuplicateRows, programmatically eliminates duplicate rows from the active sheet while preserving the first occurrence of each entry. The second script, importJsonFromApi, enables users to pull live JSON data from an API endpoint directly into a spreadsheet without requiring external add-ons. Both tools can be executed via Extensions Apps Script or automated through triggers to maintain data integrity and live updates.